The data I have is very basic:
Date || Military Hour of Call (0-23)
I need to calculate the number of times the number of calls exceeded 2 (occurences) in any hour interval and graph it by day of the week and hour.
I've not been able to find the calculation that would tell me if "on x day at y hour there was more than one call which occured" AND only count it one time (not one time for every time it occurred.)
Example
Date Hour
1-1-01 1200
1-1-01 1245
1-4-01 0800
1-4-01 0810
1-4-01 0855
For 1-1-01 two calls occurred during the noon hour - if I did a =countifs($a$2:$a$6,"="&$a2,$b$2:$b$6,"="&b2) the result would be 2 (for 1-4-01 the result would be 3!). I just need to know that it occurred at all - then I need to be able to add the number independently for all days of the week.
This is a the begining of a staffing model - trying to determine the likelyhood of more than one call occuring during a particular hour on a particular day of the week.
Help??
Bookmarks