Count number of occurences within hourly periods

  • Thread starter Thread starter Scotty G
  • Start date Start date
S

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
 
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
 
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
 
Back
Top