View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy
 
Posts: n/a
Default would like to know how to convert 2 hours and 30 minutes into 2.5

Format the cell as numbers instead of time?

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"Steve MacDonald" <Steve wrote in
message ...
I'm trying to construct a pilot logbook in excel and am having trouble in
converting times. for example, a flight that takes off at 12:00 and lands
at
14:30 is 2.5 hours. Would love to know how to have the answer
automatically
convert the 2 hours and 30 minutes into 2.5 hours. Anybody help??!!

steve