I need to do three things with this excel file.
1.Get rid of all negative values.
2. Second average all values in three hour increments beginning at hour ending in 00. For example
hour 00, 01, & 02 should have one averaged value with hour 02. Hours 03, 04, & 05 will have output three hour average with time ending in 05 and so on . As a result, there should be 8 three hour average increments for each day excluding increments that have an hour missing.
3. Exclude three hour increments that have one or more of the hours missing (due to no data or negative values that were removed in step 1.) Example, if hours end in 06, & 08. this three hour increment would be ignored.
Hours to be averaged should look like this
00-02, 03-05, 06-08, 09-11, 12-14, 15-17, 18-20, & 21-23.