willhh3
04-14-2011, 03:46 PM
Hello,
I need some help figuring this one out. Essentially I need a formula to get a count of how many calls are received on a given day, during a given hour.
For example: 2 Calls were received on 1/1/2011 during the 3am hour.
I'm guessing I'd put the formula in each cell (i.e., i2,j2,k3, etc.). Please ref the attached example of to see what I'm trying to do. I am open to a better format, if you can suggest any.
Thanks!
I need some help figuring this one out. Essentially I need a formula to get a count of how many calls are received on a given day, during a given hour.
For example: 2 Calls were received on 1/1/2011 during the 3am hour.
I'm guessing I'd put the formula in each cell (i.e., i2,j2,k3, etc.). Please ref the attached example of to see what I'm trying to do. I am open to a better format, if you can suggest any.
Thanks!