would like to know how to convert 2 hours and 30 minutes into 2.5
 

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

would like to know how to convert 2 hours and 30 minutes into 2.5
 

Multiply the result by 24.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.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

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

would like to know how to convert 2 hours and 30 minutes into 2.5
 

If the takeoff and landing times are in A2 and B2, respectively, then
=24*(b2-a2), formatted as a number, will tell you the hours in flight.
--Bruce

"Steve MacDonald" wrote:

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

would like to know how to convert 2 hours and 30 minutes into 2.5
 

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

would like to know how to convert 2 hours and 30 minutes into 2.5
 

LOL, Bob. I *always* forget that. :)
Thank you!!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"Bob Phillips" wrote in message
...
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