View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
penny penny is offline
external usenet poster
 
Posts: 1
Default formula to convert 15 minute to hourly data

Hi,
I tried to use this and it works but how can I get the B2:B5 range to begin
at the ending cell (i.e. B5) and calculate each subsequent range accordingly.
My problem is that if I am averaging every 15 minute data for each hour I
would like for it to calculate B2:B5, B5:B8, B8:B11,etc...Any help would be
much appreciated. Thank you for taking the time to look at this.

url:http://www.ureader.com/msg/10356248.aspx