Converting hours, minutes, seconds, to hours


Ad

Advertisements

N

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?
|
 
R

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
 
R

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

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)

Ron Coderre said:
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)

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

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

Advertisements

Ad

Advertisements

D

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.
 

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