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