Converting Total Time hh.hh to HH:MM:SS


G

Guest

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

Advertisements

G

Guest

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).
 
R

Roger Govier

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")
 
J

John T Kennedy

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 said:
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. said:
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!
 
P

Pete_UK

Answered in one of your duplicate posts.

Pete

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 said:
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")
Roger Govier
- Show quoted text -
 
Ad

Advertisements

R

RagDyeR

Have a little patience ... wait a while for answers!
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

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 said:
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. said:
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!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top