convert number to hh:mm
 

I have a calculation returns the value of 26.4 - which is actually 26 hours
and 24 minutes. What formula would I need to use to use the hh:mm format and
return 26:24.
Thanks so much!!!
--
maryj

convert number to hh:mm
 

=A1/24
If you want a display like 26 hours, you will need the [hh]:mm Custom
format.

HTH
Kostis Vezerides

convert number to hh:mm
 

Thanks! That did it. Forgot about the brackets around the hour.

-- maryj


"vezerid" wrote:

=A1/24
If you want a display like 26 hours, you will need the [hh]:mm Custom
format.

HTH
Kostis Vezerides