Thread
:
would like to know how to convert 2 hours and 30 minutes into 2.5
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Anne Troy
Posts: n/a
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
Reply With Quote