Function for Air Travel Time

[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

 

[Nick Hodge]

Glynda

=B1-A1

Check out this page for detail on times and dates in XL

http://www.cpearson.com/excel/datetime.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Norman Harker]

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

 

[Dana DeLouis]

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