Converting hours, minutes, seconds, to hours

[chouck]

How do you vonvert hours, minutes, seconds (129:39:00) to hours?

 

[Niek Otten]

If you mean decimal hours, multiply by 24 and format as General (or Number, not Time)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do you vonvert hours, minutes, seconds (129:39:00) to hours?
|

 

[Roger Govier]

Hi

If you mean how do you convert it to decimal hours, then multiply by 24 as
Excel stores hours as fractions of a day (24 hours)
With value in A1
=A1*24 result 129.55
Format the cell with the formula as General or Number
Format>Cells>Number>General

If you are saying you want it to display as 5 days 9 hours 33 minutes then
Format>Cells>Number>Custom>d:hh:mm:ss
5:09:33:00

 

[Ron Coderre]

If cell A1 contains an Excel Date/Time value (eg 129:39:00)

You can use a Custom Number Format to "display" the hours:
From the Excel Main Menu:
<format><cells><number tab>
Category: Custom
Type: [h]
Click [OK]

Or...you could use a formula to display the hours:
=TEXT(A1,"[h]")....which returns text
or
=--TEXT(A1,"[h]")....which returns a numeric value

Or...you could simply calculate the hours:
=A1/(1/24)

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Ron Coderre]

Of course, the last option I posted:
=A1/(1/24)

Should have been:
=A1*24

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

If cell A1 contains an Excel Date/Time value (eg 129:39:00)

You can use a Custom Number Format to "display" the hours:
From the Excel Main Menu:
<format><cells><number tab>
Category: Custom
Type: [h]
Click [OK]

Or...you could use a formula to display the hours:
=TEXT(A1,"[h]")....which returns text
or
=--TEXT(A1,"[h]")....which returns a numeric value

Or...you could simply calculate the hours:
=A1/(1/24)

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

How do you vonvert hours, minutes, seconds (129:39:00) to hours?

 

[chouck]

when I tried =A1*24 (129:39:00*24) I got the value 15.36. What I want to get
is the value 129 or 130 if there is a formula that rounds up.

 

[Bernard Liengme]

Try again. It does work!
best wishes

 

[David Biddulph]

Try firstly reading again what your screen is telling you, and secondly
reading again what you were told to do.

You tell us that you got the value 15.36, but if you look again I think
you'll find it is saying 15:36, not 15.36 (unless for some unknown reason
you decided to custom format the cell as hh.mm with a full stop instead of
the customary colon in the time format). [If you want to understand why
it's saying 15:36, try temporarily reformatting as [h]:mm, and then
calculate for yourself what 24 times your original 129:39 is.]

Roger told you:
"Format the cell with the formula as General or Number
Format>Cells>Number>General"
.... but how have *you* formatted the cell with the formula?

Read Roger's post again. Do as he said. Then see what answer you get.