Count number of occurences within hourly periods

[Scotty G]

I am trying to calculate the number of Customers within
each hourly period during the day - for statistical
analysis. ie how many callers between 9 am and 10 am

 

[Jazzer]

Hi,

put in E2:E11

8:59
9:59
10:59
.....
17:59

Now select F1:F11 and type the following formula

=FREQUENCY(A1:A100,E2:E10)

and press ctrl+shift+enter to enter this formula to the selected are
as an array function.

This example assumes that the times are entered in format hh:mm i
the area of A1:A100.

Hope this helps.

- Asse

 

[Randall Roberts]

with the time of the calls in column a you can simple use

=COUNTIF(A:A,">9:00")-COUNTIF(A:A,">10:00")

this will give you a count of all the calls between 9 am an 10 am

For pm just adjust the times to military time or add a PM after the
time

Randall