I need a formula to average the data below that is every 15 minutes and make an hour average. 8:00-8:45. The original data is a month long with data every 15 minutes and I need to convert the entire month to hourly data.
6/13/18 8:00 PM 1.0
6/13/18 8:15 PM 0.7
6/13/18 8:30 PM 1.6
6/13/18 8:45 PM 1.3
6/13/18 9:00 PM 1.1
6/13/18 9:15 PM 0.7
6/13/18 9:30 PM 1.2
6/13/18 9:45 PM 1.5
Solved by G. H. in 16 mins