View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jennifer Jennifer is offline
external usenet poster
 
Posts: 385
Default Averaging all values for each hour???

I have been trying for hours to try to figure this out. I have data that has
been recorded every few minutes over a two week period for temperature, say
time is in column A in mm/dd/yy hh:mm:ss and my temperature is in column B. I
have many different data sets not taken at equal times. Is there a way to
Average the temperature over each hour? so... formulate an If statement or
something like that where If(still in the same hour):then(add to previous
total/average)?

Any help would be great!!!
:)