Spreadsheet: 726360d1617190668-sumproduct-adding-date-to-time-range-only-works-for-same-date-calculate-intermediate-task-dates-and-times-with-breaks-continued_02_mlan
Sheet: Production scedule

start date | run time |  |  | working week | [NAME] | fri
2021-02-01 14:00:00 |  | = 11 modules in 74 working hours |  | start work | 06:30:00 | 06:30:00 | start break | break time
 | using sumproduct | using sumifs |  | morning break start | 09:00:00 | 09:00:00 | 09:00:00 | 20
due date before breaks | counting breaks [min] | counting breaks [min] |  | morning break end | 09:20:00 | 09:20:00 | 12:00:00 | 25
 |  |  |  | lunch break start | 12:00:00
 |  |  |  | lunch break end | 12:25:00
 |  |  |  | end work | 15:15:00 | 11:50:00
 |  |  |  | Manually created scedule with correct due dates and times
 |  |  |  | mandag | tirsdag | onsdag | torsdag | fredag |  |  | mandag | tirsdag | onsdag | torsdag | fredag
 |  |  |  | 2021-02-01 06:30:00 | 2021-02-02 06:30:00 | 2021-02-03 06:30:00 | 2021-02-04 06:30:00 | 2021-02-05 06:30:00 |  |  | 2021-02-08 06:30:00 | 2021-02-09 06:30:00 | 2021-02-10 06:30:00 | 2021-02-11 06:30:00 | 2021-02-12 06:30:00
 |  |  |  | 2021-02-01 09:00:00 | 2021-02-02 09:00:00 | 2021-02-03 09:00:00 | 2021-02-04 09:00:00 | 2021-02-05 09:00:00 |  |  | 2021-02-08 09:00:00 | 2021-02-09 09:00:00 | 2021-02-10 09:00:00 | 2021-02-11 09:00:00 | 2021-02-12 09:00:00
 |  |  |  | 2021-02-01 09:20:00 | 2021-02-02 09:20:00 | 2021-02-03 09:20:00 | 2021-02-04 09:20:00 | 2021-02-05 09:20:00 |  |  | 2021-02-08 09:20:00 | 2021-02-09 09:20:00 | 2021-02-10 09:20:00 | 2021-02-11 09:20:00 | 2021-02-12 09:20:00
 |  |  |  | 2021-02-01 12:00:00 | 2021-02-02 12:00:00 | 2021-02-03 12:00:00 | 2021-02-04 12:00:00 |  |  |  | 2021-02-08 12:00:00 | 2021-02-09 12:00:00 | 2021-02-10 12:00:00 | 2021-02-11 12:00:00
 |  |  |  | 2021-02-01 12:25:00 | 2021-02-02 12:24:59.995000 | 2021-02-03 12:24:59.995000 | 2021-02-04 12:24:59.995000 |  |  |  | 2021-02-08 12:24:59.995000 | 2021-02-09 12:24:59.995000 | 2021-02-10 12:24:59.995000 | 2021-02-11 12:24:59.995000
 |  |  |  | 2021-02-01 15:15:00 | 2021-02-02 15:15:00 | 2021-02-03 15:15:00 | 2021-02-04 15:15:00 | 2021-02-05 11:50:00 |  |  | 2021-02-08 15:14:59.995000 | 2021-02-09 15:14:59.995000 | 2021-02-10 15:14:59.995000 | 2021-02-11 15:15:00 | 2021-02-12 11:50:00
 | expected results
due date incl. Breaks  using sumproduct | break minutes | expected due date |  | [NAME] and Times | Friday without breaks | Friday breaks (preliminary) | Mon - Thu without breaks | Mon - Thu breaks (prelim) | If Friday >11:50 | "New" Friday breaks (preliminary) | Prelim Due Date | If Friday >11:50 | "New" Friday Final breaks | Final Breaks | Final Due Date | Final Due Date  If Friday >11:50 |  | Total Time | Total Breaks and Time Between | Time Worked
 | 45 |  | 1 | 2021-02-01 10:30:00
 | 45 |  | 2
 | 20 |  | 3
 | 45 |  | 4
 | 25 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] should be 00:00
 | 40 |  | 6
 | 25 |  | 7
 | 45 |  | 8
 | 45 |  | 9
 | 45 |  | 10
 | 20 |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  | 27
 |  |  | 28
 |  |  | 29
 |  |  | 30
 |  |  | 31
 |  |  | 32
 |  |  | 33
 |  |  | 34