On 25 Sep, 14:12, 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)?

Hello

Assuming your value in A1 then you can use the following general
purpose formula (and copied down as far as you have data):

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

Richard