| Start Time | Stop Time | Volume |
| 2024/08/02 06:00 | 2024/08/02 22:00 | 400 |
| 2024/08/03 06:00 | 2024/08/03 22:00 | 397 |
| 2024/08/08 00:00 | 2024/08/08 23:00 | 575 |
| 2024/08/08 23:00 | 2024/08/09 00:00 | 25 |
| 2024/08/09 00:00 | 2024/08/10 23:00 | 775 |
| 2024/08/10 23:00 | 2024/08/11 00:00 | 25 |
| 2024/08/20 00:00 | 2024/08/20 23:00 | 255 |
| 2024/08/20 06:00 | 2024/08/20 22:00 | 160 |
| 2024/08/20 23:00 | 2024/08/21 00:00 | 25 |
| 2024/08/21 00:00 | 2024/08/21 23:00 | 250 |
| 2024/08/21 06:00 | 2024/08/21 22:00 | 220 |
| 2024/08/21 07:00 | 2024/08/21 14:00 | 105 |
| 2024/08/21 23:00 | 2024/08/22 00:00 | 25 |
| 2024/08/22 00:00 | 2024/08/22 23:00 | 535 |
| 2024/08/22 13:00 | 2024/08/22 17:00 | 40 |
| 2024/08/22 23:00 | 2024/08/23 00:00 | 25 |
| 2024/08/23 00:00 | 2024/08/24 23:00 | 640 |
| 2024/08/23 14:00 | 2024/08/24 19:00 | 205 |
| 2024/08/24 23:00 | 2024/08/25 00:00 | 30 |
| 2024/08/25 00:00 | 2024/08/26 23:00 | 950 |
| 2024/08/25 13:00 | 2024/08/25 19:00 | 150 |
| 2024/08/26 23:00 | 2024/08/27 00:00 | 40 |
I am trying to combine the volumes based on if their times were ever going at the same time. Currently I am subtracting one day from all of the Stop times that contain "00:00" and then grouping on that new date and then summing everything together. This works for all of them except the bottom three rows (950, 150, and 40) where it will combine the 950 and 40 because they would have a stop time of 2024/08/26 but I can't get it to coming the 150.
Any thoughts on how to accomplish this or if it is possible would be appreciated.
