For light weight I would propose a column of Start interval index numbers and a column of End interval index numbers as in columns C:D here. I used the Fill Series feature.
|
C |
D |
E |
F |
G |
1 |
Start Index |
End Index |
15 min time stamps |
sum 15 min intervals |
average 15 min intervals |
2 |
1 |
900 |
24/03/2020 23:00:00 |
13324.7 |
14.80522222 |
3 |
901 |
1800 |
24/03/2020 22:45:00 |
13416.6 |
14.90733333 |
4 |
1801 |
2700 |
24/03/2020 22:30:00 |
13401.3 |
14.89033333 |
5 |
2701 |
3600 |
24/03/2020 22:15:00 |
13375.7 |
14.86188889 |
6 |
3601 |
4500 |
24/03/2020 22:00:00 |
13352.2 |
14.83577778 |
7 |
4501 |
5400 |
24/03/2020 21:45:00 |
13487.3 |
14.98588889 |
8 |
5401 |
6300 |
24/03/2020 21:30:00 |
13444.8 |
14.93866667 |
9 |
6301 |
7200 |
24/03/2020 21:15:00 |
13426.8 |
14.91866667 |
10 |
7201 |
8100 |
24/03/2020 21:00:00 |
13439.8 |
14.93311111 |
11 |
8101 |
9000 |
24/03/2020 20:45:00 |
13404.6 |
14.894 |
12 |
9001 |
9900 |
24/03/2020 20:30:00 |
13490 |
14.98888889 |
13 |
9901 |
10800 |
24/03/2020 20:15:00 |
13338 |
14.82 |
14 |
10801 |
11700 |
24/03/2020 20:00:00 |
13348.5 |
14.83166667 |
15 |
11701 |
12600 |
24/03/2020 19:45:00 |
13361 |
14.84555556 |
16 |
12601 |
13500 |
24/03/2020 19:30:00 |
13360.7 |
14.84522222 |
17 |
13501 |
14400 |
24/03/2020 19:15:00 |
13354.8 |
14.83866667 |
18 |
14401 |
15300 |
24/03/2020 19:00:00 |
13437.2 |
14.93022222 |
19 |
15301 |
16200 |
24/03/2020 18:45:00 |
13432 |
14.92444444 |
Then define the target 15 minute sum and average (?) ranges like this: In F2 and filled down.In G2 and filled down.
Edit I forgot the 15 minute interval date/time stamps. In E2 and filled down
Bookmarks