Posted an earlier thread, but not what i am looking for. Any help is
appreciated.
This is a personal spreadsheet to use for my job. Req's are that i not fly
8.0hrs/24hrs, and not 30hrs/week, and not 100hrs/mnth, and not 1000hrs/yr.
Cell A1 contains date of flight.
A2 thru J2 contain times started: examples:
14:00 16:30 18:00
A3 thru J3 contain times ended: examples:
15:45 17:30 20:10
A4 thru J4 contain times of each flight: examples:
1:45 1:00 2:10

The formulas I need help on is in calculating if in the preceeding 24 hours
have I gone over 8 hours in that period. Same for week, month, year.

Note: putting the date & time together in one cell is too much.
Thanks in advance for any input.
Doug