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