View Single Post
  #1   Report Post  
kmorgan kmorgan is offline
Junior Member
 
Posts: 1
Default count calls per hour

I run a call center and I'm trying to determine our call volume per hour. I have 3 months worth of data which looks like the sample below. I have been unable to sort the data into a chart to display the traffic pattern. I've seen your response to this query before however, I'm on Excel 2013. Can you help?

11/1/2014 0:27
11/1/2014 0:28
11/1/2014 0:28
11/1/2014 0:40
11/1/2014 0:45
11/1/2014 1:28
11/1/2014 2:12
11/1/2014 2:21
11/1/2014 2:25
11/1/2014 2:37
11/1/2014 2:44
11/1/2014 2:47
11/1/2014 2:49
11/1/2014 4:05
11/1/2014 7:26
11/1/2014 7:34
11/1/2014 7:37