That will just show .1 Anne, you also need to multiply by 24

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Anne Troy" wrote in message
...
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