Spreadsheet: 876836d1723551660-powerquery-help-interval-wise-schedule-count-interval-wise-schedule_ck
Sheet: Sheet1

Team | Location | Employee Name | Shift Plan |  |  |  |  | Half_Interval | CZ | DE |  |  | Half_Interval | CZ | DE
Team 1 | CZ | Employee01 | 07:00 - 16:00 |  |  |  |  | 0:00:00 |  |  |  |  | 00:00:00
Team 1 | CZ | Employee02 | 07:00 - 16:00 |  |  |  |  | 0:30:00 |  |  |  |  | 00:30:00
Team 1 | CZ | Employee03 | 07:00 - 16:00 |  |  |  |  | 1:00:00 |  |  |  |  | 01:00:00
Team 1 | CZ | Employee04 | 07:00 - 16:00 |  |  |  |  | 1:30:00 |  |  |  |  | 01:30:00
Team 1 | CZ | Employee05 | 07:00 - 16:00 |  |  |  |  | 2:00:00 |  |  |  |  | 02:00:00
Team 1 | CZ | Employee06 | 07:00 - 16:00 |  |  |  |  | 2:30:00 |  |  |  |  | 02:30:00
Team 1 | CZ | Employee07 | 07:00 - 16:00 |  |  |  |  | 3:00:00 |  |  |  |  | 03:00:00
Team 1 | CZ | Employee08 | 07:00 - 16:00 |  |  |  |  | 3:30:00 |  |  |  |  | 03:30:00
Team 2 | CZ | Employee09 | 07:00 - 16:00 |  |  |  |  | 4:00:00 |  |  |  |  | 04:00:00
Team 2 | CZ | Employee10 | 07:00 - 16:00 |  |  |  |  | 4:30:00 |  |  |  |  | 04:30:00
Team 2 | CZ | Employee11 | 07:00 - 16:00 |  |  |  |  | 5:00:00 |  |  |  |  | 05:00:00
Team 2 | CZ | Employee12 | 07:00 - 16:00 |  |  |  |  | 5:30:00 |  |  |  |  | 05:30:00
Team 2 | CZ | Employee13 | 07:00 - 16:00 |  |  |  |  | 6:00:00 |  |  |  |  | 06:00:00
Team 2 | CZ | Employee14 | 07:00 - 16:00 |  |  |  |  | 6:30:00 |  |  |  |  | 06:30:00
Team 2 | CZ | Employee15 | 07:00 - 16:00 |  |  |  |  | 7:00:00 | 15 | 27 |  |  | 07:00:00 | 15 | 27
Team 1 | CZ | Employee16 | 10:00 - 19:00 |  |  |  |  | 7:30:00 | 15 | 27 |  |  | 07:30:00 | 15 | 27
Team 2 | CZ | Employee17 | 10:00 - 19:00 |  |  |  |  | 8:00:00 | 15 | 33 |  |  | 08:00:00 | 15 | 43
Team 1 | DE | Employee01 | 07:00 - 16:00 |  |  |  |  | 8:30:00 | 15 | 33 |  |  | 08:30:00 | 15 | 43
Team 1 | DE | Employee02 | 07:00 - 16:00 |  |  |  |  | 9:00:00 | 15 | 33 |  |  | 09:00:00 | 15 | 50
Team 1 | DE | Employee03 | 07:00 - 16:00 |  |  |  |  | 9:30:00 | 15 | 33 |  |  | 09:30:00 | 15 | 50
Team 1 | DE | Employee04 | 07:00 - 16:00 |  |  |  |  | 10:00:00 | 17 | 36 |  |  | 10:00:00 | 17 | 53
Team 1 | DE | Employee05 | 07:00 - 16:00 |  |  |  |  | 10:30:00 | 17 | 36 |  |  | 10:30:00 | 17 | 53
Team 1 | DE | Employee06 | 07:00 - 16:00 |  |  |  |  | 11:00:00 | 17 | 36 |  |  | 11:00:00 | 17 | 53
Team 1 | DE | Employee07 | 07:00 - 16:00 |  |  |  |  | 11:30:00 | 17 | 36 |  |  | 11:30:00 | 17 | 53
Team 1 | DE | Employee08 | 07:00 - 16:00 |  |  |  |  | 12:00:00 | 17 | 36 |  |  | 12:00:00 | 17 | 53
Team 1 | DE | Employee09 | 07:00 - 16:00 |  |  |  |  | 12:30:00 | 17 | 36 |  |  | 12:30:00 | 17 | 53
Team 1 | DE | Employee10 | 07:00 - 16:00 |  |  |  |  | 13:00:00 | 17 | 36 |  |  | 13:00:00 | 17 | 53
Team 1 | DE | Employee11 | 07:00 - 16:00 |  |  |  |  | 13:30:00 | 17 | 36 |  |  | 13:30:00 | 17 | 53
Team 1 | DE | Employee12 | 07:00 - 16:00 |  |  |  |  | 14:00:00 | 17 | 36 |  |  | 14:00:00 | 17 | 53
Team 1 | DE | Employee13 | 07:00 - 16:00 |  |  |  |  | 14:30:00 | 17 | 36 |  |  | 14:30:00 | 17 | 53
Team 1 | DE | Employee14 | 07:00 - 16:00 |  |  |  |  | 15:00:00 | 17 | 36 |  |  | 15:00:00 | 17 | 53
Team 1 | DE | Employee15 | 07:00 - 16:00 |  |  |  |  | 15:30:00 | 17 | 36 |  |  | 15:30:00 | 17 | 53
Team 1 | DE | Employee16 | 07:00 - 16:00 |  |  |  |  | 16:00:00 | 17 | 36 |  |  | 16:00:00 | 2 | 26
Team 1 | DE | Employee17 | 07:00 - 16:00 |  |  |  |  | 16:30:00 | 17 | 36 |  |  | 16:30:00 | 2 | 26
Team 1 | DE | Employee18 | 07:00 - 16:00 |  |  |  |  | 17:00:00 | 17 | 36 |  |  | 17:00:00 | 2 | 10
Team 1 | DE | Employee19 | 07:00 - 16:00 |  |  |  |  | 17:30:00 | 17 | 36 |  |  | 17:30:00 | 2 | 10
Team 1 | DE | Employee20 | 07:00 - 16:00 |  |  |  |  | 18:00:00 | 17 | 36 |  |  | 18:00:00 | 2 | 3
Team 1 | DE | Employee21 | 07:00 - 16:00 |  |  |  |  | 18:30:00 | 17 | 36 |  |  | 18:30:00 | 2 | 3
Team 1 | DE | Employee22 | 07:00 - 16:00 |  |  |  |  | 19:00:00 | 17 | 36 |  |  | 19:00:00
Team 1 | DE | Employee23 | 07:00 - 16:00 |  |  |  |  | 19:30:00 |  |  |  |  | 19:30:00
Team 1 | DE | Employee24 | 07:00 - 16:00 |  |  |  |  | 20:00:00 |  |  |  |  | 20:00:00
Team 2 | DE | Employee25 | 07:00 - 16:00 |  |  |  |  | 20:30:00 |  |  |  |  | 20:30:00
Team 2 | DE | Employee26 | 07:00 - 16:00 |  |  |  |  | 21:00:00 |  |  |  |  | 21:00:00
Team 2 | DE | Employee27 | 07:00 - 16:00 |  |  |  |  | 21:30:00 |  |  |  |  | 21:30:00
Team 1 | DE | Employee28 | 08:00 - 17:00 |  |  |  |  | 22:00:00 |  |  |  |  | 22:00:00
Team 1 | DE | Employee29 | 08:00 - 17:00 |  |  |  |  | 22:30:00 |  |  |  |  | 22:30:00
Team 1 | DE | Employee30 | 08:00 - 17:00 |  |  |  |  | 23:00:00 |  |  |  |  | 23:00:00
Team 1 | DE | Employee31 | 08:00 - 17:00 |  |  |  |  | 23:30:00 |  |  |  |  | 23:30:00
Team 1 | DE | Employee32 | 08:00 - 17:00 |  |  |  |  | Grand Total |  |  |  |  | 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