Spreadsheet: 856233d1705561399-sum-of-subintervals-without-counting-gaps-nor-double-counting-overlaps-time-overlaps-and-gaps
Sheet: Sheet1

Section 1 |  |  |  | Section 2 |  |  |  | Section 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum interval
Start | Stop | Duration |  | Start spill range | Stop spill range | Duration spill range |  | Day 1 start | Day 1 stop | Duration day 1 | Day 2 start | Day 2 stop | Duration day 2 |  |  | "Time": | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2023-09-01 09:12:00 | 2023-09-01 17:04:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A19 |  |  |  |  |  |  |  |  | B19
2023-09-03 21:44:00 | 2023-09-04 01:40:00 |  |  | 2023-09-03 21:44:00 | 2023-09-04 01:40:00 | 3.933333333407063 |  | 2023-09-03 21:44:00 | 2023-09-04 00:00:00 | 2.266666666720994 | 2023-09-04 00:00:00 | 2023-09-04 01:40:00 | 1.666666666686069 |  |  |  | Interval to be checked against
2023-09-04 11:33:00 | 2023-09-05 02:00:00 |  |  | 2023-09-04 11:33:00 | 2023-09-05 02:00:00 | 14.45000000012806 |  | 2023-09-04 11:33:00 | 2023-09-05 00:00:00 | 12.45000000006985 | 2023-09-05 00:00:00 | 2023-09-05 02:00:00 | 2.000000000058208
2023-09-05 05:08:00 | 2023-09-05 21:03:00 |  |  | 2023-09-05 05:08:00 | 2023-09-05 21:03:00 | 15.91666666668607 |  | 2023-09-05 05:08:00 | 2023-09-05 21:03:00 | 15.91666666668607 | N/A | N/A | 0 |  | Duration 1
2023-09-05 05:08:00 | 2023-09-05 21:03:00 |  |  | 2023-09-05 05:08:00 | 2023-09-05 21:03:00 | 15.91666666668607 |  | 2023-09-05 05:08:00 | 2023-09-05 21:03:00 | 15.91666666668607 | N/A | N/A | 0 |  |  |  |  |  |  |  |  |  |  |  | Duration 2
2023-09-05 22:49:00 | 2023-09-06 10:08:00 |  |  | 2023-09-05 22:49:00 | 2023-09-06 10:08:00 | 11.31666666670935 |  | 2023-09-05 22:49:00 | 2023-09-06 00:00:00 | 1.183333333348855 | 2023-09-06 00:00:00 | 2023-09-06 10:08:00 | 10.1333333333605 |  |  |  |  |  |  | Duration 3
2023-09-06 20:10:00 | 2023-09-06 21:22:00 |  |  | 2023-09-06 20:10:00 | 2023-09-06 21:22:00 | 1.199999999895226 |  | 2023-09-06 20:10:00 | 2023-09-06 21:22:00 | 1.199999999895226 | N/A | N/A | 0
2023-09-08 15:02:00 | 2023-09-08 19:31:00 |  |  | 2023-09-08 15:02:00 | 2023-09-08 19:31:00 | 4.483333333453629 |  | 2023-09-08 15:02:00 | 2023-09-08 19:31:00 | 4.483333333453629 | N/A | N/A | 0 |  |  |  |  | Duration 4
2023-09-09 08:55:00 | 2023-09-09 23:27:00 |  |  | 2023-09-09 08:55:00 | 2023-09-09 23:27:00 | 14.53333333320916 |  | 2023-09-09 08:55:00 | 2023-09-09 23:27:00 | 14.53333333320916 | N/A | N/A | 0
Test start time | Test stop time | Duration
2023-09-05 00:00:00 | 2023-09-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time included |  |  |  |  |  |  |  | Time included |  | Sum subintervals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time included: | 1 | 1 | 1 | 1 | 1 |  |  |  | 1 | 1
[NAME] for calculating time that fits between test start time (A17) and test stop time (B17): |  |  |  |  |  |  |  | This setup/formula sums the duration of each Section of each phase that fits. It works as long as there are no overlapping time in Section 3, and as long as the original durations in Section 1 / 2 does not last more than two days.
[NAME] for calculating time that fits between test start time (A17) and test stop time (B17): |  |  |  |  |  |  |  | This formula finds the duration between the latest and earliest times that fit within the test duration. It works as long as there are no time overlaps or time gaps in Section 2.
[NAME] needed for calculating the amount of duration from Section 2 that falls between the test start time (A17) and test stop time (B17), without counting time gaps and without double counting time overlaps: |  |  |  |  |  |  | 19.10000000009313