Converting hours, minutes, seconds, to hours
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" wrote in message
...
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" wrote in message
...
How do you vonvert hours, minutes, seconds (129:39:00) to hours?
|