I would like to see the distribution by hour and day of these entries but don't have a clue where to start...

[leanheart]

Hello and thanks in advance for the help! I am trying to build a staffing schedule around the data below but am having difficulties with where to start and how to display the data in a way my VP can understand at a glance. Anyone able to help?

Ticket distribution by time.csv
	A
1	Created Time (Ticket)
2	21/12/2021 12:03 AM
3	21/12/2021 07:11 AM
4	21/12/2021 07:39 AM
5	21/12/2021 08:24 AM
6	21/12/2021 08:46 AM
7	21/12/2021 09:17 AM
8	21/12/2021 09:34 AM
9	21/12/2021 09:47 AM
10	21/12/2021 09:54 AM
11	21/12/2021 10:01 AM
12	21/12/2021 10:11 AM
13	21/12/2021 10:16 AM
14	21/12/2021 10:21 AM
15	21/12/2021 10:41 AM
16	21/12/2021 10:48 AM
17	21/12/2021 11:25 AM
18	21/12/2021 11:43 AM
19	21/12/2021 12:23 PM
20	21/12/2021 01:40 PM
21	21/12/2021 02:02 PM
22	21/12/2021 03:22 PM
23	21/12/2021 03:38 PM
24	21/12/2021 03:59 PM
25	21/12/2021 04:07 PM
26	21/12/2021 04:19 PM
27	21/12/2021 04:58 PM
28	21/12/2021 04:59 PM
29	21/12/2021 05:00 PM
30	21/12/2021 06:14 PM
31	21/12/2021 06:41 PM
32	21/12/2021 06:57 PM
33	21/12/2021 07:00 PM
34	21/12/2021 07:07 PM
35	21/12/2021 07:18 PM
36	21/12/2021 07:45 PM
37	21/12/2021 07:55 PM
38	21/12/2021 08:43 PM
39	21/12/2021 08:44 PM
40	21/12/2021 08:59 PM
41	21/12/2021 09:16 PM
42	21/12/2021 11:50 PM
43	22/12/2021 12:07 AM
44	22/12/2021 12:14 AM
45	22/12/2021 12:28 AM
46	22/12/2021 12:34 AM
47	22/12/2021 01:14 AM
48	22/12/2021 01:56 AM
49	22/12/2021 05:49 AM
50	22/12/2021 06:32 AM
51	22/12/2021 06:38 AM
52	22/12/2021 06:47 AM
53	22/12/2021 07:10 AM
54	22/12/2021 07:39 AM
55	22/12/2021 07:51 AM
56	22/12/2021 08:10 AM
57	22/12/2021 08:26 AM
58	22/12/2021 08:28 AM
59	22/12/2021 08:37 AM
60	22/12/2021 08:44 AM
61	22/12/2021 08:47 AM
62	22/12/2021 09:06 AM
63	22/12/2021 09:09 AM
64	22/12/2021 09:20 AM
65	22/12/2021 09:21 AM
66	22/12/2021 09:26 AM
67	22/12/2021 09:34 AM
68	22/12/2021 09:35 AM
69	22/12/2021 09:38 AM
70	22/12/2021 09:44 AM
71	22/12/2021 09:47 AM
72	22/12/2021 09:48 AM
73	22/12/2021 09:52 AM
74	22/12/2021 09:55 AM
75	22/12/2021 10:09 AM
76	22/12/2021 10:16 AM
77	22/12/2021 10:19 AM
78	22/12/2021 10:29 AM
79	22/12/2021 10:53 AM
80	22/12/2021 10:54 AM
81	22/12/2021 11:50 AM
82	22/12/2021 11:54 AM
83	22/12/2021 12:20 PM
84	22/12/2021 12:24 PM
85	22/12/2021 12:33 PM
86	22/12/2021 12:58 PM
87	22/12/2021 01:10 PM
88	22/12/2021 01:36 PM
89	22/12/2021 01:37 PM
90	22/12/2021 01:44 PM
91	22/12/2021 01:48 PM
92	22/12/2021 02:53 PM
93	22/12/2021 02:54 PM
94	22/12/2021 03:30 PM
95	22/12/2021 03:56 PM
96	22/12/2021 04:04 PM
97	22/12/2021 04:36 PM
98	22/12/2021 04:47 PM
99	22/12/2021 05:14 PM
100	22/12/2021 05:23 PM
101	22/12/2021 05:37 PM
102	22/12/2021 05:56 PM
103	22/12/2021 06:35 PM
104	22/12/2021 06:38 PM
105	22/12/2021 06:42 PM
106	22/12/2021 08:04 PM
107	22/12/2021 08:26 PM
108	22/12/2021 08:30 PM
109	22/12/2021 08:52 PM
110	22/12/2021 11:04 PM
111	23/12/2021 01:54 AM
112	23/12/2021 06:38 AM
113	23/12/2021 07:22 AM
114	23/12/2021 07:30 AM
115	23/12/2021 08:22 AM
116	23/12/2021 09:00 AM
117	23/12/2021 09:11 AM
118	23/12/2021 09:19 AM
119	23/12/2021 10:02 AM
120	23/12/2021 10:07 AM
121	23/12/2021 10:15 AM
122	23/12/2021 11:27 AM
123	23/12/2021 11:41 AM
124	23/12/2021 11:54 AM
125	23/12/2021 12:45 PM
126	23/12/2021 01:00 PM
127	23/12/2021 01:01 PM
128	23/12/2021 02:49 PM
129	23/12/2021 02:59 PM
130	23/12/2021 03:12 PM
131	23/12/2021 03:27 PM
132	23/12/2021 03:30 PM
133	23/12/2021 03:39 PM
134	23/12/2021 03:53 PM
135	23/12/2021 03:57 PM
136	23/12/2021 04:39 PM
137	23/12/2021 04:45 PM
138	23/12/2021 06:44 PM
139	23/12/2021 07:09 PM
140	23/12/2021 08:06 PM
141	24/12/2021 06:19 AM
142	24/12/2021 07:49 AM
143	24/12/2021 08:04 AM
144	24/12/2021 10:20 AM
145	24/12/2021 10:37 AM
146	24/12/2021 10:42 AM
147	24/12/2021 11:32 AM
148	24/12/2021 11:48 AM
149	24/12/2021 11:53 AM
150	24/12/2021 01:14 PM
151	24/12/2021 01:16 PM
152	24/12/2021 01:30 PM
153	24/12/2021 02:10 PM
154	24/12/2021 02:57 PM
155	24/12/2021 03:10 PM
156	24/12/2021 03:59 PM
157	24/12/2021 06:46 PM
158	24/12/2021 08:59 PM
159	24/12/2021 11:38 PM
160	25/12/2021 10:59 AM
161	25/12/2021 11:08 AM
162	25/12/2021 02:06 PM
163	25/12/2021 02:41 PM
164	25/12/2021 06:42 PM
165	25/12/2021 10:13 PM
166	26/12/2021 08:19 AM
167	26/12/2021 09:02 AM
168	26/12/2021 09:06 AM
169	26/12/2021 09:07 AM
170	26/12/2021 09:09 AM
171	26/12/2021 09:09 AM
172	26/12/2021 09:12 AM
173	26/12/2021 09:14 AM
174	26/12/2021 09:14 AM
175	26/12/2021 09:15 AM
176	26/12/2021 09:18 AM
177	26/12/2021 09:18 AM
178	26/12/2021 09:20 AM
179	26/12/2021 09:21 AM
180	26/12/2021 09:21 AM
181	26/12/2021 09:27 AM
182	26/12/2021 09:48 AM
183	26/12/2021 09:48 AM
184	26/12/2021 09:49 AM
185	26/12/2021 09:51 AM
186	26/12/2021 09:52 AM
187	26/12/2021 09:55 AM
188	26/12/2021 09:58 AM
189	26/12/2021 10:21 AM
190	26/12/2021 10:30 AM
191	26/12/2021 10:35 AM
192	26/12/2021 10:36 AM
193	26/12/2021 10:48 AM
194	26/12/2021 11:16 AM
195	26/12/2021 11:28 AM
196	26/12/2021 11:42 AM
197	26/12/2021 11:53 AM
198	26/12/2021 11:57 AM
199	26/12/2021 12:29 PM
200	26/12/2021 12:38 PM
201	26/12/2021 12:50 PM
202	26/12/2021 01:19 PM
203	26/12/2021 02:24 PM
204	26/12/2021 02:59 PM
205	26/12/2021 03:08 PM
206	26/12/2021 03:43 PM
207	26/12/2021 03:47 PM
208	26/12/2021 03:51 PM
209	26/12/2021 04:49 PM
210	26/12/2021 05:24 PM
211	26/12/2021 05:51 PM
212	26/12/2021 07:12 PM
213	26/12/2021 07:27 PM
214	26/12/2021 07:53 PM
215	26/12/2021 08:51 PM
216	26/12/2021 08:58 PM
217	26/12/2021 09:29 PM
218	26/12/2021 09:32 PM
219	26/12/2021 10:20 PM
220	26/12/2021 10:39 PM
221	26/12/2021 10:49 PM
222	27/12/2021 07:24 AM
223	27/12/2021 08:36 AM
224	27/12/2021 09:23 AM
225	27/12/2021 09:59 AM
226	27/12/2021 10:26 AM
227	27/12/2021 10:55 AM
228	27/12/2021 11:01 AM
229	27/12/2021 12:33 PM
230	27/12/2021 01:33 PM
231	27/12/2021 01:38 PM
232	27/12/2021 03:03 PM
233	27/12/2021 03:59 PM
234	27/12/2021 04:01 PM
235	27/12/2021 04:29 PM
236	27/12/2021 04:37 PM
237	27/12/2021 04:48 PM
238	27/12/2021 05:27 PM
239	27/12/2021 07:20 PM
240	27/12/2021 08:39 PM
241	27/12/2021 10:01 PM
242	27/12/2021 10:34 PM
243	27/12/2021 11:08 PM
244	28/12/2021 07:40 AM
245	28/12/2021 08:58 AM
246	28/12/2021 08:59 AM
247	28/12/2021 10:50 AM
248	28/12/2021 11:05 AM
249	28/12/2021 11:56 AM
250	28/12/2021 02:10 PM
251	28/12/2021 02:31 PM
252	28/12/2021 02:46 PM
253	28/12/2021 03:04 PM
254	28/12/2021 03:13 PM
255	28/12/2021 03:21 PM
256	28/12/2021 03:23 PM
257	28/12/2021 04:08 PM
258	28/12/2021 05:01 PM
259	28/12/2021 06:06 PM
260	28/12/2021 06:34 PM
261	28/12/2021 07:43 PM
262	28/12/2021 08:26 PM
263	28/12/2021 08:57 PM
264	28/12/2021 09:28 PM
265	28/12/2021 10:20 PM
266	28/12/2021 10:28 PM
267	28/12/2021 11:10 PM
268	29/12/2021 08:23 AM
269	29/12/2021 08:45 AM
270	29/12/2021 08:51 AM
271	29/12/2021 09:23 AM
272	29/12/2021 09:49 AM
273	29/12/2021 09:51 AM
274	29/12/2021 12:45 PM
275	29/12/2021 01:05 PM
276	29/12/2021 02:52 PM
277	29/12/2021 03:09 PM
278	29/12/2021 03:39 PM
279	29/12/2021 04:13 PM
280	29/12/2021 05:30 PM
281	29/12/2021 05:49 PM
282	29/12/2021 06:19 PM
283	29/12/2021 06:53 PM
284	29/12/2021 07:34 PM
285	29/12/2021 07:53 PM
286	29/12/2021 08:27 PM
287	29/12/2021 09:26 PM
288	29/12/2021 11:59 PM
289	30/12/2021 08:37 AM
290	30/12/2021 09:16 AM
291	30/12/2021 09:33 AM
292	30/12/2021 09:49 AM
293	30/12/2021 10:33 AM
294	30/12/2021 10:50 AM
295	30/12/2021 10:51 AM
296	30/12/2021 11:47 AM
297	30/12/2021 11:50 AM
298	30/12/2021 11:50 AM
299	30/12/2021 11:52 AM
300	30/12/2021 11:59 AM
301	30/12/2021 12:12 PM
302	30/12/2021 12:18 PM
303	30/12/2021 12:19 PM
304	30/12/2021 12:20 PM
305	30/12/2021 12:25 PM
306	30/12/2021 12:57 PM
307	30/12/2021 01:15 PM
308	30/12/2021 01:21 PM
309	30/12/2021 01:27 PM
310	30/12/2021 01:38 PM
311	30/12/2021 01:58 PM
312	30/12/2021 02:23 PM
313	30/12/2021 02:30 PM
314	30/12/2021 02:44 PM
315	30/12/2021 03:23 PM
316	30/12/2021 03:25 PM
317	30/12/2021 03:53 PM
318	30/12/2021 04:03 PM
319	30/12/2021 04:16 PM
320	30/12/2021 04:29 PM
321	30/12/2021 05:17 PM
322	30/12/2021 05:39 PM
323	30/12/2021 05:45 PM
324	30/12/2021 05:56 PM
325	30/12/2021 06:04 PM
326	30/12/2021 06:06 PM
327	30/12/2021 06:37 PM
328	30/12/2021 06:41 PM
329	30/12/2021 06:44 PM
330	30/12/2021 07:21 PM
331	30/12/2021 07:39 PM
332	30/12/2021 07:47 PM
333	30/12/2021 08:06 PM
334	30/12/2021 08:49 PM
335	30/12/2021 10:01 PM
336	30/12/2021 10:04 PM
337	30/12/2021 10:07 PM
338	30/12/2021 11:01 PM
339	30/12/2021 11:17 PM
340	31/12/2021 12:16 AM
341	31/12/2021 01:37 AM
342	31/12/2021 04:49 AM
343	31/12/2021 06:51 AM
344	31/12/2021 09:56 AM
345	31/12/2021 10:49 AM
346	31/12/2021 11:04 AM
347	31/12/2021 11:24 AM
348	31/12/2021 11:24 AM
349	31/12/2021 11:27 AM
350	31/12/2021 11:57 AM
351	31/12/2021 12:14 PM
352	31/12/2021 12:31 PM
353	31/12/2021 12:32 PM
354	31/12/2021 12:45 PM
355	31/12/2021 01:24 PM
356	31/12/2021 02:06 PM
357	31/12/2021 02:34 PM
358	31/12/2021 03:06 PM
359	31/12/2021 04:29 PM
360	31/12/2021 04:35 PM
361	31/12/2021 04:48 PM
362	31/12/2021 05:07 PM
363	31/12/2021 05:10 PM
364	31/12/2021 05:12 PM
365	31/12/2021 05:15 PM
366	31/12/2021 05:17 PM
367	31/12/2021 05:20 PM
368	31/12/2021 05:26 PM
369	31/12/2021 06:16 PM
370	31/12/2021 06:30 PM
371	31/12/2021 06:36 PM
372	31/12/2021 06:38 PM
373	31/12/2021 07:28 PM
374	31/12/2021 09:25 PM
375	31/12/2021 11:08 PM
376	31/12/2021 11:10 PM
377	01/01/2022 08:37 AM
378	01/01/2022 09:37 AM
379	01/01/2022 09:43 AM
380	01/01/2022 09:57 AM
381	01/01/2022 10:05 AM
382	01/01/2022 10:41 AM
383	01/01/2022 11:38 AM
384	01/01/2022 11:56 AM
385	01/01/2022 12:23 PM
386	01/01/2022 12:34 PM
387	01/01/2022 12:54 PM
388	01/01/2022 02:14 PM
389	01/01/2022 02:37 PM
390	01/01/2022 03:07 PM
391	01/01/2022 03:09 PM
392	01/01/2022 04:11 PM
393	01/01/2022 04:30 PM
394	01/01/2022 06:38 PM
395	01/01/2022 07:02 PM
396	01/01/2022 07:05 PM
397	01/01/2022 07:39 PM
398	01/01/2022 08:42 PM
399	01/01/2022 09:16 PM
400	01/01/2022 09:48 PM
401	01/01/2022 10:32 PM
402	01/01/2022 10:51 PM
403	02/01/2022 01:54 AM
404	02/01/2022 10:01 AM
405	02/01/2022 10:47 AM
406	02/01/2022 11:22 AM
407	02/01/2022 12:19 PM
408	02/01/2022 12:28 PM
409	02/01/2022 12:46 PM
410	02/01/2022 12:49 PM
411	02/01/2022 01:50 PM
412	02/01/2022 03:40 PM
413	02/01/2022 04:27 PM
414	02/01/2022 06:36 PM
415	02/01/2022 07:12 PM
416	02/01/2022 09:03 PM
417	02/01/2022 09:15 PM
418	02/01/2022 09:45 PM
419	02/01/2022 11:36 PM
420	03/01/2022 08:29 AM
421	03/01/2022 08:45 AM
422	03/01/2022 09:22 AM
423	03/01/2022 09:29 AM
424	03/01/2022 11:01 AM
425	03/01/2022 12:12 PM
426	03/01/2022 12:13 PM
427	03/01/2022 01:30 PM
428	03/01/2022 02:04 PM
429	03/01/2022 02:14 PM
430	03/01/2022 02:19 PM
431	03/01/2022 02:44 PM
432	03/01/2022 03:24 PM
433	03/01/2022 05:00 PM
434	03/01/2022 05:16 PM
435	03/01/2022 06:36 PM
436	03/01/2022 06:45 PM
437	03/01/2022 06:51 PM
438	03/01/2022 08:46 PM
439	03/01/2022 09:09 PM
440	03/01/2022 09:44 PM
441	03/01/2022 09:47 PM
442	03/01/2022 10:03 PM
443	03/01/2022 10:11 PM
444	03/01/2022 11:18 PM
445	03/01/2022 11:19 PM
446	04/01/2022 09:15 AM
447	04/01/2022 09:24 AM
448	04/01/2022 09:29 AM
449	04/01/2022 09:51 AM
450	04/01/2022 09:57 AM
451	04/01/2022 09:58 AM
452	04/01/2022 10:17 AM
453	04/01/2022 10:42 AM
454	04/01/2022 10:48 AM
455	04/01/2022 11:29 AM
456	04/01/2022 11:59 AM
457	04/01/2022 11:59 AM
458	04/01/2022 12:04 PM
459	04/01/2022 12:49 PM
460	04/01/2022 01:13 PM
461	04/01/2022 01:16 PM
462	04/01/2022 02:18 PM
463	04/01/2022 03:09 PM
464	04/01/2022 03:10 PM
465	04/01/2022 03:16 PM
466	04/01/2022 03:27 PM
467	04/01/2022 03:34 PM
468	04/01/2022 03:47 PM
469	04/01/2022 04:07 PM
470	04/01/2022 04:21 PM
471	04/01/2022 04:33 PM
472	04/01/2022 05:01 PM
473	04/01/2022 05:33 PM
474	04/01/2022 05:35 PM
475	04/01/2022 05:46 PM
476	04/01/2022 06:13 PM
477	04/01/2022 06:28 PM
478	04/01/2022 06:37 PM
479	04/01/2022 07:16 PM
480	04/01/2022 07:34 PM
481	04/01/2022 07:44 PM
482	04/01/2022 07:52 PM
483	04/01/2022 08:03 PM
484	04/01/2022 08:30 PM
485	04/01/2022 09:46 PM
486	04/01/2022 10:04 PM
487	04/01/2022 10:28 PM
488	04/01/2022 10:31 PM
489	05/01/2022 12:15 AM
490	05/01/2022 06:26 AM
491	05/01/2022 06:29 AM
492	05/01/2022 07:12 AM
493	05/01/2022 07:50 AM
494	05/01/2022 07:56 AM
495	05/01/2022 08:53 AM
496	05/01/2022 09:17 AM
497	05/01/2022 09:26 AM
498	05/01/2022 09:30 AM
499	05/01/2022 09:32 AM
500	05/01/2022 09:40 AM
501	05/01/2022 09:43 AM
502	05/01/2022 09:55 AM
503	05/01/2022 09:57 AM
504	05/01/2022 10:02 AM
505	05/01/2022 10:17 AM
506	05/01/2022 10:17 AM
507	05/01/2022 10:28 AM
508	05/01/2022 10:29 AM
509	05/01/2022 11:01 AM
510	05/01/2022 11:03 AM
511	05/01/2022 11:10 AM
512	05/01/2022 11:13 AM
513	05/01/2022 01:09 PM
514	05/01/2022 01:36 PM
515	05/01/2022 01:54 PM
516	05/01/2022 01:54 PM
517	05/01/2022 02:58 PM
518	05/01/2022 02:59 PM
519	05/01/2022 03:10 PM
520	05/01/2022 03:32 PM
521	05/01/2022 04:27 PM
522	05/01/2022 04:34 PM
523	05/01/2022 04:47 PM
524	05/01/2022 05:07 PM
525	05/01/2022 05:16 PM
526	05/01/2022 05:33 PM
527	05/01/2022 06:33 PM
528	05/01/2022 06:50 PM
529	05/01/2022 07:27 PM
530	05/01/2022 07:32 PM
531	05/01/2022 07:38 PM
532	05/01/2022 09:51 PM
533	05/01/2022 10:19 PM
534	05/01/2022 10:21 PM
535	06/01/2022 08:18 AM
536	06/01/2022 08:25 AM
537	06/01/2022 08:55 AM
538	06/01/2022 09:11 AM
539	06/01/2022 09:13 AM
540	06/01/2022 10:28 AM
541	06/01/2022 10:52 AM
542	06/01/2022 10:56 AM
543	06/01/2022 11:27 AM
544	06/01/2022 12:01 PM
545	06/01/2022 12:42 PM
546	06/01/2022 12:48 PM
547	06/01/2022 12:50 PM
548	06/01/2022 01:57 PM
549	06/01/2022 01:59 PM
550	06/01/2022 02:45 PM
551	06/01/2022 02:48 PM
552	06/01/2022 02:51 PM
553	06/01/2022 02:58 PM
554	06/01/2022 03:08 PM
555	06/01/2022 03:22 PM
556	06/01/2022 03:38 PM
557	06/01/2022 04:03 PM
558	06/01/2022 04:13 PM
559	06/01/2022 04:29 PM
560	06/01/2022 04:59 PM
561	06/01/2022 05:20 PM
562	06/01/2022 05:21 PM
563	06/01/2022 06:02 PM
564	06/01/2022 06:08 PM
565	06/01/2022 06:12 PM
566	06/01/2022 06:18 PM
567	06/01/2022 06:40 PM
568	06/01/2022 06:55 PM
569	06/01/2022 07:45 PM
570	06/01/2022 08:14 PM
571	06/01/2022 08:36 PM
572	06/01/2022 08:39 PM
573	06/01/2022 09:05 PM
574	06/01/2022 10:01 PM
575	06/01/2022 10:37 PM
576	06/01/2022 10:52 PM
577	06/01/2022 11:18 PM
578	06/01/2022 11:21 PM
579	07/01/2022 03:11 AM
580	07/01/2022 04:13 AM
581	07/01/2022 06:16 AM
582	07/01/2022 07:20 AM
583	07/01/2022 09:32 AM
584	07/01/2022 10:22 AM
585	07/01/2022 10:34 AM
586	07/01/2022 10:59 AM
587	07/01/2022 11:23 AM
588	07/01/2022 11:26 AM
589	07/01/2022 11:46 AM
590	07/01/2022 12:07 PM
591	07/01/2022 01:06 PM
592	07/01/2022 01:08 PM
593	07/01/2022 01:13 PM
594	07/01/2022 01:15 PM
595	07/01/2022 01:43 PM
596	07/01/2022 02:20 PM
597	07/01/2022 02:24 PM
598	07/01/2022 02:41 PM
599	07/01/2022 02:45 PM
600	07/01/2022 02:54 PM
601	07/01/2022 02:57 PM
602	07/01/2022 03:05 PM
603	07/01/2022 03:13 PM
604	07/01/2022 03:39 PM
605	07/01/2022 03:56 PM
606	07/01/2022 03:59 PM
607	07/01/2022 04:01 PM
608	07/01/2022 04:09 PM
609	07/01/2022 04:13 PM
610	07/01/2022 04:25 PM
611	07/01/2022 04:27 PM
612	07/01/2022 04:27 PM
613	07/01/2022 04:31 PM
614	07/01/2022 04:42 PM
615	07/01/2022 04:46 PM
616	07/01/2022 04:49 PM
617	07/01/2022 04:52 PM
618	07/01/2022 04:57 PM
619	07/01/2022 04:57 PM
620	07/01/2022 05:00 PM
621	07/01/2022 05:37 PM
622	07/01/2022 05:38 PM
623	07/01/2022 05:58 PM
624	07/01/2022 06:01 PM
625	07/01/2022 06:15 PM
626	07/01/2022 06:27 PM
627	07/01/2022 06:40 PM
628	07/01/2022 06:51 PM
629	07/01/2022 07:53 PM
630	07/01/2022 08:05 PM
631	07/01/2022 08:40 PM
632	07/01/2022 09:38 PM
633	07/01/2022 10:22 PM
634	08/01/2022 04:12 AM
635	08/01/2022 07:23 AM
636	08/01/2022 07:54 AM
637	08/01/2022 08:09 AM
638	08/01/2022 09:34 AM
639	08/01/2022 09:48 AM
640	08/01/2022 10:37 AM
641	08/01/2022 11:17 AM
642	08/01/2022 11:22 AM
643	08/01/2022 11:37 AM
644	08/01/2022 12:19 PM
645	08/01/2022 12:47 PM
646	08/01/2022 12:48 PM
647	08/01/2022 12:49 PM
648	08/01/2022 01:20 PM
649	08/01/2022 01:27 PM
650	08/01/2022 01:48 PM
651	08/01/2022 04:03 PM
652	08/01/2022 05:44 PM
653	08/01/2022 06:06 PM
654	08/01/2022 06:34 PM
655	08/01/2022 06:37 PM
656	08/01/2022 06:54 PM
657	08/01/2022 07:13 PM
658	08/01/2022 07:23 PM
659	08/01/2022 07:41 PM
660	08/01/2022 07:43 PM
661	08/01/2022 08:09 PM
662	08/01/2022 08:42 PM
663	08/01/2022 09:58 PM
664	08/01/2022 10:21 PM
665	09/01/2022 02:03 AM
666	09/01/2022 08:02 AM
667	09/01/2022 08:41 AM
668	09/01/2022 09:09 AM
669	09/01/2022 09:16 AM
670	09/01/2022 10:07 AM
671	09/01/2022 10:57 AM
672	09/01/2022 11:11 AM
673	09/01/2022 11:38 AM
674	09/01/2022 12:43 PM
675	09/01/2022 01:24 PM
676	09/01/2022 01:35 PM
677	09/01/2022 01:54 PM
678	09/01/2022 02:07 PM
679	09/01/2022 02:19 PM
680	09/01/2022 03:01 PM
681	09/01/2022 03:17 PM
682	09/01/2022 04:17 PM
683	09/01/2022 05:43 PM
684	09/01/2022 05:45 PM
685	09/01/2022 06:14 PM
686	09/01/2022 07:07 PM
687	09/01/2022 08:15 PM
688	09/01/2022 09:25 PM
689	09/01/2022 09:40 PM
690	09/01/2022 09:41 PM
691	09/01/2022 09:42 PM
692	09/01/2022 09:53 PM
693	09/01/2022 10:15 PM
694	09/01/2022 11:17 PM
695	10/01/2022 12:01 AM
696	10/01/2022 12:05 AM
697	10/01/2022 08:14 AM
698	10/01/2022 08:45 AM
699	10/01/2022 09:06 AM
700	10/01/2022 09:51 AM
701	10/01/2022 10:14 AM
702	10/01/2022 10:26 AM
703	10/01/2022 10:39 AM
704	10/01/2022 10:53 AM
705	10/01/2022 11:55 AM
706	10/01/2022 01:28 PM
707	10/01/2022 01:30 PM
708	10/01/2022 01:33 PM
709	10/01/2022 01:56 PM
710	10/01/2022 02:23 PM
711	10/01/2022 02:54 PM
712	10/01/2022 03:15 PM
713	10/01/2022 04:08 PM
714	10/01/2022 04:37 PM
715	10/01/2022 04:55 PM
716	10/01/2022 06:02 PM
717	10/01/2022 06:28 PM
718	10/01/2022 06:48 PM
719	10/01/2022 06:49 PM
720	10/01/2022 07:06 PM
721	10/01/2022 07:14 PM
722	10/01/2022 07:31 PM
723	10/01/2022 07:59 PM
724	10/01/2022 08:27 PM
725	10/01/2022 08:42 PM
726	10/01/2022 09:40 PM
727	10/01/2022 09:53 PM
728	10/01/2022 10:08 PM
729	10/01/2022 10:08 PM
730	11/01/2022 06:08 AM
731	11/01/2022 07:42 AM
732	11/01/2022 07:56 AM
733	11/01/2022 08:28 AM
734	11/01/2022 09:14 AM
735	11/01/2022 09:16 AM
736	11/01/2022 09:21 AM
737	11/01/2022 09:24 AM
738	11/01/2022 09:36 AM
739	11/01/2022 09:58 AM
740	11/01/2022 10:03 AM
741	11/01/2022 10:16 AM
742	11/01/2022 10:24 AM
743	11/01/2022 10:25 AM
744	11/01/2022 10:29 AM
745	11/01/2022 10:39 AM
746	11/01/2022 11:10 AM
747	11/01/2022 11:12 AM
748	11/01/2022 11:19 AM
749	11/01/2022 12:42 PM
750	11/01/2022 01:05 PM
751	11/01/2022 01:06 PM
752	11/01/2022 01:17 PM
753	11/01/2022 01:32 PM
754	11/01/2022 01:36 PM
755	11/01/2022 01:44 PM
756	11/01/2022 01:55 PM
757	11/01/2022 02:13 PM
758	11/01/2022 02:44 PM
759	11/01/2022 03:41 PM
760	11/01/2022 03:54 PM
761	11/01/2022 04:50 PM
762	11/01/2022 05:41 PM
763	11/01/2022 06:08 PM
764	11/01/2022 06:12 PM
765	11/01/2022 06:56 PM
766	11/01/2022 07:13 PM
767	11/01/2022 07:35 PM
768	11/01/2022 08:55 PM
769	11/01/2022 09:02 PM
770	11/01/2022 09:40 PM
771	11/01/2022 11:04 PM
772	11/01/2022 11:31 PM
773	12/01/2022 03:20 AM
774	12/01/2022 05:10 AM
775	12/01/2022 07:31 AM
776	12/01/2022 07:44 AM
777	12/01/2022 09:47 AM
778	12/01/2022 10:18 AM
779	12/01/2022 10:25 AM
780	12/01/2022 10:52 AM
781	12/01/2022 11:12 AM
782	12/01/2022 11:40 AM
783	12/01/2022 12:19 PM
784	12/01/2022 12:29 PM
785	12/01/2022 01:30 PM
786	12/01/2022 01:50 PM
787	12/01/2022 02:04 PM
788	12/01/2022 02:52 PM
789	12/01/2022 03:16 PM
790	12/01/2022 04:33 PM
791	12/01/2022 04:55 PM
792	12/01/2022 05:00 PM
793	12/01/2022 05:37 PM
794	12/01/2022 05:37 PM
795	12/01/2022 07:44 PM
796	12/01/2022 07:50 PM
797	12/01/2022 08:08 PM
798	12/01/2022 08:35 PM
799	12/01/2022 08:38 PM
800	12/01/2022 09:10 PM
801	12/01/2022 09:28 PM
802	12/01/2022 11:04 PM
803	13/01/2022 08:08 AM
804	13/01/2022 08:09 AM
805	13/01/2022 08:14 AM
806	13/01/2022 08:44 AM
807	13/01/2022 09:30 AM
808	13/01/2022 10:15 AM
809	13/01/2022 10:18 AM
810	13/01/2022 10:21 AM
811	13/01/2022 11:29 AM
812	13/01/2022 11:38 AM
813	13/01/2022 11:45 AM
814	13/01/2022 12:07 PM
815	13/01/2022 12:26 PM
816	13/01/2022 12:49 PM
817	13/01/2022 12:55 PM
818	13/01/2022 12:56 PM
819	13/01/2022 12:59 PM
820	13/01/2022 01:25 PM
821	13/01/2022 01:32 PM
822	13/01/2022 01:42 PM
823	13/01/2022 02:23 PM
824	13/01/2022 02:37 PM
825	13/01/2022 03:06 PM
826	13/01/2022 03:10 PM
827	13/01/2022 03:53 PM
828	13/01/2022 04:16 PM
829	13/01/2022 04:27 PM
830	13/01/2022 04:34 PM
831	13/01/2022 04:53 PM
832	13/01/2022 05:35 PM
833	13/01/2022 07:31 PM
834	13/01/2022 07:52 PM
835	13/01/2022 08:51 PM
836	13/01/2022 09:39 PM
837	13/01/2022 09:58 PM
838	13/01/2022 09:59 PM
839	13/01/2022 10:28 PM
840	13/01/2022 10:40 PM
841	13/01/2022 10:52 PM
842	14/01/2022 07:49 AM
843	14/01/2022 08:00 AM
844	14/01/2022 09:10 AM
845	14/01/2022 09:13 AM
846	14/01/2022 10:05 AM
847	14/01/2022 10:38 AM
848	14/01/2022 10:41 AM
849	14/01/2022 10:57 AM
850	14/01/2022 11:14 AM
851	14/01/2022 11:15 AM
852	14/01/2022 11:36 AM
853	14/01/2022 11:37 AM
854	14/01/2022 11:56 AM
855	14/01/2022 11:56 AM
856	14/01/2022 12:00 PM
857	14/01/2022 12:13 PM
858	14/01/2022 12:30 PM
859	14/01/2022 12:33 PM
860	14/01/2022 01:01 PM
861	14/01/2022 01:30 PM
862	14/01/2022 01:42 PM
863	14/01/2022 02:01 PM
864	14/01/2022 02:25 PM
865	14/01/2022 02:31 PM
866	14/01/2022 02:34 PM
867	14/01/2022 02:34 PM
868	14/01/2022 02:43 PM
869	14/01/2022 02:57 PM
870	14/01/2022 03:31 PM
871	14/01/2022 03:32 PM
872	14/01/2022 03:54 PM
873	14/01/2022 04:09 PM
874	14/01/2022 05:03 PM
875	14/01/2022 06:12 PM
876	14/01/2022 06:30 PM
877	14/01/2022 07:01 PM
878	14/01/2022 07:54 PM
879	14/01/2022 07:59 PM
880	14/01/2022 08:38 PM
881	14/01/2022 09:12 PM
882	14/01/2022 11:01 PM
883	15/01/2022 01:36 AM
884	15/01/2022 06:51 AM
885	15/01/2022 09:40 AM
886	15/01/2022 10:22 AM
887	15/01/2022 10:45 AM
888	15/01/2022 12:14 PM
889	15/01/2022 12:23 PM
890	15/01/2022 12:36 PM
891	15/01/2022 01:00 PM
892	15/01/2022 01:40 PM
893	15/01/2022 01:50 PM
894	15/01/2022 02:05 PM
895	15/01/2022 02:32 PM
896	15/01/2022 03:07 PM
897	15/01/2022 03:36 PM
898	15/01/2022 05:05 PM
899	15/01/2022 05:28 PM
900	15/01/2022 06:35 PM
901	15/01/2022 07:01 PM
902	15/01/2022 07:03 PM
903	15/01/2022 09:02 PM
904	15/01/2022 09:13 PM
905	16/01/2022 12:41 AM
906	16/01/2022 07:40 AM
907	16/01/2022 07:51 AM
908	16/01/2022 07:53 AM
909	16/01/2022 09:37 AM
910	16/01/2022 10:42 AM
911	16/01/2022 11:14 AM
912	16/01/2022 11:21 AM
913	16/01/2022 11:51 AM
914	16/01/2022 11:53 AM
915	16/01/2022 01:05 PM
916	16/01/2022 01:54 PM
917	16/01/2022 02:06 PM
918	16/01/2022 02:20 PM
919	16/01/2022 02:52 PM
920	16/01/2022 05:02 PM
921	16/01/2022 05:55 PM
922	16/01/2022 06:16 PM
923	16/01/2022 07:18 PM
924	16/01/2022 07:26 PM
925	16/01/2022 07:42 PM
926	16/01/2022 08:15 PM
927	16/01/2022 09:16 PM
928	16/01/2022 09:17 PM
929	17/01/2022 12:00 AM
930	17/01/2022 06:52 AM
931	17/01/2022 07:11 AM
932	17/01/2022 07:43 AM
933	17/01/2022 07:45 AM
934	17/01/2022 08:16 AM
935	17/01/2022 09:33 AM
936	17/01/2022 09:45 AM
937	17/01/2022 10:04 AM
938	17/01/2022 10:06 AM
939	17/01/2022 10:34 AM
940	17/01/2022 11:40 AM
941	17/01/2022 11:58 AM
942	17/01/2022 12:25 PM
943	17/01/2022 12:32 PM
944	17/01/2022 12:59 PM
945	17/01/2022 02:03 PM
946	17/01/2022 02:45 PM
947	17/01/2022 02:46 PM
948	17/01/2022 03:31 PM
949	17/01/2022 04:11 PM
950	17/01/2022 04:36 PM
951	17/01/2022 06:02 PM
952	17/01/2022 06:03 PM
953	17/01/2022 06:03 PM
954	17/01/2022 06:08 PM
955	17/01/2022 08:09 PM
956	17/01/2022 08:29 PM
957	18/01/2022 12:17 AM
958	18/01/2022 08:41 AM
959	18/01/2022 09:30 AM
960	18/01/2022 10:24 AM
961	18/01/2022 11:03 AM
962	18/01/2022 12:24 PM
963	18/01/2022 01:44 PM
964	18/01/2022 01:46 PM
965	18/01/2022 01:48 PM
966	18/01/2022 01:48 PM
967	18/01/2022 01:50 PM
968	18/01/2022 01:50 PM
969	18/01/2022 02:00 PM
970	18/01/2022 02:00 PM
971	18/01/2022 02:05 PM
972	18/01/2022 02:50 PM
973	18/01/2022 03:18 PM
974	18/01/2022 03:24 PM
975	18/01/2022 03:35 PM
976	18/01/2022 03:35 PM
977	18/01/2022 03:36 PM
978	18/01/2022 03:38 PM
979	18/01/2022 03:39 PM
980	18/01/2022 05:00 PM
981	18/01/2022 05:02 PM
982	18/01/2022 06:01 PM
983	18/01/2022 06:23 PM
984	18/01/2022 06:42 PM
985	18/01/2022 07:32 PM
986	18/01/2022 07:32 PM
987	18/01/2022 07:52 PM
988	18/01/2022 08:38 PM
989	18/01/2022 10:41 PM
990	18/01/2022 11:03 PM
991	19/01/2022 05:54 AM
992	19/01/2022 07:41 AM
993	19/01/2022 08:10 AM
994	19/01/2022 09:11 AM
995	19/01/2022 10:10 AM
996	19/01/2022 10:15 AM
997	Total records in this page :995 Records
Ticket distribution by time

 

