One way (assuming the number is in A1):

=(INT(A1) + MOD(A1,1)*100/60)/24

Format the cell in an appropriate time format.

Hope this helps.

Pete

On Sep 25, 2:12 pm, mailrail
wrote:
One of my data sheets at work brings numbers into Excel as decimals. For
instance, 5 hours and 39 minutes is shown as 5.39. How can I get Excel to
convert this to 5:39 (semicolin instead of decimal)?