I have a extensive table of weather data that has been collected every 10 minutes. In other words, each row has a data point of precipitation, wind speed and wind gust speed for every 10 minute interval. I would like to find the total precipitation for each hour (column E), and the mean wind speed (column F) and gust speed (column G) for that hour. Seems like its would be a simple matter of selecting every 6th row, and calculating the sum or average for the appropriate column for that row and the preceding five row, then looping through to repeat for the data six rows below, etc. etc. If useful, I have separate columns for the reading number (sequential, 1 - 4303; column A), date 144 rows for each date; column B), time (in HH:MM format, 24-hour clock; column C), and the unique numeric date/time value (e.g. 40844.3333 = 10/28/2011 at 08:00; column D).
Hopefully, this explanation makes sense.
Thanks for any help anyone can offer ...