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

Section 1 |  |  |  | Section 2 |  |  |  | Section 3
Start | Stop | Duration |  | Start spill range | Stop spill range | Duration spill range |  | Day 1 start | Day 1 stop | Duration day 1 | Day 1 stop | Day 2 stop | Duration day 2
2023-09-01 09:12:00 | 2023-09-01 17:04:00
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 | N/A | N/A | 0
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 | N/A | N/A | 0
2023-09-05 03:08:00 | 2023-09-05 20:03:00 |  |  | 2023-09-05 03:08:00 | 2023-09-05 20:03:00 | 16.91666666662786 |  | 2023-09-05 03:08:00 | 2023-09-05 20:03:00 | 16.91666666662786 | 2023-09-05 03:08:00 | 2023-09-05 20:03:00 | 16.91666666662786
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 | 2023-09-05 05:08:00 | 2023-09-05 21:03:00 | 15.91666666668607
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-05 22:49:00 | 2023-09-06 00:00:00 | 1.183333333348855
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
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
 |  |  |  |  | 2023-09-01 17:04:00 | 7.866666666639503 |  |  | 2023-09-01 17:04:00 | 7.866666666639503
 |  |  |  | 2023-09-03 21:44:00 | 2023-09-04 01:40:00 | 3.933333333407063 |  | 2023-09-03 21:44:00 | 2023-09-04 01:40:00 | 3.933333333407063 | N/A | N/A | 0
 |  |  |  | 2023-09-04 11:33:00 | 2023-09-05 02:00:00 | 14.45000000012806 |  | 2023-09-04 11:33:00 | 2023-09-05 02:00:00 | 14.45000000012806 | N/A | N/A | 0
 |  |  |  | 2023-09-05 03:08:00 | 2023-09-05 20:03:00 | 16.91666666662786 |  | 2023-09-05 03:08:00 | 2023-09-05 20:03:00 | 16.91666666662786 | 2023-09-05 03:08:00 | 2023-09-05 20:03:00 | 16.91666666662786
 |  |  |  | 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 | 2023-09-05 05:08:00 | 2023-09-05 21:03:00 | 15.91666666668607
Test start time | Test stop time | Duration |  | 2023-09-05 22:49:00 | 2023-09-06 10:08:00 | 11.31666666670935 |  | 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-05 00:00:00 | 2023-09-06 00:00: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 | 4.483333333453629 |  | 2023-09-08 15:02:00 | 2023-09-08 19:31:00 | 4.483333333453629 | N/A | N/A | 0
 |  |  |  | 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
[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