| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calc time with a lookback #2
Per:
email sent. "Per Jessen" wrote: 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" skrev i meddelelsen ... 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" wrote: Hi Doug, I get the picture of data layout for one day, but where are data for prevuious day, month, year? --- Per "v1rt8" skrev i meddelelsen ... 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 "Per Jessen" wrote: 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" skrev i meddelelsen ... 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 . . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating time with a lookback | Excel Discussion (Misc queries) | |||
| IRR Lookback and Solver | Excel Worksheet Functions | |||
| Time Calc 24 hrs | Excel Worksheet Functions | |||
| Time Calc | Excel Worksheet Functions | |||
| time sheet calc by time in and out | Excel Worksheet Functions | |||
Hybrid Mode
