Averaging intervals of data
 

Each hour is divided into 15 min intervals. I want to average 4
intervals, every hour. How do I do this? Here's a screenshot of some
example data.

http://www.aww-kittah-aww.com/up/public/73732/xls.jpg

Averaging intervals of data
 

Hi,

In the case of your sample enter the following formula in F1 and copy it down:

=AVERAGE(B1:E1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"KK" wrote:

Each hour is divided into 15 min intervals. I want to average 4
intervals, every hour. How do I do this? Here's a screenshot of some
example data.

http://www.aww-kittah-aww.com/up/public/73732/xls.jpg