dragandpaste

Q: Calculate the mean per time slot ?

Hi Chaps,

 

I'm an absolute beginner on Numbers (almost everything on Mac i would say) and i need help to calculate mean values.

Those are calculated values (Column 2) taken on a precise moment of the day (Column 1).
I managed to create a third using an integrated function to get the time slot (Column 3).

 

14:58:42

235

14

14:59:42

274

14

15:00:50

7937

15

15:01:55

5157

15

16:02:57

1822

16

16:03:57

207

16

 

Can please someone show me step by step how to calculate the mean value per time slot like below?

 

14

254,5

15

6547

16

1014,5

 

Regards,

 

Pierre

Posted on Sep 17, 2016 10:13 AM

Close

Q: Calculate the mean per time slot ?

  • All replies
  • Helpful answers