View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Converting hours, minutes, seconds, to hours

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?