Hello,
I was wondering if there is a way I can get the total of each hour interval based on the date and time.
So example, the sum of scheduled between 00:00-01:00 but making it date dependant.
I've attached example data and how it needs to be formatted after.
I was wondering if there is a way I can get the total of each hour interval based on the date and time.
So example, the sum of scheduled between 00:00-01:00 but making it date dependant.
I've attached example data and how it needs to be formatted after.
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Date | Interval | Scheduled | ||
2 | 05/07/2021 | 00:00 | 28 | ||
3 | 05/07/2021 | 00:15 | 25 | ||
4 | 05/07/2021 | 00:30 | 19 | ||
5 | 05/07/2021 | 00:45 | 18 | ||
6 | 05/07/2021 | 01:00 | 19 | ||
7 | 05/07/2021 | 01:15 | 18 | ||
8 | 05/07/2021 | 01:30 | 24 | ||
9 | 05/07/2021 | 01:45 | 31 | ||
10 | 05/07/2021 | 02:00 | 58 | ||
11 | 05/07/2021 | 02:15 | 87 | ||
12 | 05/07/2021 | 02:30 | 102 | ||
13 | 05/07/2021 | 02:45 | 99 | ||
14 | 05/07/2021 | 03:00 | 104 | ||
15 | 05/07/2021 | 03:15 | 107 | ||
16 | 05/07/2021 | 03:30 | 107 | ||
17 | 05/07/2021 | 03:45 | 108 | ||
18 | 05/07/2021 | 04:00 | 111 | ||
19 | 05/07/2021 | 04:15 | 102 | ||
20 | 05/07/2021 | 04:30 | 93 | ||
21 | 05/07/2021 | 04:45 | 75 | ||
22 | 05/07/2021 | 05:00 | 72 | ||
23 | 05/07/2021 | 05:15 | 60 | ||
24 | 05/07/2021 | 05:30 | 43 | ||
25 | 05/07/2021 | 05:45 | 37 | ||
26 | 05/07/2021 | 06:00 | 28 | ||
27 | 05/07/2021 | 06:15 | 23 | ||
28 | 05/07/2021 | 06:30 | 19 | ||
29 | 05/07/2021 | 06:45 | 18 | ||
30 | 05/07/2021 | 07:00 | 18 | ||
31 | 05/07/2021 | 07:15 | 16 | ||
32 | 05/07/2021 | 07:30 | 19 | ||
33 | 05/07/2021 | 07:45 | 31 | ||
34 | 05/07/2021 | 08:00 | 62 | ||
35 | 05/07/2021 | 08:15 | 97 | ||
36 | 05/07/2021 | 08:30 | 107 | ||
37 | 05/07/2021 | 08:45 | 107 | ||
38 | 05/07/2021 | 09:00 | 104 | ||
Sheet1 |
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Date | Interval | Scheduled | ||
2 | 05/07/2021 | 0000 | |||
3 | 05/07/2021 | 0100 | |||
4 | 05/07/2021 | 0200 | |||
5 | 05/07/2021 | 0300 | |||
6 | 05/07/2021 | 0400 | |||
7 | 05/07/2021 | 0500 | |||
8 | 05/07/2021 | 0600 | |||
9 | 05/07/2021 | 0700 | |||
10 | 05/07/2021 | 0800 | |||
Sheet2 |