Thread
:
Converting Total Time hh.hh to HH:MM:SS
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
David A.
external usenet poster
Posts: 64
Converting Total Time hh.hh to HH:MM:SS
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!
Reply With Quote
David A.
View Public Profile
Find all posts by David A.