Charting call times

[mgerald]

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
	A	B	C
1	Date and Time	Call Center Name	Calls Queued
2	04/01/2021, 07:00 AM	Help Desk	1
3		Summary	1
4	04/01/2021, 08:00 AM	Help Desk	2
5		Help Desk Overflow	3
6		Summary	5
7	04/01/2021, 09:00 AM	Help Desk	2
8		Help Desk Overflow	2
9		Summary	4
10	04/01/2021, 10:00 AM	Help Desk	1
11		Summary	1
12	04/01/2021, 11:00 AM	Help Desk	3
13		Help Desk Overflow	1
14		Summary	4
15	04/01/2021, 12:00 PM	Help Desk	1
16		Summary	1
17	04/01/2021, 01:00 PM	Help Desk	3
18		Help Desk Overflow	1
19		Summary	4
20	04/01/2021, 02:00 PM	Help Desk	3
21		Help Desk Overflow	1
22		Summary	4
23	04/01/2021, 03:00 PM	Help Desk	2
24		Help Desk Overflow	2
25		Summary	4
26	04/01/2021, 04:00 PM	Help Desk	2
27		Help Desk Overflow	1
28		Summary	3
29	04/01/2021, 05:00 PM	Help Desk	3
30		Help Desk Overflow	10
31		Summary	13
32	04/01/2021, 06:00 PM	Help Desk	3
33		Help Desk Overflow	8
34		Summary	11
35	04/02/2021, 07:00 AM	Help Desk	2
36		Help Desk Overflow	5
37		Summary	7
38	04/02/2021, 08:00 AM	Help Desk	14
39		Help Desk Overflow	15
40		Summary	29
41	04/02/2021, 09:00 AM	Help Desk	5
42		Help Desk Overflow	8
43		Summary	13
44	04/02/2021, 10:00 AM	Help Desk	5
45		Help Desk Overflow	6
46		Summary	11
47	04/02/2021, 11:00 AM	Help Desk	1
48		Help Desk Overflow	3
49		Summary	4
50	04/02/2021, 12:00 PM	Help Desk	6
51		Help Desk Overflow	3
52		Summary	9
53	04/02/2021, 01:00 PM	Help Desk	1
54		Help Desk Overflow	1
55		Summary	2
56	04/02/2021, 02:00 PM	Help Desk	1
57		Help Desk Overflow	2
58		Summary	3
59	04/02/2021, 03:00 PM	Help Desk	1
60		Help Desk Overflow	2
61		Summary	3
62	04/02/2021, 04:00 PM	Help Desk	1
63		Help Desk Overflow	1
64		Summary	2
65	04/02/2021, 05:00 PM	Help Desk Overflow	1
66		Summary	1
67	04/03/2021, 08:00 AM	Help Desk	6
68		Help Desk Overflow	13
69		Summary	19
70	04/03/2021, 09:00 AM	Help Desk	3
71		Help Desk Overflow	8
72		Summary	11
73	04/03/2021, 10:00 AM	Help Desk	2
74		Help Desk Overflow	4
75		Summary	6
76	04/03/2021, 11:00 AM	Help Desk	1
77		Help Desk Overflow	3
78		Summary	4
79	04/03/2021, 12:00 PM	Help Desk	2
80		Help Desk Overflow	3
81		Summary	5
82	04/03/2021, 02:00 PM	Help Desk Overflow	1
83		Summary	1
84	04/03/2021, 04:00 PM	Help Desk	2
85		Help Desk Overflow	1
86		Summary	3
87	04/03/2021, 07:00 PM	Help Desk Overflow	1
88		Summary	1
89	04/04/2021, 09:00 AM	Help Desk	1
90		Summary	1
91	04/04/2021, 10:00 AM	Help Desk	2
92		Summary	2
93	04/04/2021, 02:00 PM	Help Desk	2
94		Help Desk Overflow	1
95		Summary	3
96	04/04/2021, 03:00 PM	Help Desk Overflow	5
97		Summary	5
98	04/04/2021, 09:00 PM	Help Desk Overflow	2
99		Summary	2
100	04/05/2021, 07:00 AM	Help Desk	1
101		Help Desk Overflow	2
102		Summary	3
103	04/05/2021, 08:00 AM	Help Desk	11
104		Help Desk Overflow	13
105		Summary	24
106	04/05/2021, 09:00 AM	Help Desk	5
107		Help Desk Overflow	5
108		Summary	10
109	04/05/2021, 10:00 AM	Help Desk	7
110		Help Desk Overflow	4
111		Summary	11
112	04/05/2021, 11:00 AM	Help Desk	5
113		Help Desk Overflow	5
114		Summary	10
115	04/05/2021, 12:00 PM	Help Desk	4
116		Help Desk Overflow	2
117		Summary	6
118	04/05/2021, 01:00 PM	Help Desk	4
119		Help Desk Overflow	1
120		Summary	5
121	04/05/2021, 02:00 PM	Help Desk	4
122		Help Desk Overflow	3
123		Summary	7
124	04/05/2021, 03:00 PM	Help Desk	5
125		Help Desk Overflow	2
126		Summary	7
127	04/05/2021, 04:00 PM	Help Desk	5
128		Help Desk Overflow	2
129		Summary	7
130	04/05/2021, 05:00 PM	Help Desk	3
131		Help Desk Overflow	3
132		Summary	6
133	04/05/2021, 06:00 PM	Help Desk	1
134		Summary	1
135	04/05/2021, 07:00 PM	Help Desk Overflow	1
136		Summary	1
137	04/05/2021, 08:00 PM	Help Desk Overflow	1
138		Summary	1
139	04/05/2021, 09:00 PM	Help Desk Overflow	1
140		Summary	1
141	04/06/2021, 07:00 AM	Help Desk	2
142		Help Desk Overflow	2
143		Summary	4
144	04/06/2021, 08:00 AM	Help Desk	9
145		Help Desk Overflow	6
146		Summary	15
147	04/06/2021, 09:00 AM	Help Desk	10
148		Help Desk Overflow	1
149		Summary	11
150	04/06/2021, 10:00 AM	Help Desk	2
151		Help Desk Overflow	4
152		Summary	6
153	04/06/2021, 11:00 AM	Help Desk	1
154		Help Desk Overflow	2
155		Summary	3
156	04/06/2021, 12:00 PM	Help Desk	6
157		Help Desk Overflow	2
158		Summary	8
159	04/06/2021, 01:00 PM	Help Desk	1
160		Help Desk Overflow	4
161		Summary	5
162	04/06/2021, 02:00 PM	Help Desk	4
163		Help Desk Overflow	3
164		Summary	7
165	04/06/2021, 03:00 PM	Help Desk	2
166		Help Desk Overflow	1
167		Summary	3
168	04/06/2021, 04:00 PM	Help Desk	6
169		Help Desk Overflow	1
170		Summary	7
171	04/06/2021, 05:00 PM	Help Desk	3
172		Help Desk Overflow	5
173		Summary	8
174	04/06/2021, 06:00 PM	Help Desk	5
175		Help Desk Overflow	3
176		Summary	8
177	04/06/2021, 07:00 PM	Help Desk Overflow	1
178		Summary	1
179	04/06/2021, 10:00 PM	Help Desk Overflow	2
180		Summary	2
181	04/07/2021, 08:00 AM	Help Desk	7
182		Help Desk Overflow	3
183		Summary	10
184	04/07/2021, 09:00 AM	Help Desk	5
185		Help Desk Overflow	1
186		Summary	6
187	04/07/2021, 10:00 AM	Help Desk	6
188		Help Desk Overflow	2
189		Summary	8
190	04/07/2021, 11:00 AM	Help Desk	2
191		Summary	2
192	04/07/2021, 12:00 PM	Help Desk	2
193		Help Desk Overflow	2
194		Summary	4
195	04/07/2021, 01:00 PM	Help Desk	2
196		Summary	2
197	04/07/2021, 02:00 PM	Help Desk	4
198		Summary	4
199	04/07/2021, 03:00 PM	Help Desk	6
200		Help Desk Overflow	4
201		Summary	10
202	04/07/2021, 04:00 PM	Help Desk	2
203		Help Desk Overflow	1
204		Summary	3
205	04/07/2021, 07:00 PM	Help Desk Overflow	2
206		Summary	2
207	04/08/2021, 07:00 AM	Help Desk	4
208		Summary	4
209	04/08/2021, 08:00 AM	Help Desk	10
210		Help Desk Overflow	5
211		Summary	15
212	04/08/2021, 09:00 AM	Help Desk	9
213		Help Desk Overflow	2
214		Summary	11
215	04/08/2021, 10:00 AM	Help Desk	3
216		Summary	3
217	04/08/2021, 11:00 AM	Help Desk	3
218		Help Desk Overflow	1
219		Summary	4
220	04/08/2021, 12:00 PM	Help Desk	2
221		Help Desk Overflow	2
222		Summary	4
223	04/08/2021, 01:00 PM	Help Desk	1
224		Help Desk Overflow	1
225		Summary	2
226	04/08/2021, 02:00 PM	Help Desk	1
227		Help Desk Overflow	1
228		Summary	2
229	04/08/2021, 03:00 PM	Help Desk	4
230		Help Desk Overflow	6
231		Summary	10
232	04/08/2021, 04:00 PM	Help Desk	1
233		Summary	1
234	04/08/2021, 05:00 PM	Help Desk	2
235		Help Desk Overflow	1
236		Summary	3
237	04/08/2021, 06:00 PM	Help Desk Overflow	2
238		Summary	2
239	04/09/2021, 07:00 AM	Help Desk	1
240		Summary	1
241	04/09/2021, 08:00 AM	Help Desk	2
242		Help Desk Overflow	2
243		Summary	4
244	04/09/2021, 09:00 AM	Help Desk	7
245		Help Desk Overflow	4
246		Summary	11
247	04/09/2021, 10:00 AM	Help Desk	5
248		Help Desk Overflow	3
249		Summary	8
250	04/09/2021, 11:00 AM	Help Desk	2
251		Help Desk Overflow	5
252		Summary	7
253	04/09/2021, 12:00 PM	Help Desk	5
254		Help Desk Overflow	5
255		Summary	10
256	04/09/2021, 01:00 PM	Help Desk	4
257		Help Desk Overflow	7
258		Summary	11
259	04/09/2021, 02:00 PM	Help Desk	3
260		Help Desk Overflow	1
261		Summary	4
262	04/09/2021, 03:00 PM	Help Desk	1
263		Help Desk Overflow	1
264		Summary	2
265	04/09/2021, 04:00 PM	Help Desk	5
266		Help Desk Overflow	2
267		Summary	7
268	04/09/2021, 05:00 PM	Help Desk	2
269		Help Desk Overflow	2
270		Summary	4
271	04/09/2021, 06:00 PM	Help Desk	1
272		Help Desk Overflow	4
273		Summary	5
274	04/09/2021, 08:00 PM	Help Desk Overflow	1
275		Summary	1
276	04/09/2021, 09:00 PM	Help Desk Overflow	1
277		Summary	1
Sheet1

 

[Michael M]

Sooo....you're suggesting all posters on this thread are over the age of 40. ?......