Trying to chart calls per minute, per day

[abp33]

Hi All,

First post here and would appreciate any help! I'm trying to use some call data for some predictive staffing. I need to see the highest number of calls happening around the same time each day. I'll have to do this for a number of different lines, so I'd love help working out a formula that could apply.

I have two columns, date and time stamps of the calls. A small sample is below.

I'm hoping this is a relatively easy one to solve.

Thanks!


7/1/13 5:50 AM
7/1/13 9:49 AM
7/1/13 10:33 AM
7/1/13 10:53 AM
7/1/13 11:19 AM
7/1/13 11:41 AM
7/1/13 12:07 PM
7/1/13 3:58 PM
7/1/13 4:03 PM
7/1/13 5:35 PM
7/1/13 6:27 PM
7/1/13 6:39 PM
7/1/13 7:37 PM

[protonLeah]

Scatter plot?

[Andy Pope]

Scatter but you don't want to string out the x axis but rather stack the days entries.