Charting call times

mgerald

New Member
Joined
May 7, 2021
Messages
4
Office Version
  1. 365
Platform
  1. Windows
My boss has asked me to give him a chart or table of the times when we get the highest call volumes.
The DL from the call center for the last month is 928 rows so I have to find a way to show him the information.
I feel pretty certain that he will want to see a grouping of the days of the week with the times the calls come in.
I only need the number from the summary line for each day in the attached sheet but I need to keep it associated with the day and time it occurred.
I am at a loss of how to proceed. I hope someone can point me in the right direction.
Book2
ABC
1Date and TimeCall Center NameCalls Queued
204/01/2021, 07:00 AMHelp Desk1
3Summary1
404/01/2021, 08:00 AMHelp Desk2
5Help Desk Overflow3
6Summary5
704/01/2021, 09:00 AMHelp Desk2
8Help Desk Overflow2
9Summary4
1004/01/2021, 10:00 AMHelp Desk1
11Summary1
1204/01/2021, 11:00 AMHelp Desk3
13Help Desk Overflow1
14Summary4
1504/01/2021, 12:00 PMHelp Desk1
16Summary1
1704/01/2021, 01:00 PMHelp Desk3
18Help Desk Overflow1
19Summary4
2004/01/2021, 02:00 PMHelp Desk3
21Help Desk Overflow1
22Summary4
2304/01/2021, 03:00 PMHelp Desk2
24Help Desk Overflow2
25Summary4
2604/01/2021, 04:00 PMHelp Desk2
27Help Desk Overflow1
28Summary3
2904/01/2021, 05:00 PMHelp Desk3
30Help Desk Overflow10
31Summary13
3204/01/2021, 06:00 PMHelp Desk3
33Help Desk Overflow8
34Summary11
3504/02/2021, 07:00 AMHelp Desk2
36Help Desk Overflow5
37Summary7
3804/02/2021, 08:00 AMHelp Desk14
39Help Desk Overflow15
40Summary29
4104/02/2021, 09:00 AMHelp Desk5
42Help Desk Overflow8
43Summary13
4404/02/2021, 10:00 AMHelp Desk5
45Help Desk Overflow6
46Summary11
4704/02/2021, 11:00 AMHelp Desk1
48Help Desk Overflow3
49Summary4
5004/02/2021, 12:00 PMHelp Desk6
51Help Desk Overflow3
52Summary9
5304/02/2021, 01:00 PMHelp Desk1
54Help Desk Overflow1
55Summary2
5604/02/2021, 02:00 PMHelp Desk1
57Help Desk Overflow2
58Summary3
5904/02/2021, 03:00 PMHelp Desk1
60Help Desk Overflow2
61Summary3
6204/02/2021, 04:00 PMHelp Desk1
63Help Desk Overflow1
64Summary2
6504/02/2021, 05:00 PMHelp Desk Overflow1
66Summary1
6704/03/2021, 08:00 AMHelp Desk6
68Help Desk Overflow13
69Summary19
7004/03/2021, 09:00 AMHelp Desk3
71Help Desk Overflow8
72Summary11
7304/03/2021, 10:00 AMHelp Desk2
74Help Desk Overflow4
75Summary6
7604/03/2021, 11:00 AMHelp Desk1
77Help Desk Overflow3
78Summary4
7904/03/2021, 12:00 PMHelp Desk2
80Help Desk Overflow3
81Summary5
8204/03/2021, 02:00 PMHelp Desk Overflow1
83Summary1
8404/03/2021, 04:00 PMHelp Desk2
85Help Desk Overflow1
86Summary3
8704/03/2021, 07:00 PMHelp Desk Overflow1
88Summary1
8904/04/2021, 09:00 AMHelp Desk1
90Summary1
9104/04/2021, 10:00 AMHelp Desk2
92Summary2
9304/04/2021, 02:00 PMHelp Desk2
94Help Desk Overflow1
95Summary3
9604/04/2021, 03:00 PMHelp Desk Overflow5
97Summary5
9804/04/2021, 09:00 PMHelp Desk Overflow2
99Summary2
10004/05/2021, 07:00 AMHelp Desk1
101Help Desk Overflow2
102Summary3
10304/05/2021, 08:00 AMHelp Desk11
104Help Desk Overflow13
105Summary24
10604/05/2021, 09:00 AMHelp Desk5
107Help Desk Overflow5
108Summary10
10904/05/2021, 10:00 AMHelp Desk7
110Help Desk Overflow4
111Summary11
11204/05/2021, 11:00 AMHelp Desk5
113Help Desk Overflow5
114Summary10
11504/05/2021, 12:00 PMHelp Desk4
116Help Desk Overflow2
117Summary6
11804/05/2021, 01:00 PMHelp Desk4
119Help Desk Overflow1
120Summary5
12104/05/2021, 02:00 PMHelp Desk4
122Help Desk Overflow3
123Summary7
12404/05/2021, 03:00 PMHelp Desk5
125Help Desk Overflow2
126Summary7
12704/05/2021, 04:00 PMHelp Desk5
128Help Desk Overflow2
129Summary7
13004/05/2021, 05:00 PMHelp Desk3
131Help Desk Overflow3
132Summary6
13304/05/2021, 06:00 PMHelp Desk1
134Summary1
13504/05/2021, 07:00 PMHelp Desk Overflow1
136Summary1
13704/05/2021, 08:00 PMHelp Desk Overflow1
138Summary1
13904/05/2021, 09:00 PMHelp Desk Overflow1
140Summary1
14104/06/2021, 07:00 AMHelp Desk2
142Help Desk Overflow2
143Summary4
14404/06/2021, 08:00 AMHelp Desk9
145Help Desk Overflow6
146Summary15
14704/06/2021, 09:00 AMHelp Desk10
148Help Desk Overflow1
149Summary11
15004/06/2021, 10:00 AMHelp Desk2
151Help Desk Overflow4
152Summary6
15304/06/2021, 11:00 AMHelp Desk1
154Help Desk Overflow2
155Summary3
15604/06/2021, 12:00 PMHelp Desk6
157Help Desk Overflow2
158Summary8
15904/06/2021, 01:00 PMHelp Desk1
160Help Desk Overflow4
161Summary5
16204/06/2021, 02:00 PMHelp Desk4
163Help Desk Overflow3
164Summary7
16504/06/2021, 03:00 PMHelp Desk2
166Help Desk Overflow1
167Summary3
16804/06/2021, 04:00 PMHelp Desk6
169Help Desk Overflow1
170Summary7
17104/06/2021, 05:00 PMHelp Desk3
172Help Desk Overflow5
173Summary8
17404/06/2021, 06:00 PMHelp Desk5
175Help Desk Overflow3
176Summary8
17704/06/2021, 07:00 PMHelp Desk Overflow1
178Summary1
17904/06/2021, 10:00 PMHelp Desk Overflow2
180Summary2
18104/07/2021, 08:00 AMHelp Desk7
182Help Desk Overflow3
183Summary10
18404/07/2021, 09:00 AMHelp Desk5
185Help Desk Overflow1
186Summary6
18704/07/2021, 10:00 AMHelp Desk6
188Help Desk Overflow2
189Summary8
19004/07/2021, 11:00 AMHelp Desk2
191Summary2
19204/07/2021, 12:00 PMHelp Desk2
193Help Desk Overflow2
194Summary4
19504/07/2021, 01:00 PMHelp Desk2
196Summary2
19704/07/2021, 02:00 PMHelp Desk4
198Summary4
19904/07/2021, 03:00 PMHelp Desk6
200Help Desk Overflow4
201Summary10
20204/07/2021, 04:00 PMHelp Desk2
203Help Desk Overflow1
204Summary3
20504/07/2021, 07:00 PMHelp Desk Overflow2
206Summary2
20704/08/2021, 07:00 AMHelp Desk4
208Summary4
20904/08/2021, 08:00 AMHelp Desk10
210Help Desk Overflow5
211Summary15
21204/08/2021, 09:00 AMHelp Desk9
213Help Desk Overflow2
214Summary11
21504/08/2021, 10:00 AMHelp Desk3
216Summary3
21704/08/2021, 11:00 AMHelp Desk3
218Help Desk Overflow1
219Summary4
22004/08/2021, 12:00 PMHelp Desk2
221Help Desk Overflow2
222Summary4
22304/08/2021, 01:00 PMHelp Desk1
224Help Desk Overflow1
225Summary2
22604/08/2021, 02:00 PMHelp Desk1
227Help Desk Overflow1
228Summary2
22904/08/2021, 03:00 PMHelp Desk4
230Help Desk Overflow6
231Summary10
23204/08/2021, 04:00 PMHelp Desk1
233Summary1
23404/08/2021, 05:00 PMHelp Desk2
235Help Desk Overflow1
236Summary3
23704/08/2021, 06:00 PMHelp Desk Overflow2
238Summary2
23904/09/2021, 07:00 AMHelp Desk1
240Summary1
24104/09/2021, 08:00 AMHelp Desk2
242Help Desk Overflow2
243Summary4
24404/09/2021, 09:00 AMHelp Desk7
245Help Desk Overflow4
246Summary11
24704/09/2021, 10:00 AMHelp Desk5
248Help Desk Overflow3
249Summary8
25004/09/2021, 11:00 AMHelp Desk2
251Help Desk Overflow5
252Summary7
25304/09/2021, 12:00 PMHelp Desk5
254Help Desk Overflow5
255Summary10
25604/09/2021, 01:00 PMHelp Desk4
257Help Desk Overflow7
258Summary11
25904/09/2021, 02:00 PMHelp Desk3
260Help Desk Overflow1
261Summary4
26204/09/2021, 03:00 PMHelp Desk1
263Help Desk Overflow1
264Summary2
26504/09/2021, 04:00 PMHelp Desk5
266Help Desk Overflow2
267Summary7
26804/09/2021, 05:00 PMHelp Desk2
269Help Desk Overflow2
270Summary4
27104/09/2021, 06:00 PMHelp Desk1
272Help Desk Overflow4
273Summary5
27404/09/2021, 08:00 PMHelp Desk Overflow1
275Summary1
27604/09/2021, 09:00 PMHelp Desk Overflow1
277Summary1
Sheet1
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
21,104
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Sooo....you're suggesting all posters on this thread are over the age of 40. ?......:ROFLMAO::ROFLMAO:
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,148,173
Messages
5,745,183
Members
423,931
Latest member
thangvan114

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top