Spreadsheet: 758789d1639065869-averaging-entries-per-day-by-date-excel_example
Sheet: Sheet1

ID | Start time | Completion time | Call Number
43 | 2021-12-06 09:00:03 | 2021-12-06 09:17:47 | 904
44 | 2021-12-06 06:05:43 | 2021-12-06 10:37:33 | 935
45 | 2021-12-06 09:39:49 | 2021-12-06 12:11:45 | 914
46 | 2021-12-06 12:14:06 | 2021-12-06 12:15:18 | 947
47 | 2021-12-06 12:15:22 | 2021-12-06 12:15:58 | 947 |  |  |  | Samba's formula works here perfectly!
48 | 2021-12-06 12:22:30 | 2021-12-06 12:23:18 | 904 |  |  |  |  |  |  |  |  |  |  |  | entries on 12-6 | 15
49 | 2021-12-06 10:37:38 | 2021-12-06 14:14:43 | 935 |  |  |  | But not if I expand the range, it does this > |  |  |  |  |  |  |  | entries on 12-7 | 17
50 | 2021-12-06 14:14:53 | 2021-12-06 15:33:54 | 935 |  |  |  |  |  |  |  |  |  |  |  | entries on 12-8 | 4
51 | 2021-12-06 15:39:35 | 2021-12-06 15:40:27 | 904
52 | 2021-12-06 15:56:19 | 2021-12-06 15:58:58 | 752 |  |  |  |  |  |  |  |  |  |  |  | daily average entries | 12
53 | 2021-12-06 15:59:01 | 2021-12-06 15:59:37 | 752 |  |  |  | This formula seems to be working here
54 | 2021-12-06 15:59:39 | 2021-12-06 16:00:17 | 752
55 | 2021-12-06 16:09:10 | 2021-12-06 16:10:08 | 947 |  |  |  | But it did give me a bit of a differnet answer |  |  |  |  |  |  |  | entries for 904 on 12-6 | 3
56 | 2021-12-06 16:43:24 | 2021-12-06 16:44:02 | 947 |  |  |  | once the range was expanded. |  |  |  |  |  |  |  | entires for 904 on 12-7 | 6
57 | 2021-12-06 15:34:02 | 2021-12-06 16:59:08 | 935 |  |  |  |  |  |  |  |  |  |  |  | entires for 904 on 12-8 | 0
59 | 2021-12-07 08:37:27 | 2021-12-07 08:38:40 | 940
60 | 2021-12-07 10:12:46 | 2021-12-07 10:13:27 | 914 |  |  |  |  |  |  |  |  |  |  |  | daily average for 904 | 3
61 | 2021-12-07 11:01:50 | 2021-12-07 11:02:41 | 947
62 | 2021-12-07 11:02:46 | 2021-12-07 11:04:19 | 947
63 | 2021-12-07 11:28:43 | 2021-12-07 11:29:14 | 904
64 | 2021-12-07 11:29:18 | 2021-12-07 11:29:48 | 904
65 | 2021-12-07 11:29:50 | 2021-12-07 11:30:42 | 904
66 | 2021-12-07 11:31:06 | 2021-12-07 11:31:44 | 904
67 | 2021-12-07 11:31:54 | 2021-12-07 11:32:48 | 904
68 | 2021-12-07 11:59:12 | 2021-12-07 11:59:45 | 914
69 | 2021-12-07 07:02:32 | 2021-12-07 12:05:47 | 935
70 | 2021-12-07 15:24:06 | 2021-12-07 15:25:35 | 935
71 | 2021-12-07 15:44:09 | 2021-12-07 15:44:50 | 904
72 | 2021-12-07 15:54:22 | 2021-12-07 15:55:04 | 914
74 | 2021-12-07 15:26:41 | 2021-12-07 17:33:44 | 935
75 | 2021-12-07 22:38:13 | 2021-12-07 22:40:32 | 947
76 | 2021-12-07 22:40:36 | 2021-12-07 22:41:09 | 947
77 | 2021-12-08 05:57:16 | 2021-12-08 05:57:49 | 911
78 | 2021-12-08 05:57:58 | 2021-12-08 05:58:29 | 911
79 | 2021-12-08 05:58:30 | 2021-12-08 05:58:46 | 911
80 | 2021-12-08 05:58:48 | 2021-12-08 05:59:04 | 911
81 | 2021-12-08 05:59:06 | 2021-12-08 05:59:22 | 911
82 | 2021-12-08 05:59:24 | 2021-12-08 05:59:43 | 911
83 | 2021-12-08 10:20:00 | 2021-12-08 10:20:38 | 904
84 | 2021-12-08 10:48:52 | 2021-12-08 10:49:37 | 947
85 | 2021-12-08 10:49:40 | 2021-12-08 10:50:28 | 947
86 | 2021-12-08 11:03:26 | 2021-12-08 11:04:36 | 911
87 | 2021-12-08 11:27:48 | 2021-12-08 11:28:38 | 914
88 | 2021-12-08 11:28:40 | 2021-12-08 11:29:36 | 914
89 | 2021-12-08 09:10:51 | 2021-12-08 11:47:22 | 935
90 | 2021-12-08 11:47:54 | 2021-12-08 11:48:42 | 947
91 | 2021-12-08 12:30:39 | 2021-12-08 13:24:07 | 911
92 | 2021-12-08 14:10:32 | 2021-12-08 14:11:09 | 935
93 | 2021-12-08 14:44:03 | 2021-12-08 14:44:32 | 914
94 | 2021-12-08 15:15:05 | 2021-12-08 15:17:40 | 302
95 | 2021-12-08 15:17:48 | 2021-12-08 15:18:57 | 302
96 | 2021-12-08 15:18:59 | 2021-12-08 15:19:56 | 302
97 | 2021-12-08 15:19:59 | 2021-12-08 15:21:08 | 302
98 | 2021-12-08 15:21:10 | 2021-12-08 15:21:43 | 302
99 | 2021-12-08 15:21:45 | 2021-12-08 15:22:10 | 302
100 | 2021-12-08 15:22:11 | 2021-12-08 15:22:37 | 302
101 | 2021-12-08 15:46:49 | 2021-12-08 15:47:25 | 904
102 | 2021-12-08 16:08:04 | 2021-12-08 16:08:49 | 935
103 | 2021-12-08 17:08:59 | 2021-12-08 17:09:05 | 911
104 | 2021-12-08 20:07:37 | 2021-12-08 20:10:53 | 380