View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aude aude is offline
external usenet poster
 
Posts: 2
Default Formula, means and non following cells

Hi,

I've got 2 colomns, one with dates and times, and one with temperatures. I
ve been recording temperature every hour for 3 weeks.

I want to know the mean temperature for days and the mean temperature for
nights during these 3 weeks.

Is there any formula that I could use to get a mean of data included betweem
8am-17 pm (day) and between 18pm-7am (night) ???

Thanks