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

leanheart

New Member
Joined
Jan 18, 2022
Messages
6
Office Version
  1. 365
Platform
  1. Windows
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
1Created Time (Ticket)
221/12/2021 12:03 AM
321/12/2021 07:11 AM
421/12/2021 07:39 AM
521/12/2021 08:24 AM
621/12/2021 08:46 AM
721/12/2021 09:17 AM
821/12/2021 09:34 AM
921/12/2021 09:47 AM
1021/12/2021 09:54 AM
1121/12/2021 10:01 AM
1221/12/2021 10:11 AM
1321/12/2021 10:16 AM
1421/12/2021 10:21 AM
1521/12/2021 10:41 AM
1621/12/2021 10:48 AM
1721/12/2021 11:25 AM
1821/12/2021 11:43 AM
1921/12/2021 12:23 PM
2021/12/2021 01:40 PM
2121/12/2021 02:02 PM
2221/12/2021 03:22 PM
2321/12/2021 03:38 PM
2421/12/2021 03:59 PM
2521/12/2021 04:07 PM
2621/12/2021 04:19 PM
2721/12/2021 04:58 PM
2821/12/2021 04:59 PM
2921/12/2021 05:00 PM
3021/12/2021 06:14 PM
3121/12/2021 06:41 PM
3221/12/2021 06:57 PM
3321/12/2021 07:00 PM
3421/12/2021 07:07 PM
3521/12/2021 07:18 PM
3621/12/2021 07:45 PM
3721/12/2021 07:55 PM
3821/12/2021 08:43 PM
3921/12/2021 08:44 PM
4021/12/2021 08:59 PM
4121/12/2021 09:16 PM
4221/12/2021 11:50 PM
4322/12/2021 12:07 AM
4422/12/2021 12:14 AM
4522/12/2021 12:28 AM
4622/12/2021 12:34 AM
4722/12/2021 01:14 AM
4822/12/2021 01:56 AM
4922/12/2021 05:49 AM
5022/12/2021 06:32 AM
5122/12/2021 06:38 AM
5222/12/2021 06:47 AM
5322/12/2021 07:10 AM
5422/12/2021 07:39 AM
5522/12/2021 07:51 AM
5622/12/2021 08:10 AM
5722/12/2021 08:26 AM
5822/12/2021 08:28 AM
5922/12/2021 08:37 AM
6022/12/2021 08:44 AM
6122/12/2021 08:47 AM
6222/12/2021 09:06 AM
6322/12/2021 09:09 AM
6422/12/2021 09:20 AM
6522/12/2021 09:21 AM
6622/12/2021 09:26 AM
6722/12/2021 09:34 AM
6822/12/2021 09:35 AM
6922/12/2021 09:38 AM
7022/12/2021 09:44 AM
7122/12/2021 09:47 AM
7222/12/2021 09:48 AM
7322/12/2021 09:52 AM
7422/12/2021 09:55 AM
7522/12/2021 10:09 AM
7622/12/2021 10:16 AM
7722/12/2021 10:19 AM
7822/12/2021 10:29 AM
7922/12/2021 10:53 AM
8022/12/2021 10:54 AM
8122/12/2021 11:50 AM
8222/12/2021 11:54 AM
8322/12/2021 12:20 PM
8422/12/2021 12:24 PM
8522/12/2021 12:33 PM
8622/12/2021 12:58 PM
8722/12/2021 01:10 PM
8822/12/2021 01:36 PM
8922/12/2021 01:37 PM
9022/12/2021 01:44 PM
9122/12/2021 01:48 PM
9222/12/2021 02:53 PM
9322/12/2021 02:54 PM
9422/12/2021 03:30 PM
9522/12/2021 03:56 PM
9622/12/2021 04:04 PM
9722/12/2021 04:36 PM
9822/12/2021 04:47 PM
9922/12/2021 05:14 PM
10022/12/2021 05:23 PM
10122/12/2021 05:37 PM
10222/12/2021 05:56 PM
10322/12/2021 06:35 PM
10422/12/2021 06:38 PM
10522/12/2021 06:42 PM
10622/12/2021 08:04 PM
10722/12/2021 08:26 PM
10822/12/2021 08:30 PM
10922/12/2021 08:52 PM
11022/12/2021 11:04 PM
11123/12/2021 01:54 AM
11223/12/2021 06:38 AM
11323/12/2021 07:22 AM
11423/12/2021 07:30 AM
11523/12/2021 08:22 AM
11623/12/2021 09:00 AM
11723/12/2021 09:11 AM
11823/12/2021 09:19 AM
11923/12/2021 10:02 AM
12023/12/2021 10:07 AM
12123/12/2021 10:15 AM
12223/12/2021 11:27 AM
12323/12/2021 11:41 AM
12423/12/2021 11:54 AM
12523/12/2021 12:45 PM
12623/12/2021 01:00 PM
12723/12/2021 01:01 PM
12823/12/2021 02:49 PM
12923/12/2021 02:59 PM
13023/12/2021 03:12 PM
13123/12/2021 03:27 PM
13223/12/2021 03:30 PM
13323/12/2021 03:39 PM
13423/12/2021 03:53 PM
13523/12/2021 03:57 PM
13623/12/2021 04:39 PM
13723/12/2021 04:45 PM
13823/12/2021 06:44 PM
13923/12/2021 07:09 PM
14023/12/2021 08:06 PM
14124/12/2021 06:19 AM
14224/12/2021 07:49 AM
14324/12/2021 08:04 AM
14424/12/2021 10:20 AM
14524/12/2021 10:37 AM
14624/12/2021 10:42 AM
14724/12/2021 11:32 AM
14824/12/2021 11:48 AM
14924/12/2021 11:53 AM
15024/12/2021 01:14 PM
15124/12/2021 01:16 PM
15224/12/2021 01:30 PM
15324/12/2021 02:10 PM
15424/12/2021 02:57 PM
15524/12/2021 03:10 PM
15624/12/2021 03:59 PM
15724/12/2021 06:46 PM
15824/12/2021 08:59 PM
15924/12/2021 11:38 PM
16025/12/2021 10:59 AM
16125/12/2021 11:08 AM
16225/12/2021 02:06 PM
16325/12/2021 02:41 PM
16425/12/2021 06:42 PM
16525/12/2021 10:13 PM
16626/12/2021 08:19 AM
16726/12/2021 09:02 AM
16826/12/2021 09:06 AM
16926/12/2021 09:07 AM
17026/12/2021 09:09 AM
17126/12/2021 09:09 AM
17226/12/2021 09:12 AM
17326/12/2021 09:14 AM
17426/12/2021 09:14 AM
17526/12/2021 09:15 AM
17626/12/2021 09:18 AM
17726/12/2021 09:18 AM
17826/12/2021 09:20 AM
17926/12/2021 09:21 AM
18026/12/2021 09:21 AM
18126/12/2021 09:27 AM
18226/12/2021 09:48 AM
18326/12/2021 09:48 AM
18426/12/2021 09:49 AM
18526/12/2021 09:51 AM
18626/12/2021 09:52 AM
18726/12/2021 09:55 AM
18826/12/2021 09:58 AM
18926/12/2021 10:21 AM
19026/12/2021 10:30 AM
19126/12/2021 10:35 AM
19226/12/2021 10:36 AM
19326/12/2021 10:48 AM
19426/12/2021 11:16 AM
19526/12/2021 11:28 AM
19626/12/2021 11:42 AM
19726/12/2021 11:53 AM
19826/12/2021 11:57 AM
19926/12/2021 12:29 PM
20026/12/2021 12:38 PM
20126/12/2021 12:50 PM
20226/12/2021 01:19 PM
20326/12/2021 02:24 PM
20426/12/2021 02:59 PM
20526/12/2021 03:08 PM
20626/12/2021 03:43 PM
20726/12/2021 03:47 PM
20826/12/2021 03:51 PM
20926/12/2021 04:49 PM
21026/12/2021 05:24 PM
21126/12/2021 05:51 PM
21226/12/2021 07:12 PM
21326/12/2021 07:27 PM
21426/12/2021 07:53 PM
21526/12/2021 08:51 PM
21626/12/2021 08:58 PM
21726/12/2021 09:29 PM
21826/12/2021 09:32 PM
21926/12/2021 10:20 PM
22026/12/2021 10:39 PM
22126/12/2021 10:49 PM
22227/12/2021 07:24 AM
22327/12/2021 08:36 AM
22427/12/2021 09:23 AM
22527/12/2021 09:59 AM
22627/12/2021 10:26 AM
22727/12/2021 10:55 AM
22827/12/2021 11:01 AM
22927/12/2021 12:33 PM
23027/12/2021 01:33 PM
23127/12/2021 01:38 PM
23227/12/2021 03:03 PM
23327/12/2021 03:59 PM
23427/12/2021 04:01 PM
23527/12/2021 04:29 PM
23627/12/2021 04:37 PM
23727/12/2021 04:48 PM
23827/12/2021 05:27 PM
23927/12/2021 07:20 PM
24027/12/2021 08:39 PM
24127/12/2021 10:01 PM
24227/12/2021 10:34 PM
24327/12/2021 11:08 PM
24428/12/2021 07:40 AM
24528/12/2021 08:58 AM
24628/12/2021 08:59 AM
24728/12/2021 10:50 AM
24828/12/2021 11:05 AM
24928/12/2021 11:56 AM
25028/12/2021 02:10 PM
25128/12/2021 02:31 PM
25228/12/2021 02:46 PM
25328/12/2021 03:04 PM
25428/12/2021 03:13 PM
25528/12/2021 03:21 PM
25628/12/2021 03:23 PM
25728/12/2021 04:08 PM
25828/12/2021 05:01 PM
25928/12/2021 06:06 PM
26028/12/2021 06:34 PM
26128/12/2021 07:43 PM
26228/12/2021 08:26 PM
26328/12/2021 08:57 PM
26428/12/2021 09:28 PM
26528/12/2021 10:20 PM
26628/12/2021 10:28 PM
26728/12/2021 11:10 PM
26829/12/2021 08:23 AM
26929/12/2021 08:45 AM
27029/12/2021 08:51 AM
27129/12/2021 09:23 AM
27229/12/2021 09:49 AM
27329/12/2021 09:51 AM
27429/12/2021 12:45 PM
27529/12/2021 01:05 PM
27629/12/2021 02:52 PM
27729/12/2021 03:09 PM
27829/12/2021 03:39 PM
27929/12/2021 04:13 PM
28029/12/2021 05:30 PM
28129/12/2021 05:49 PM
28229/12/2021 06:19 PM
28329/12/2021 06:53 PM
28429/12/2021 07:34 PM
28529/12/2021 07:53 PM
28629/12/2021 08:27 PM
28729/12/2021 09:26 PM
28829/12/2021 11:59 PM
28930/12/2021 08:37 AM
29030/12/2021 09:16 AM
29130/12/2021 09:33 AM
29230/12/2021 09:49 AM
29330/12/2021 10:33 AM
29430/12/2021 10:50 AM
29530/12/2021 10:51 AM
29630/12/2021 11:47 AM
29730/12/2021 11:50 AM
29830/12/2021 11:50 AM
29930/12/2021 11:52 AM
30030/12/2021 11:59 AM
30130/12/2021 12:12 PM
30230/12/2021 12:18 PM
30330/12/2021 12:19 PM
30430/12/2021 12:20 PM
30530/12/2021 12:25 PM
30630/12/2021 12:57 PM
30730/12/2021 01:15 PM
30830/12/2021 01:21 PM
30930/12/2021 01:27 PM
31030/12/2021 01:38 PM
31130/12/2021 01:58 PM
31230/12/2021 02:23 PM
31330/12/2021 02:30 PM
31430/12/2021 02:44 PM
31530/12/2021 03:23 PM
31630/12/2021 03:25 PM
31730/12/2021 03:53 PM
31830/12/2021 04:03 PM
31930/12/2021 04:16 PM
32030/12/2021 04:29 PM
32130/12/2021 05:17 PM
32230/12/2021 05:39 PM
32330/12/2021 05:45 PM
32430/12/2021 05:56 PM
32530/12/2021 06:04 PM
32630/12/2021 06:06 PM
32730/12/2021 06:37 PM
32830/12/2021 06:41 PM
32930/12/2021 06:44 PM
33030/12/2021 07:21 PM
33130/12/2021 07:39 PM
33230/12/2021 07:47 PM
33330/12/2021 08:06 PM
33430/12/2021 08:49 PM
33530/12/2021 10:01 PM
33630/12/2021 10:04 PM
33730/12/2021 10:07 PM
33830/12/2021 11:01 PM
33930/12/2021 11:17 PM
34031/12/2021 12:16 AM
34131/12/2021 01:37 AM
34231/12/2021 04:49 AM
34331/12/2021 06:51 AM
34431/12/2021 09:56 AM
34531/12/2021 10:49 AM
34631/12/2021 11:04 AM
34731/12/2021 11:24 AM
34831/12/2021 11:24 AM
34931/12/2021 11:27 AM
35031/12/2021 11:57 AM
35131/12/2021 12:14 PM
35231/12/2021 12:31 PM
35331/12/2021 12:32 PM
35431/12/2021 12:45 PM
35531/12/2021 01:24 PM
35631/12/2021 02:06 PM
35731/12/2021 02:34 PM
35831/12/2021 03:06 PM
35931/12/2021 04:29 PM
36031/12/2021 04:35 PM
36131/12/2021 04:48 PM
36231/12/2021 05:07 PM
36331/12/2021 05:10 PM
36431/12/2021 05:12 PM
36531/12/2021 05:15 PM
36631/12/2021 05:17 PM
36731/12/2021 05:20 PM
36831/12/2021 05:26 PM
36931/12/2021 06:16 PM
37031/12/2021 06:30 PM
37131/12/2021 06:36 PM
37231/12/2021 06:38 PM
37331/12/2021 07:28 PM
37431/12/2021 09:25 PM
37531/12/2021 11:08 PM
37631/12/2021 11:10 PM
37701/01/2022 08:37 AM
37801/01/2022 09:37 AM
37901/01/2022 09:43 AM
38001/01/2022 09:57 AM
38101/01/2022 10:05 AM
38201/01/2022 10:41 AM
38301/01/2022 11:38 AM
38401/01/2022 11:56 AM
38501/01/2022 12:23 PM
38601/01/2022 12:34 PM
38701/01/2022 12:54 PM
38801/01/2022 02:14 PM
38901/01/2022 02:37 PM
39001/01/2022 03:07 PM
39101/01/2022 03:09 PM
39201/01/2022 04:11 PM
39301/01/2022 04:30 PM
39401/01/2022 06:38 PM
39501/01/2022 07:02 PM
39601/01/2022 07:05 PM
39701/01/2022 07:39 PM
39801/01/2022 08:42 PM
39901/01/2022 09:16 PM
40001/01/2022 09:48 PM
40101/01/2022 10:32 PM
40201/01/2022 10:51 PM
40302/01/2022 01:54 AM
40402/01/2022 10:01 AM
40502/01/2022 10:47 AM
40602/01/2022 11:22 AM
40702/01/2022 12:19 PM
40802/01/2022 12:28 PM
40902/01/2022 12:46 PM
41002/01/2022 12:49 PM
41102/01/2022 01:50 PM
41202/01/2022 03:40 PM
41302/01/2022 04:27 PM
41402/01/2022 06:36 PM
41502/01/2022 07:12 PM
41602/01/2022 09:03 PM
41702/01/2022 09:15 PM
41802/01/2022 09:45 PM
41902/01/2022 11:36 PM
42003/01/2022 08:29 AM
42103/01/2022 08:45 AM
42203/01/2022 09:22 AM
42303/01/2022 09:29 AM
42403/01/2022 11:01 AM
42503/01/2022 12:12 PM
42603/01/2022 12:13 PM
42703/01/2022 01:30 PM
42803/01/2022 02:04 PM
42903/01/2022 02:14 PM
43003/01/2022 02:19 PM
43103/01/2022 02:44 PM
43203/01/2022 03:24 PM
43303/01/2022 05:00 PM
43403/01/2022 05:16 PM
43503/01/2022 06:36 PM
43603/01/2022 06:45 PM
43703/01/2022 06:51 PM
43803/01/2022 08:46 PM
43903/01/2022 09:09 PM
44003/01/2022 09:44 PM
44103/01/2022 09:47 PM
44203/01/2022 10:03 PM
44303/01/2022 10:11 PM
44403/01/2022 11:18 PM
44503/01/2022 11:19 PM
44604/01/2022 09:15 AM
44704/01/2022 09:24 AM
44804/01/2022 09:29 AM
44904/01/2022 09:51 AM
45004/01/2022 09:57 AM
45104/01/2022 09:58 AM
45204/01/2022 10:17 AM
45304/01/2022 10:42 AM
45404/01/2022 10:48 AM
45504/01/2022 11:29 AM
45604/01/2022 11:59 AM
45704/01/2022 11:59 AM
45804/01/2022 12:04 PM
45904/01/2022 12:49 PM
46004/01/2022 01:13 PM
46104/01/2022 01:16 PM
46204/01/2022 02:18 PM
46304/01/2022 03:09 PM
46404/01/2022 03:10 PM
46504/01/2022 03:16 PM
46604/01/2022 03:27 PM
46704/01/2022 03:34 PM
46804/01/2022 03:47 PM
46904/01/2022 04:07 PM
47004/01/2022 04:21 PM
47104/01/2022 04:33 PM
47204/01/2022 05:01 PM
47304/01/2022 05:33 PM
47404/01/2022 05:35 PM
47504/01/2022 05:46 PM
47604/01/2022 06:13 PM
47704/01/2022 06:28 PM
47804/01/2022 06:37 PM
47904/01/2022 07:16 PM
48004/01/2022 07:34 PM
48104/01/2022 07:44 PM
48204/01/2022 07:52 PM
48304/01/2022 08:03 PM
48404/01/2022 08:30 PM
48504/01/2022 09:46 PM
48604/01/2022 10:04 PM
48704/01/2022 10:28 PM
48804/01/2022 10:31 PM
48905/01/2022 12:15 AM
49005/01/2022 06:26 AM
49105/01/2022 06:29 AM
49205/01/2022 07:12 AM
49305/01/2022 07:50 AM
49405/01/2022 07:56 AM
49505/01/2022 08:53 AM
49605/01/2022 09:17 AM
49705/01/2022 09:26 AM
49805/01/2022 09:30 AM
49905/01/2022 09:32 AM
50005/01/2022 09:40 AM
50105/01/2022 09:43 AM
50205/01/2022 09:55 AM
50305/01/2022 09:57 AM
50405/01/2022 10:02 AM
50505/01/2022 10:17 AM
50605/01/2022 10:17 AM
50705/01/2022 10:28 AM
50805/01/2022 10:29 AM
50905/01/2022 11:01 AM
51005/01/2022 11:03 AM
51105/01/2022 11:10 AM
51205/01/2022 11:13 AM
51305/01/2022 01:09 PM
51405/01/2022 01:36 PM
51505/01/2022 01:54 PM
51605/01/2022 01:54 PM
51705/01/2022 02:58 PM
51805/01/2022 02:59 PM
51905/01/2022 03:10 PM
52005/01/2022 03:32 PM
52105/01/2022 04:27 PM
52205/01/2022 04:34 PM
52305/01/2022 04:47 PM
52405/01/2022 05:07 PM
52505/01/2022 05:16 PM
52605/01/2022 05:33 PM
52705/01/2022 06:33 PM
52805/01/2022 06:50 PM
52905/01/2022 07:27 PM
53005/01/2022 07:32 PM
53105/01/2022 07:38 PM
53205/01/2022 09:51 PM
53305/01/2022 10:19 PM
53405/01/2022 10:21 PM
53506/01/2022 08:18 AM
53606/01/2022 08:25 AM
53706/01/2022 08:55 AM
53806/01/2022 09:11 AM
53906/01/2022 09:13 AM
54006/01/2022 10:28 AM
54106/01/2022 10:52 AM
54206/01/2022 10:56 AM
54306/01/2022 11:27 AM
54406/01/2022 12:01 PM
54506/01/2022 12:42 PM
54606/01/2022 12:48 PM
54706/01/2022 12:50 PM
54806/01/2022 01:57 PM
54906/01/2022 01:59 PM
55006/01/2022 02:45 PM
55106/01/2022 02:48 PM
55206/01/2022 02:51 PM
55306/01/2022 02:58 PM
55406/01/2022 03:08 PM
55506/01/2022 03:22 PM
55606/01/2022 03:38 PM
55706/01/2022 04:03 PM
55806/01/2022 04:13 PM
55906/01/2022 04:29 PM
56006/01/2022 04:59 PM
56106/01/2022 05:20 PM
56206/01/2022 05:21 PM
56306/01/2022 06:02 PM
56406/01/2022 06:08 PM
56506/01/2022 06:12 PM
56606/01/2022 06:18 PM
56706/01/2022 06:40 PM
56806/01/2022 06:55 PM
56906/01/2022 07:45 PM
57006/01/2022 08:14 PM
57106/01/2022 08:36 PM
57206/01/2022 08:39 PM
57306/01/2022 09:05 PM
57406/01/2022 10:01 PM
57506/01/2022 10:37 PM
57606/01/2022 10:52 PM
57706/01/2022 11:18 PM
57806/01/2022 11:21 PM
57907/01/2022 03:11 AM
58007/01/2022 04:13 AM
58107/01/2022 06:16 AM
58207/01/2022 07:20 AM
58307/01/2022 09:32 AM
58407/01/2022 10:22 AM
58507/01/2022 10:34 AM
58607/01/2022 10:59 AM
58707/01/2022 11:23 AM
58807/01/2022 11:26 AM
58907/01/2022 11:46 AM
59007/01/2022 12:07 PM
59107/01/2022 01:06 PM
59207/01/2022 01:08 PM
59307/01/2022 01:13 PM
59407/01/2022 01:15 PM
59507/01/2022 01:43 PM
59607/01/2022 02:20 PM
59707/01/2022 02:24 PM
59807/01/2022 02:41 PM
59907/01/2022 02:45 PM
60007/01/2022 02:54 PM
60107/01/2022 02:57 PM
60207/01/2022 03:05 PM
60307/01/2022 03:13 PM
60407/01/2022 03:39 PM
60507/01/2022 03:56 PM
60607/01/2022 03:59 PM
60707/01/2022 04:01 PM
60807/01/2022 04:09 PM
60907/01/2022 04:13 PM
61007/01/2022 04:25 PM
61107/01/2022 04:27 PM
61207/01/2022 04:27 PM
61307/01/2022 04:31 PM
61407/01/2022 04:42 PM
61507/01/2022 04:46 PM
61607/01/2022 04:49 PM
61707/01/2022 04:52 PM
61807/01/2022 04:57 PM
61907/01/2022 04:57 PM
62007/01/2022 05:00 PM
62107/01/2022 05:37 PM
62207/01/2022 05:38 PM
62307/01/2022 05:58 PM
62407/01/2022 06:01 PM
62507/01/2022 06:15 PM
62607/01/2022 06:27 PM
62707/01/2022 06:40 PM
62807/01/2022 06:51 PM
62907/01/2022 07:53 PM
63007/01/2022 08:05 PM
63107/01/2022 08:40 PM
63207/01/2022 09:38 PM
63307/01/2022 10:22 PM
63408/01/2022 04:12 AM
63508/01/2022 07:23 AM
63608/01/2022 07:54 AM
63708/01/2022 08:09 AM
63808/01/2022 09:34 AM
63908/01/2022 09:48 AM
64008/01/2022 10:37 AM
64108/01/2022 11:17 AM
64208/01/2022 11:22 AM
64308/01/2022 11:37 AM
64408/01/2022 12:19 PM
64508/01/2022 12:47 PM
64608/01/2022 12:48 PM
64708/01/2022 12:49 PM
64808/01/2022 01:20 PM
64908/01/2022 01:27 PM
65008/01/2022 01:48 PM
65108/01/2022 04:03 PM
65208/01/2022 05:44 PM
65308/01/2022 06:06 PM
65408/01/2022 06:34 PM
65508/01/2022 06:37 PM
65608/01/2022 06:54 PM
65708/01/2022 07:13 PM
65808/01/2022 07:23 PM
65908/01/2022 07:41 PM
66008/01/2022 07:43 PM
66108/01/2022 08:09 PM
66208/01/2022 08:42 PM
66308/01/2022 09:58 PM
66408/01/2022 10:21 PM
66509/01/2022 02:03 AM
66609/01/2022 08:02 AM
66709/01/2022 08:41 AM
66809/01/2022 09:09 AM
66909/01/2022 09:16 AM
67009/01/2022 10:07 AM
67109/01/2022 10:57 AM
67209/01/2022 11:11 AM
67309/01/2022 11:38 AM
67409/01/2022 12:43 PM
67509/01/2022 01:24 PM
67609/01/2022 01:35 PM
67709/01/2022 01:54 PM
67809/01/2022 02:07 PM
67909/01/2022 02:19 PM
68009/01/2022 03:01 PM
68109/01/2022 03:17 PM
68209/01/2022 04:17 PM
68309/01/2022 05:43 PM
68409/01/2022 05:45 PM
68509/01/2022 06:14 PM
68609/01/2022 07:07 PM
68709/01/2022 08:15 PM
68809/01/2022 09:25 PM
68909/01/2022 09:40 PM
69009/01/2022 09:41 PM
69109/01/2022 09:42 PM
69209/01/2022 09:53 PM
69309/01/2022 10:15 PM
69409/01/2022 11:17 PM
69510/01/2022 12:01 AM
69610/01/2022 12:05 AM
69710/01/2022 08:14 AM
69810/01/2022 08:45 AM
69910/01/2022 09:06 AM
70010/01/2022 09:51 AM
70110/01/2022 10:14 AM
70210/01/2022 10:26 AM
70310/01/2022 10:39 AM
70410/01/2022 10:53 AM
70510/01/2022 11:55 AM
70610/01/2022 01:28 PM
70710/01/2022 01:30 PM
70810/01/2022 01:33 PM
70910/01/2022 01:56 PM
71010/01/2022 02:23 PM
71110/01/2022 02:54 PM
71210/01/2022 03:15 PM
71310/01/2022 04:08 PM
71410/01/2022 04:37 PM
71510/01/2022 04:55 PM
71610/01/2022 06:02 PM
71710/01/2022 06:28 PM
71810/01/2022 06:48 PM
71910/01/2022 06:49 PM
72010/01/2022 07:06 PM
72110/01/2022 07:14 PM
72210/01/2022 07:31 PM
72310/01/2022 07:59 PM
72410/01/2022 08:27 PM
72510/01/2022 08:42 PM
72610/01/2022 09:40 PM
72710/01/2022 09:53 PM
72810/01/2022 10:08 PM
72910/01/2022 10:08 PM
73011/01/2022 06:08 AM
73111/01/2022 07:42 AM
73211/01/2022 07:56 AM
73311/01/2022 08:28 AM
73411/01/2022 09:14 AM
73511/01/2022 09:16 AM
73611/01/2022 09:21 AM
73711/01/2022 09:24 AM
73811/01/2022 09:36 AM
73911/01/2022 09:58 AM
74011/01/2022 10:03 AM
74111/01/2022 10:16 AM
74211/01/2022 10:24 AM
74311/01/2022 10:25 AM
74411/01/2022 10:29 AM
74511/01/2022 10:39 AM
74611/01/2022 11:10 AM
74711/01/2022 11:12 AM
74811/01/2022 11:19 AM
74911/01/2022 12:42 PM
75011/01/2022 01:05 PM
75111/01/2022 01:06 PM
75211/01/2022 01:17 PM
75311/01/2022 01:32 PM
75411/01/2022 01:36 PM
75511/01/2022 01:44 PM
75611/01/2022 01:55 PM
75711/01/2022 02:13 PM
75811/01/2022 02:44 PM
75911/01/2022 03:41 PM
76011/01/2022 03:54 PM
76111/01/2022 04:50 PM
76211/01/2022 05:41 PM
76311/01/2022 06:08 PM
76411/01/2022 06:12 PM
76511/01/2022 06:56 PM
76611/01/2022 07:13 PM
76711/01/2022 07:35 PM
76811/01/2022 08:55 PM
76911/01/2022 09:02 PM
77011/01/2022 09:40 PM
77111/01/2022 11:04 PM
77211/01/2022 11:31 PM
77312/01/2022 03:20 AM
77412/01/2022 05:10 AM
77512/01/2022 07:31 AM
77612/01/2022 07:44 AM
77712/01/2022 09:47 AM
77812/01/2022 10:18 AM
77912/01/2022 10:25 AM
78012/01/2022 10:52 AM
78112/01/2022 11:12 AM
78212/01/2022 11:40 AM
78312/01/2022 12:19 PM
78412/01/2022 12:29 PM
78512/01/2022 01:30 PM
78612/01/2022 01:50 PM
78712/01/2022 02:04 PM
78812/01/2022 02:52 PM
78912/01/2022 03:16 PM
79012/01/2022 04:33 PM
79112/01/2022 04:55 PM
79212/01/2022 05:00 PM
79312/01/2022 05:37 PM
79412/01/2022 05:37 PM
79512/01/2022 07:44 PM
79612/01/2022 07:50 PM
79712/01/2022 08:08 PM
79812/01/2022 08:35 PM
79912/01/2022 08:38 PM
80012/01/2022 09:10 PM
80112/01/2022 09:28 PM
80212/01/2022 11:04 PM
80313/01/2022 08:08 AM
80413/01/2022 08:09 AM
80513/01/2022 08:14 AM
80613/01/2022 08:44 AM
80713/01/2022 09:30 AM
80813/01/2022 10:15 AM
80913/01/2022 10:18 AM
81013/01/2022 10:21 AM
81113/01/2022 11:29 AM
81213/01/2022 11:38 AM
81313/01/2022 11:45 AM
81413/01/2022 12:07 PM
81513/01/2022 12:26 PM
81613/01/2022 12:49 PM
81713/01/2022 12:55 PM
81813/01/2022 12:56 PM
81913/01/2022 12:59 PM
82013/01/2022 01:25 PM
82113/01/2022 01:32 PM
82213/01/2022 01:42 PM
82313/01/2022 02:23 PM
82413/01/2022 02:37 PM
82513/01/2022 03:06 PM
82613/01/2022 03:10 PM
82713/01/2022 03:53 PM
82813/01/2022 04:16 PM
82913/01/2022 04:27 PM
83013/01/2022 04:34 PM
83113/01/2022 04:53 PM
83213/01/2022 05:35 PM
83313/01/2022 07:31 PM
83413/01/2022 07:52 PM
83513/01/2022 08:51 PM
83613/01/2022 09:39 PM
83713/01/2022 09:58 PM
83813/01/2022 09:59 PM
83913/01/2022 10:28 PM
84013/01/2022 10:40 PM
84113/01/2022 10:52 PM
84214/01/2022 07:49 AM
84314/01/2022 08:00 AM
84414/01/2022 09:10 AM
84514/01/2022 09:13 AM
84614/01/2022 10:05 AM
84714/01/2022 10:38 AM
84814/01/2022 10:41 AM
84914/01/2022 10:57 AM
85014/01/2022 11:14 AM
85114/01/2022 11:15 AM
85214/01/2022 11:36 AM
85314/01/2022 11:37 AM
85414/01/2022 11:56 AM
85514/01/2022 11:56 AM
85614/01/2022 12:00 PM
85714/01/2022 12:13 PM
85814/01/2022 12:30 PM
85914/01/2022 12:33 PM
86014/01/2022 01:01 PM
86114/01/2022 01:30 PM
86214/01/2022 01:42 PM
86314/01/2022 02:01 PM
86414/01/2022 02:25 PM
86514/01/2022 02:31 PM
86614/01/2022 02:34 PM
86714/01/2022 02:34 PM
86814/01/2022 02:43 PM
86914/01/2022 02:57 PM
87014/01/2022 03:31 PM
87114/01/2022 03:32 PM
87214/01/2022 03:54 PM
87314/01/2022 04:09 PM
87414/01/2022 05:03 PM
87514/01/2022 06:12 PM
87614/01/2022 06:30 PM
87714/01/2022 07:01 PM
87814/01/2022 07:54 PM
87914/01/2022 07:59 PM
88014/01/2022 08:38 PM
88114/01/2022 09:12 PM
88214/01/2022 11:01 PM
88315/01/2022 01:36 AM
88415/01/2022 06:51 AM
88515/01/2022 09:40 AM
88615/01/2022 10:22 AM
88715/01/2022 10:45 AM
88815/01/2022 12:14 PM
88915/01/2022 12:23 PM
89015/01/2022 12:36 PM
89115/01/2022 01:00 PM
89215/01/2022 01:40 PM
89315/01/2022 01:50 PM
89415/01/2022 02:05 PM
89515/01/2022 02:32 PM
89615/01/2022 03:07 PM
89715/01/2022 03:36 PM
89815/01/2022 05:05 PM
89915/01/2022 05:28 PM
90015/01/2022 06:35 PM
90115/01/2022 07:01 PM
90215/01/2022 07:03 PM
90315/01/2022 09:02 PM
90415/01/2022 09:13 PM
90516/01/2022 12:41 AM
90616/01/2022 07:40 AM
90716/01/2022 07:51 AM
90816/01/2022 07:53 AM
90916/01/2022 09:37 AM
91016/01/2022 10:42 AM
91116/01/2022 11:14 AM
91216/01/2022 11:21 AM
91316/01/2022 11:51 AM
91416/01/2022 11:53 AM
91516/01/2022 01:05 PM
91616/01/2022 01:54 PM
91716/01/2022 02:06 PM
91816/01/2022 02:20 PM
91916/01/2022 02:52 PM
92016/01/2022 05:02 PM
92116/01/2022 05:55 PM
92216/01/2022 06:16 PM
92316/01/2022 07:18 PM
92416/01/2022 07:26 PM
92516/01/2022 07:42 PM
92616/01/2022 08:15 PM
92716/01/2022 09:16 PM
92816/01/2022 09:17 PM
92917/01/2022 12:00 AM
93017/01/2022 06:52 AM
93117/01/2022 07:11 AM
93217/01/2022 07:43 AM
93317/01/2022 07:45 AM
93417/01/2022 08:16 AM
93517/01/2022 09:33 AM
93617/01/2022 09:45 AM
93717/01/2022 10:04 AM
93817/01/2022 10:06 AM
93917/01/2022 10:34 AM
94017/01/2022 11:40 AM
94117/01/2022 11:58 AM
94217/01/2022 12:25 PM
94317/01/2022 12:32 PM
94417/01/2022 12:59 PM
94517/01/2022 02:03 PM
94617/01/2022 02:45 PM
94717/01/2022 02:46 PM
94817/01/2022 03:31 PM
94917/01/2022 04:11 PM
95017/01/2022 04:36 PM
95117/01/2022 06:02 PM
95217/01/2022 06:03 PM
95317/01/2022 06:03 PM
95417/01/2022 06:08 PM
95517/01/2022 08:09 PM
95617/01/2022 08:29 PM
95718/01/2022 12:17 AM
95818/01/2022 08:41 AM
95918/01/2022 09:30 AM
96018/01/2022 10:24 AM
96118/01/2022 11:03 AM
96218/01/2022 12:24 PM
96318/01/2022 01:44 PM
96418/01/2022 01:46 PM
96518/01/2022 01:48 PM
96618/01/2022 01:48 PM
96718/01/2022 01:50 PM
96818/01/2022 01:50 PM
96918/01/2022 02:00 PM
97018/01/2022 02:00 PM
97118/01/2022 02:05 PM
97218/01/2022 02:50 PM
97318/01/2022 03:18 PM
97418/01/2022 03:24 PM
97518/01/2022 03:35 PM
97618/01/2022 03:35 PM
97718/01/2022 03:36 PM
97818/01/2022 03:38 PM
97918/01/2022 03:39 PM
98018/01/2022 05:00 PM
98118/01/2022 05:02 PM
98218/01/2022 06:01 PM
98318/01/2022 06:23 PM
98418/01/2022 06:42 PM
98518/01/2022 07:32 PM
98618/01/2022 07:32 PM
98718/01/2022 07:52 PM
98818/01/2022 08:38 PM
98918/01/2022 10:41 PM
99018/01/2022 11:03 PM
99119/01/2022 05:54 AM
99219/01/2022 07:41 AM
99319/01/2022 08:10 AM
99419/01/2022 09:11 AM
99519/01/2022 10:10 AM
99619/01/2022 10:15 AM
997Total records in this page :995 Records
Ticket distribution by time
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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.
 
