It would not be all that hard at all to modify that workbook to express
in "flights" instead of "jobs".

For flights, however, I would think that one would want a daily log,
so the sheet could be broken down into specific segments, like 2 Hrs each
or such.

Or it could be used as a yearly log for a single plane, where every
flight or even maintenance periods could easily be defined to explain
periods of non-flight, etc.



On Mon, 28 Dec 2009 17:30:00 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:

The time cells on this sheet are exactly what you want.

The sheet even has time increment selection available.


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


You can easily use the math functions, and the rest as well, if you
like.

The time gets entered in mil format, but appears as standard time
because of the drop down list. The cells that perform the math
calculations are dead on what you want, however.


\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.