convert number to hh:mm

M

maryj

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!!!
 
V

vezerid

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

HTH
Kostis Vezerides
 
Top