Converting Total Time hh.hh to HH:MM:SS
Option1:
=TEXT(A1/24,"[h]:mm")
Option2:
=A1/24
format as [h]:mm
first option outputs text that looks like time, and the second option
outputs time in excel format. The brackets [] tell excel to output the total
hours instead of the time of day (ie at 24 hours it does not go back to 0:00).
"David A." wrote:
I have a total time of 56.50 hours I need to convert to HH:MM:SS (56:30:00)
total. Help, I have tried =Text(A1/24,h:mm:ss, this is not working for me.
Help, it's driving me crazy!
|