Calc time with a lookback #2

[v1rt8]

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

 

[Per Jessen]

Hi Doug

You say that you have date of flight in A1, is all flight times in A4:J4
related to this date? If this is the case, can flight date be inserted in
A1:J1 ?

Is next date in G1 or ?

What do you need as a result, sum of hours, or a message OK/Not OK ?

Regards,
Per

 

[v1rt8]

Per, thanks for getting back. In response to your question yes all
flights/time are related to this date in A1. Here is a snapshot of what Day 1
looks like. 04:00 is a report time for work.
Your help is greatly appreciated...thanks
12/01/2009 04:00 Day 1 Flight Time & Limitations
1 2 3 4 5 6 7 8
05:00 08:00 10:10
06:48 09:12 11:15
01:48 01:12 01:15

 

[v1rt8]

The result I would like to have would be how many hours within preceeding 24
hours., preceeding week, preceeding month, within year. all from a date
backward.

 

[Per Jessen]

Hi Doug,

I get the picture of data layout for one day, but where are data for
prevuious day, month, year?

 

[v1rt8]

Hi Per,
This is a new spreadsheet and i started on 12/1/09, no data exists prior to
that date, however i could provide it if the formulas need it. (11/30/09
could contain info but no formulas for 24 hrs, wk, mnth, yr). There are other
dates after 12/1/09 up to and including 12/10/09, same type of data (the
other data not shown here would be a cell that sums for day, cell that sums
for wk, cell that sums for mnth, cell that sums for yr. they are in cells J6,
O3, P3, Q3 respectively, hopefully this helps.
I appreciate your interest in helping me, as i have stated this would
provide me with ease of use for work.

thanx
Doug

 

[Per Jessen]

Hi Doug,

To calculate running totals we need a data set of daily totals and dates.

Lets look at data for 12/01/09-12/10/09, where would you place all theese
informations in your worksheet? Do you want detailed information for current
day, and just totals for previous days?

If desired, you can mail me a workbook with some sample data and an exact
description of what you need.

Regards,
Per

 

[v1rt8]

Per:
email sent.

Hi Doug,

To calculate running totals we need a data set of daily totals and dates.

Lets look at data for 12/01/09-12/10/09, where would you place all theese
informations in your worksheet? Do you want detailed information for current
day, and just totals for previous days?

If desired, you can mail me a workbook with some sample data and an exact
description of what you need.

Regards,
Per




.