ExcelBanter - count calls per hour

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - count calls per hour (https://www.excelbanter.com/excel-discussion-misc-queries/450596-count-calls-per-hour.html)

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

count calls per hour

Hi,

Am Fri, 16 Jan 2015 13:55:10 +0000 schrieb kmorgan:

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.

the easiest way to do this is a Pivot table. Or use SUMPRODUCT
Have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "CountCalls"

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional