Thread
:
Converting Total Time hh.hh to HH:MM:SS
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
RagDyeR
external usenet poster
Posts: 3,572
Converting Total Time hh.hh to HH:MM:SS
Have a little patience ... wait a while for answers!
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
"John T Kennedy" <John T
wrote in message
...
I need the inverse - I need to change a total time, like 35:45:00 to a
decimal, 35.75.
Thanks in advance for the help.
jk
"Roger Govier" wrote:
Hi David
You need a set of quotes around the formatting.
Also, if you want to show values over 24 hours, it needs to be
[h]:mm:ss.
=TEXT(A1/24,"[h]:mm:ss")
--
Regards
Roger Govier
"David A." wrote in message
...
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
RagDyeR
View Public Profile
Find all posts by RagDyeR