@Cnporteus, yes saw that one, didn't work for high enough hours though.

@Laurie - Thanks for this tweaked it to:

declare @time decimal(5,2);

set @time = 95.75

select replace(cast(convert(decimal(10,2),cast(@time as int)+(((@time-cast(@time as int))*.60))) as varchar),'.',':')

Which seems to work nicely

Thanks a lot.