Working on a Numbers log book for my flight time

Hi Jesper,

This may get you started.

Date & Time formats in Numbers work well once you understand that Numbers will "guess" an incomplete Date & Time and fill in the missing parts with today, this month and this year..

Enter the Out times on the actual day when you fly out. For example, 7:00. Numbers will fill in the day, month, year.

Enter the In times on the actual day when you fly in.

Or, enter the Date & Time explicitly. That will avoid the "crossing midnight" problem (Row 3) where you can get a negative Duration if Numbers does the guessing for you and thinks both times are on the same day 😉.

Formula in C2: B2−A2 (and fill down).

With the cells formatted as Duration

I don't understand the question "find flight hours for the past 672 hours, 6months and year to date?"

More information may lead to a solution!

Happy flying!

Ian.

CaptainJesper wrote:

How do I create formulas to look back and find flight hours for the past 672 hours, 6months and year to date?

You can consider something like this:

You can hide column B of the Summary table once you've got it working. (C and E in the example are just to display the formulas used in the screenshot).

Note that this sums according to the Out time. You can change to In time by referring to A instead of B.

If you need to convert the hours to a number instead of duration (perhaps for use in further calculation) then use the DUR2HOURS function.

SG

CaptainJesper wrote:

If I add up the hours from "Log" 01/01/2022-03/06/2022 I come up with 24hrs.

True, but if you sum the hours from the beginning of the year to now (i.e., not including future dates) then you should get 12hrs using my example.

SG

Hi again Jesper,

Yellowbox wrote:

I don't understand the question "find flight hours for the past 672 hours, 6months and year to date?"

Ok, now I get it. 672 hours is the past 4 weeks.

Past 6 months is more complicated because Durations do not include months (varying number of days, 28, 29, 30, 31). We might have to use the DATEDIF function.

Year to date is feasible.

Regards,

Ian.

▷ Numbers User Guide. 

Allot of my complex formulas were trial and error until I figured it out.

Always make a local backup once you do! 😉