[BSALV]

use 1 or several pivottables, so you can see which period (half hour) in a day is the busiest.
A 2nd pivottable to see which day is the busiest etc.

 

[leanheart]

use 1 or several pivottables, so you can see which period (half hour) in a day is the busiest.
A 2nd pivottable to see which day is the busiest etc.

Would you be able to let me know how to tell the pivot table to sort the times into half hour intervals?

 

[BSALV]

too late to edit a link in previous post,sample file

tickets.xlsx
	A	B	C	D	E	F
1	Created Time	day	datum	x	weeknr	half hour
2	21/12/2021 0:03	1,00	di 21/12/21	x	week 51	00:00
3	21/12/2021 7:11	1,00	di 21/12/21	x	week 51	07:00
4	21/12/2021 7:39	1,00	di 21/12/21	x	week 51	07:30
5	21/12/2021 8:24	1,00	di 21/12/21	x	week 51	08:00
6	21/12/2021 8:46	1,00	di 21/12/21	x	week 51	08:30
7	21/12/2021 9:17	1,00	di 21/12/21	x	week 51	09:00
8	21/12/2021 9:34	1,00	di 21/12/21	x	week 51	09:30
9	21/12/2021 9:47	1,00	di 21/12/21	x	week 51	09:30
10	21/12/2021 9:54	1,00	di 21/12/21	x	week 51	09:30
Blad1

