View Single Post
  #1  
Old June 2nd, 2010, 02:29 PM posted to microsoft.public.excel.worksheet.functions
Chris26
external usenet poster
 
Posts: 17
Default average if - between range

Hi
I have the following data
Col-A Col-B
1/10/2009 10:20 0.006
1/10/2009 10:22 0.007
1/10/2009 10:24 0.006
........
1/06/2010 15:00 0.015

etc
What I would like to be able to do, is to calculate the average of the
vaules in Col B only between certain time periods i.e. 2am and 4am for each
day in the data set

Any help appreciated.
Many Thanks
Chris