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!

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!

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." <(E-Mail Removed)> wrote in message
news:688E1508-ACFD-46B6-A042-(E-Mail Removed)...
>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!

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." <(E-Mail Removed)> wrote in message
> news:688E1508-ACFD-46B6-A042-(E-Mail Removed)...
> >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!
>
>
>

Answered in one of your duplicate posts.

Pete

On Dec 28, 4:18*pm, John T Kennedy <John T
Kenn...@discussions.microsoft.com> wrote:
> 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." <Dav...@discussions.microsoft.com> wrote in message
> >news:688E1508-ACFD-46B6-A042-(E-Mail Removed)...
> > >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!- Hide quoted text -
>
> - Show quoted text -

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 (E-Mail Removed)> wrote in message
news74BC3EE-8E05-4FE2-AF73-(E-Mail Removed)...
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." <(E-Mail Removed)> wrote in message
> news:688E1508-ACFD-46B6-A042-(E-Mail Removed)...
> >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!
>
>
>