L
locke
I work in the airfield industry and use access to track flight hours.
Doing this manually is sometimes time consuming especially when I need
to train new personnel.
Could someone help me out with a formula for figuring out the
difference between two flight times. ie take-off and land
Here's the tricky part, all times must be entered in 24 hour clock
standard and use a different type of conversion.
ex. The flight time for an aircraft that takes off at 2142 one evening
and lands at 0624 the next morning is 8.7 hours.
Here's the conversion table:
01 or 02 min - .0 hr
03 thru 08 min - .1 hr
09 thru 14 min - .2 hr
15 thru 20 min - .3 hr
21 thru 26 min - .4 hr
27 thru 33 min - .5 hr
34 thru 39 min - .6 hr
40 thru 45 min - .7 hr
46 thru 51 min - .8 hr
52 thru 57 min - .9 hr
58 thru 60 min - next whole hour
Doing this manually is sometimes time consuming especially when I need
to train new personnel.
Could someone help me out with a formula for figuring out the
difference between two flight times. ie take-off and land
Here's the tricky part, all times must be entered in 24 hour clock
standard and use a different type of conversion.
ex. The flight time for an aircraft that takes off at 2142 one evening
and lands at 0624 the next morning is 8.7 hours.
Here's the conversion table:
01 or 02 min - .0 hr
03 thru 08 min - .1 hr
09 thru 14 min - .2 hr
15 thru 20 min - .3 hr
21 thru 26 min - .4 hr
27 thru 33 min - .5 hr
34 thru 39 min - .6 hr
40 thru 45 min - .7 hr
46 thru 51 min - .8 hr
52 thru 57 min - .9 hr
58 thru 60 min - next whole hour