Updated to include mil time selections.

Just select mil in the increment selection dialog on the info page.

_http://www.mediafire.com/?o4lj4ljzymm




On Mon, 28 Dec 2009 10:49:01 -0800, JB Bates
wrote:

I am looking to do the same thing but we do not use the government time
calculation for our flight time.

We use

0-2 = .0
3-8 = .1
9-14 = .2
15-20 = .3
21-26 = .4
27-32 = .5
33-38 = .6
39-44 = .7
45-50 = .8
51-56 = .9
57-59 = 1.0

Any suggestions?

"Teethless mama" wrote:

A2: T/O
B2: LAND

In C2: =ROUND(MOD(TEXT(B2,"00\:00")-TEXT(A2,"00\:00"),1)*24,1)


"Hercdriver" wrote:

I need to add aircraft takeoff and land times in a 24 hour (military) format
to come up with flight hours in a decimal format across days (the date itself
is not important).
Example:
Takeoff 2231 to land 0138 the next morning is 3.1 hours of flight time and
would look like this:
T/O LAND Hours
2231 0138 3.1

The tenths of hours are standard flight time accounting and go like this:
0-5 min= .0, 6-11 min= .1, 12-17 min= .2, 18- 23 min= .3, 24-29 min= .4,
30-35 min= .5, 36-41 min= .6, 42-47 min= .7, 48-53 min= .8, and 54-59 min= .9.

I'll be using Excel 2002 to do this, if it can be done at all. Thanks in
advance.