Each hour is broken into 15 minute intervals. I'd like to average four
intervals in each hour. How do I do that?

There are many intervals so I need a quick solution, can't do it
manually.

Here's a screenshot of example data:

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