Spreadsheet: 876816d1723539643-powerquery-help-interval-wise-schedule-count-interval-wise-schedule
Sheet: Sheet1

Team | Location | Employee Name | Shift Plan |  |  |  |  | Half_Interval | CZ | DE
Team 1 | CZ | Employee01 | 07:00 - 16:00 |  |  |  |  | 0:00:00
Team 1 | CZ | Employee02 | 07:00 - 16:00 |  |  |  |  | 0:30:00
Team 1 | CZ | Employee03 | 07:00 - 16:00 |  |  |  |  | 1:00:00
Team 1 | CZ | Employee04 | 07:00 - 16:00 |  |  |  |  | 1:30:00
Team 1 | CZ | Employee05 | 07:00 - 16:00 |  |  |  |  | 2:00:00
Team 1 | CZ | Employee06 | 07:00 - 16:00 |  |  |  |  | 2:30:00
Team 1 | CZ | Employee07 | 07:00 - 16:00 |  |  |  |  | 3:00:00
Team 1 | CZ | Employee08 | 07:00 - 16:00 |  |  |  |  | 3:30:00
Team 2 | CZ | Employee09 | 07:00 - 16:00 |  |  |  |  | 4:00:00
Team 2 | CZ | Employee10 | 07:00 - 16:00 |  |  |  |  | 4:30:00
Team 2 | CZ | Employee11 | 07:00 - 16:00 |  |  |  |  | 5:00:00
Team 2 | CZ | Employee12 | 07:00 - 16:00 |  |  |  |  | 5:30:00
Team 2 | CZ | Employee13 | 07:00 - 16:00 |  |  |  |  | 6:00:00
Team 2 | CZ | Employee14 | 07:00 - 16:00 |  |  |  |  | 6:30:00
Team 2 | CZ | Employee15 | 07:00 - 16:00 |  |  |  |  | 7:00:00 | 15 | 27
Team 1 | CZ | Employee16 | 10:00 - 19:00 |  |  |  |  | 7:30:00 | 15 | 27
Team 2 | CZ | Employee17 | 10:00 - 19:00 |  |  |  |  | 8:00:00 | 15 | 33
Team 1 | DE | Employee01 | 07:00 - 16:00 |  |  |  |  | 8:30:00 | 15 | 33
Team 1 | DE | Employee02 | 07:00 - 16:00 |  |  |  |  | 9:00:00 | 15 | 33
Team 1 | DE | Employee03 | 07:00 - 16:00 |  |  |  |  | 9:30:00 | 15 | 33
Team 1 | DE | Employee04 | 07:00 - 16:00 |  |  |  |  | 10:00:00 | 17 | 36
Team 1 | DE | Employee05 | 07:00 - 16:00 |  |  |  |  | 10:30:00 | 17 | 36
Team 1 | DE | Employee06 | 07:00 - 16:00 |  |  |  |  | 11:00:00 | 17 | 36
Team 1 | DE | Employee07 | 07:00 - 16:00 |  |  |  |  | 11:30:00 | 17 | 36
Team 1 | DE | Employee08 | 07:00 - 16:00 |  |  |  |  | 12:00:00 | 17 | 36
Team 1 | DE | Employee09 | 07:00 - 16:00 |  |  |  |  | 12:30:00 | 17 | 36
Team 1 | DE | Employee10 | 07:00 - 16:00 |  |  |  |  | 13:00:00 | 17 | 36
Team 1 | DE | Employee11 | 07:00 - 16:00 |  |  |  |  | 13:30:00 | 17 | 36
Team 1 | DE | Employee12 | 07:00 - 16:00 |  |  |  |  | 14:00:00 | 17 | 36
Team 1 | DE | Employee13 | 07:00 - 16:00 |  |  |  |  | 14:30:00 | 17 | 36
Team 1 | DE | Employee14 | 07:00 - 16:00 |  |  |  |  | 15:00:00 | 17 | 36
Team 1 | DE | Employee15 | 07:00 - 16:00 |  |  |  |  | 15:30:00 | 17 | 36
Team 1 | DE | Employee16 | 07:00 - 16:00 |  |  |  |  | 16:00:00 | 17 | 36
Team 1 | DE | Employee17 | 07:00 - 16:00 |  |  |  |  | 16:30:00 | 17 | 36
Team 1 | DE | Employee18 | 07:00 - 16:00 |  |  |  |  | 17:00:00 | 17 | 36
Team 1 | DE | Employee19 | 07:00 - 16:00 |  |  |  |  | 17:30:00 | 17 | 36
Team 1 | DE | Employee20 | 07:00 - 16:00 |  |  |  |  | 18:00:00 | 17 | 36
Team 1 | DE | Employee21 | 07:00 - 16:00 |  |  |  |  | 18:30:00 | 17 | 36
Team 1 | DE | Employee22 | 07:00 - 16:00 |  |  |  |  | 19:00:00 | 17 | 36
Team 1 | DE | Employee23 | 07:00 - 16:00 |  |  |  |  | 19:30:00
Team 1 | DE | Employee24 | 07:00 - 16:00 |  |  |  |  | 20:00:00
Team 2 | DE | Employee25 | 07:00 - 16:00 |  |  |  |  | 20:30:00
Team 2 | DE | Employee26 | 07:00 - 16:00 |  |  |  |  | 21:00:00
Team 2 | DE | Employee27 | 07:00 - 16:00 |  |  |  |  | 21:30:00
Team 1 | DE | Employee28 | 08:00 - 17:00 |  |  |  |  | 22:00:00
Team 1 | DE | Employee29 | 08:00 - 17:00 |  |  |  |  | 22:30:00
Team 1 | DE | Employee30 | 08:00 - 17:00 |  |  |  |  | 23:00:00
Team 1 | DE | Employee31 | 08:00 - 17:00 |  |  |  |  | 23:30:00
Team 1 | DE | Employee32 | 08:00 - 17:00 |  |  |  |  | Grand Total
Team 1 | DE | Employee33 | 08:00 - 17:00
Team 1 | DE | Employee34 | 08:00 - 17:00
Team 1 | DE | Employee35 | 08:00 - 17:00
Team 1 | DE | Employee36 | 08:00 - 17:00
Team 1 | DE | [NAME] | 08:00 - 17:00
Team 1 | DE | Employee38 | 08:00 - 17:00
Team 1 | DE | Employee39 | 08:00 - 17:00
Team 1 | DE | Employee40 | 08:00 - 17:00
Team 2 | DE | Employee41 | 08:00 - 17:00
Team 2 | DE | Employee42 | 08:00 - 17:00
Team 2 | DE | Employee43 | 08:00 - 17:00
Team 1 | DE | Employee44 | 09:00 - 18:00
Team 1 | DE | Employee45 | 09:00 - 18:00
Team 1 | DE | Employee46 | 09:00 - 18:00
Team 1 | DE | Employee47 | 09:00 - 18:00
Team 2 | DE | Employee48 | 09:00 - 18:00
Team 2 | DE | Employee49 | 09:00 - 18:00
Team 2 | DE | Employee50 | 09:00 - 18:00
Team 1 | DE | Employee51 | 10:00 - 19:00
Team 1 | DE | [NAME] | 10:00 - 19:00
Team 2 | DE | Employee53 | 10:00 - 19:00