Function for Air Travel Time

  • Thread starter Thread starter gamox
  • Start date Start date
G

gamox

Can someone please help me with a formula for calculating minutes o
airtime for a pilot.

Say I am using three colums. A B and my answer in C. The beginnin
air time say 10:30 am arrival time is 1:30 pm can you tell me ho
to build a formula in Column C to show actual time in the air. In thi
case three hours.

Thank you so much for some help.

Glynda Amox
Haines Alask
 
Hi Glynda!

Make sure that you input the times in the format recognised as time by
Excel:

eg
A1:
8:00
B1
18:30

Then the difference can be calculated using either of the following:

=B1-A1+(B1<A1)
Or
=MOD(B1-A1,1)
Format hh:mm

Both formulas address the possibility of the B1 being after midnight.
If the times are more than 24 hours apart, you should include the date
in both time inputs.

If you want to show just the number of minutes, use the format

[mm]

The [ and ] stop the minutes "rolling up" into hours.

For more on times, see:

Chip Pearson:
http://www.cpearson.com/excel/datetime.htm#AddingTimes
 
I was going to suggest including Time Zones, until I found where Haines Ak
airport is. So, never mind. Must be a beautiful 3 hour flight in any
direction! :>)

Dana DeLouis
 
Back
Top