Upvote 0
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?
 
Upvote 0
too late to edit a link in previous post,sample file
tickets.xlsx
ABCDEF
1Created Timedaydatumxweeknrhalf hour
221/12/2021 0:031,00di 21/12/21xweek 5100:00
321/12/2021 7:111,00di 21/12/21xweek 5107:00
421/12/2021 7:391,00di 21/12/21xweek 5107:30
521/12/2021 8:241,00di 21/12/21xweek 5108:00
621/12/2021 8:461,00di 21/12/21xweek 5108:30
721/12/2021 9:171,00di 21/12/21xweek 5109:00
821/12/2021 9:341,00di 21/12/21xweek 5109:30
921/12/2021 9:471,00di 21/12/21xweek 5109:30
1021/12/2021 9:541,00di 21/12/21xweek 5109:30
Blad1
Cell Formulas
RangeFormula
B2:B10B2=TRUNC([@[Created Time]])-DATE(2021,12,20)
C2:C10C2=TRUNC([@[Created Time]])
D2:D10D2="x"
E2:E10E2="week " & ISOWEEKNUM([@[Created Time]])
F2:F10F2=TEXT(FLOOR.MATH(MOD([@[Created Time]],1),1/48),"uu:mm")
 
Upvote 0
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
ABCDEFGHIJK
1Created Time (Ticket)HourAverage Cases per hourShift Starting at this hour sees this many casesNext ShiftThird ShiftNormalizedMax Imbalance
212/21/2021 12:03 AM000.402.2318.6312.301.08.35.58.3
312/21/2021 7:11 AM710.203.1319.4310.601.06.23.46.2
412/21/2021 7:39 AM720.036.1018.009.071.03.01.53.0
512/21/2021 8:24 AM830.078.7717.506.901.32.51.02.5
612/21/2021 8:46 AM840.1011.0717.005.102.23.31.03.3
712/21/2021 9:17 AM950.1013.0316.303.833.44.31.04.3
812/21/2021 9:34 AM960.4015.3315.172.675.85.71.05.8
912/21/2021 9:47 AM970.9317.2013.972.008.67.01.08.6
1012/21/2021 9:54 AM981.3018.6312.302.238.35.51.08.3
1112/21/2021 10:01 AM1093.1719.4310.603.136.23.41.06.2
1212/21/2021 10:11 AM10102.7018.009.076.103.01.51.03.0
1312/21/2021 10:16 AM10112.3717.506.908.772.51.01.32.5
1412/21/2021 10:21 AM10122.0717.005.1011.073.31.02.23.3
1512/21/2021 10:41 AM10132.4016.303.8313.034.31.03.44.3
1612/21/2021 10:48 AM10142.2715.172.6715.335.71.05.85.8
1712/21/2021 11:25 AM11152.3713.972.0017.207.01.08.68.6
1812/21/2021 11:43 AM11162.1012.302.2318.635.51.08.38.3
1912/21/2021 12:23 PM12171.7310.603.1319.433.41.06.26.2
2012/21/2021 1:40 PM13182.209.076.1018.001.51.03.03.0
2112/21/2021 2:02 PM14191.876.908.7717.501.01.32.52.5
2212/21/2021 3:22 PM15201.375.1011.0717.001.02.23.33.3
2312/21/2021 3:38 PM15211.273.8313.0316.301.03.44.34.3
2412/21/2021 3:59 PM15221.072.6715.3315.171.05.85.75.8
2512/21/2021 4:07 PM16230.702.0017.2013.971.08.67.08.6
2612/21/2021 4:19 PM1600.402.2318.6312.301.08.35.58.3
2712/21/2021 4:58 PM1610.203.1319.43
2812/21/2021 4:59 PM1620.036.1018.00
2912/21/2021 5:00 PM1730.078.7717.50
3012/21/2021 6:14 PM1840.1011.0717.00
3112/21/2021 6:41 PM1850.1013.0316.30
3212/21/2021 6:57 PM1860.4015.3315.17
3312/21/2021 7:00 PM1970.9317.2013.97
3412/21/2021 7:07 PM1981.3018.6312.30
3512/21/2021 7:18 PM1993.1719.43
3612/21/2021 7:45 PM19102.7018.00
3712/21/2021 7:55 PM19112.3717.50
3812/21/2021 8:43 PM20122.0717.00
3912/21/2021 8:44 PM20132.4016.30
4012/21/2021 8:59 PM20142.2715.17
4112/21/2021 9:16 PM21152.3713.97
4212/21/2021 11:50 PM23162.1012.30
Sheet16
Cell Formulas
RangeFormula
C2:C49C2=MOD(SEQUENCE(48,1,0,1),24)
D2:D49D2=COUNTIF(B2:B997,C2#)/30
G2:G26G2=SUM(D18:D25)
H2:J26H2=E2/MIN($E2:$G2)
K2:K26K2=MAX(H2:J2)
F2:F34F2=SUM(D10:D17)
B2:B42B2=HOUR(A2)
E2:E42E2=SUM(D2:D9)
Dynamic array formulas.
 
Upvote 0
okay, i had another kind of tickets in my mind, i thought tickets sold, ....
 
Upvote 0
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...
 
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

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
Back
Top