Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count calls by dates | Excel Worksheet Functions | |||
How to use count for calls per hour | New Users to Excel | |||
Hour Count | Excel Worksheet Functions | |||
How to count hours- and multiply with my wage per hour... | Excel Discussion (Misc queries) | |||
Count by date and hour | Excel Worksheet Functions |