Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple averages in large continous data field
I figured I'd try this once more. :-)
In column C I have the date, in column D I have the time, and in column E I have a measurement taken at that date/time period. Theres 25,000+ rows of this data, so doing what I need wouldnt be something easily done manually. Based on the date and time, I would like to find the average of the measurements taken per date, per shift. Day shift is 7:00 AM until 9:00 PM, and night shift is 9:01 PM until 6:59 AM. The night shift does not need to be spread across dates, as for example, August 30, 9:00 PM until midnight is a separate date than August 31, 12:01 AM until 6:59 AM. I would like to post the results for each shift per date in column G at the first two rows per date. There are about 200 rows per date, so where the results would be about 200 rows apart. Is there anyway this can be done? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple averages in large continous data field | Excel Discussion (Misc queries) | |||
Averages formula for multiple ranges | Excel Worksheet Functions | |||
Pivot Table - Dragging multiple items into data field | Excel Discussion (Misc queries) | |||
how do i get field name from result of MAX or LARGE function | Excel Worksheet Functions | |||
Compile/Analyze Word Form Field data from multiple forms? | Excel Discussion (Misc queries) |