Cell Formulas
Range	Formula
B2:B10	B2	=TRUNC([@[Created Time]])-DATE(2021,12,20)
C2:C10	C2	=TRUNC([@[Created Time]])
D2:D10	D2	="x"
E2:E10	E2	="week " & ISOWEEKNUM([@[Created Time]])
F2:F10	F2	=TEXT(FLOOR.MATH(MOD([@[Created Time]],1),1/48),"uu:mm")

 

[JamesCanale]

I went a different way. I took the average cases in each hour of the day and then seen how many cases would be on an 8-hour shift - then tried to minimize the difference in total caseload from the busiest to the least busy shift (if that is a criteria). Having a shift start at 2, 3, or 4 in the morning (and other shifts starting 8 and 16 hours after) minimizes the imbalance.

MrExcelPlayground6.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Created Time (Ticket)		Hour	Average Cases per hour	Shift Starting at this hour sees this many cases	Next Shift	Third Shift	Normalized			Max Imbalance
2	12/21/2021 12:03 AM	0	0	0.40	2.23	18.63	12.30	1.0	8.3	5.5	8.3
3	12/21/2021 7:11 AM	7	1	0.20	3.13	19.43	10.60	1.0	6.2	3.4	6.2
4	12/21/2021 7:39 AM	7	2	0.03	6.10	18.00	9.07	1.0	3.0	1.5	3.0
5	12/21/2021 8:24 AM	8	3	0.07	8.77	17.50	6.90	1.3	2.5	1.0	2.5
6	12/21/2021 8:46 AM	8	4	0.10	11.07	17.00	5.10	2.2	3.3	1.0	3.3
7	12/21/2021 9:17 AM	9	5	0.10	13.03	16.30	3.83	3.4	4.3	1.0	4.3
8	12/21/2021 9:34 AM	9	6	0.40	15.33	15.17	2.67	5.8	5.7	1.0	5.8
9	12/21/2021 9:47 AM	9	7	0.93	17.20	13.97	2.00	8.6	7.0	1.0	8.6
10	12/21/2021 9:54 AM	9	8	1.30	18.63	12.30	2.23	8.3	5.5	1.0	8.3
11	12/21/2021 10:01 AM	10	9	3.17	19.43	10.60	3.13	6.2	3.4	1.0	6.2
12	12/21/2021 10:11 AM	10	10	2.70	18.00	9.07	6.10	3.0	1.5	1.0	3.0
13	12/21/2021 10:16 AM	10	11	2.37	17.50	6.90	8.77	2.5	1.0	1.3	2.5
14	12/21/2021 10:21 AM	10	12	2.07	17.00	5.10	11.07	3.3	1.0	2.2	3.3
15	12/21/2021 10:41 AM	10	13	2.40	16.30	3.83	13.03	4.3	1.0	3.4	4.3
16	12/21/2021 10:48 AM	10	14	2.27	15.17	2.67	15.33	5.7	1.0	5.8	5.8
17	12/21/2021 11:25 AM	11	15	2.37	13.97	2.00	17.20	7.0	1.0	8.6	8.6
18	12/21/2021 11:43 AM	11	16	2.10	12.30	2.23	18.63	5.5	1.0	8.3	8.3
19	12/21/2021 12:23 PM	12	17	1.73	10.60	3.13	19.43	3.4	1.0	6.2	6.2
20	12/21/2021 1:40 PM	13	18	2.20	9.07	6.10	18.00	1.5	1.0	3.0	3.0
21	12/21/2021 2:02 PM	14	19	1.87	6.90	8.77	17.50	1.0	1.3	2.5	2.5
22	12/21/2021 3:22 PM	15	20	1.37	5.10	11.07	17.00	1.0	2.2	3.3	3.3
23	12/21/2021 3:38 PM	15	21	1.27	3.83	13.03	16.30	1.0	3.4	4.3	4.3
24	12/21/2021 3:59 PM	15	22	1.07	2.67	15.33	15.17	1.0	5.8	5.7	5.8
25	12/21/2021 4:07 PM	16	23	0.70	2.00	17.20	13.97	1.0	8.6	7.0	8.6
26	12/21/2021 4:19 PM	16	0	0.40	2.23	18.63	12.30	1.0	8.3	5.5	8.3
27	12/21/2021 4:58 PM	16	1	0.20	3.13	19.43
28	12/21/2021 4:59 PM	16	2	0.03	6.10	18.00
29	12/21/2021 5:00 PM	17	3	0.07	8.77	17.50
30	12/21/2021 6:14 PM	18	4	0.10	11.07	17.00
31	12/21/2021 6:41 PM	18	5	0.10	13.03	16.30
32	12/21/2021 6:57 PM	18	6	0.40	15.33	15.17
33	12/21/2021 7:00 PM	19	7	0.93	17.20	13.97
34	12/21/2021 7:07 PM	19	8	1.30	18.63	12.30
35	12/21/2021 7:18 PM	19	9	3.17	19.43
36	12/21/2021 7:45 PM	19	10	2.70	18.00
37	12/21/2021 7:55 PM	19	11	2.37	17.50
38	12/21/2021 8:43 PM	20	12	2.07	17.00
39	12/21/2021 8:44 PM	20	13	2.40	16.30
40	12/21/2021 8:59 PM	20	14	2.27	15.17
41	12/21/2021 9:16 PM	21	15	2.37	13.97
42	12/21/2021 11:50 PM	23	16	2.10	12.30
Sheet16

Cell Formulas
Range	Formula
C2:C49	C2	=MOD(SEQUENCE(48,1,0,1),24)
D2:D49	D2	=COUNTIF(B2:B997,C2#)/30
G2:G26	G2	=SUM(D18:D25)
H2:J26	H2	=E2/MIN($E2:$G2)
K2:K26	K2	=MAX(H2:J2)
F2:F34	F2	=SUM(D10:D17)
B2:B42	B2	=HOUR(A2)
E2:E42	E2	=SUM(D2:D9)
Dynamic array formulas.

 

[BSALV]

okay, i had another kind of tickets in my mind, i thought tickets sold, ....

 

[leanheart]

okay, i had another kind of tickets in my mind, i thought tickets sold, ....

Sorry! We call emails in from customers "tickets" because of the program we use track them. You could just as easily call them contact events or phone calls or emails etc...