View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KK KK is offline
external usenet poster
 
Posts: 4
Default 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