Spreadsheet: 61557d1262456343-calculate-working-shifts-per-day-from-monthly-report-712347_zbor-1-
Sheet: Sheet2

 |  | Person A |  |  |  | Person B
Date | Day | Work time |  |  |  | Work time
2009-11-30 00:00:00 | Workday | [NAME] | 20-08 | 2a6n2d |  | [NAME]
2009-12-01 00:00:00 | Workday | free_00 | 0 | 0 | 6+2 | day_shift_12
2009-12-02 00:00:00 | Workday | free_00 | 0 | 0 | 0 | [NAME]
2009-12-03 00:00:00 | Workday | free_00 | 0 | 0 | 0 | [NAME]
2009-12-04 00:00:00 | Workday | day_shift_12 | 08-20 | 4a8d0n | 12 | [NAME]
2009-12-05 00:00:00 | Workday | [NAME] | 20-08 | 2a6n2d | 2+2 | free_00
2009-12-06 00:00:00 | Sunday | free_00 | 0 | 0 | 8 | free_00
2009-12-07 00:00:00 | Workday | free_00 | 0 | 0 | 0 | free_00
2009-12-08 00:00:00 | Workday | vacation_08 | ? | 0a8d0n | 8 | day_shift_12
2009-12-09 00:00:00 | Workday | vacation_08 | ? | 0a8d0n | 8 | [NAME] |  |  |  | start time | end time | new | new2
2009-12-10 00:00:00 | Workday | vacation_08 | ? | 0a8d0n | 8 | free_00 |  |  | [NAME] | 20:00:00 | 08:00:00 | 20-08 | 2a6n2d
2009-12-11 00:00:00 | Workday | vacation_08 | ? | 0a8d0n | 8 | free_00 |  |  | day_shift_12 | 08:00:00 | 20:00:00 | 08-20 | 4a8d0n
2009-12-12 00:00:00 | Workday | free_00 | 0 | 0 | 0 | day_shift_12 |  |  | free_00 |  |  | 0 | 0
2009-12-13 00:00:00 | Sunday | free_00 | 0 | 0 | 0 | [NAME] |  |  | vacation_08 | 06:00:00 | 14:00:00 | ? | 0a8d0n
2009-12-14 00:00:00 | Workday | vacation_08 | ? | 0a8d0n | 8 | free_00 |  |  | [NAME] | 08:00:00 | 16:00:00 | 08-16 | 0a8d0n
2009-12-15 00:00:00 | Workday | vacation_08 | ? | 0a8d0n | 8 | free_00 |  |  | afternoon_08 | 13:00:00 | 21:00:00 | 13-21 | 4a4d
2009-12-16 00:00:00 | Workday | vacation_08 | ? | 0a8d0n | 8 | day_shift_12
2009-12-17 00:00:00 | Workday | vacation_08 | ? | 0a8d0n | 8 | [NAME]
2009-12-18 00:00:00 | Workday | free_00 | 0 | 0 | 0 | free_00 |  |  |  | 06:00:00 | 16:00:00 | 22:00:00 | Hollyday | Sunday
2009-12-19 00:00:00 | Workday | free_00 | 0 | 0 | 0 | free_00 |  |  |  | 1 | 1.2 | 1.5 | 1.5 | 1.2
2009-12-20 00:00:00 | Sunday | day_shift_12 | 08-20 | 4a8d0n | 12 | free_00
2009-12-21 00:00:00 | Workday | [NAME] | 20-08 | 2a6n2d | 2+2 | free_00
2009-12-22 00:00:00 | Workday | free_00 | 0 | 0 | 6+2 | day_shift_12 |  |  | So….. Night shift on regular day:
2009-12-23 00:00:00 | Workday | free_00 | 0 | 0 | 0 | [NAME] |  |  | start time | 20:00:00 | end time | 08:00:00
2009-12-24 00:00:00 | Workday | [NAME] | 08-16 | 0a8d0n | 8 | [NAME]
2009-12-25 00:00:00 | Holliday | [NAME] | 20-08 | 2a6n2d | 4 | free_00 |  |  |  | 20:00-22:00 | 22:00-6:00 | 6:00-8:00
2009-12-26 00:00:00 | Holliday | free_00 | 0 | 0 | 6+2 | free_00 |  |  |  | 1.2 | 1.5 | 1
2009-12-27 00:00:00 | Sunday | free_00 | 0 | 0 | 0 | free_00
2009-12-28 00:00:00 | Workday | day_shift_12 | 08-20 | 4a8d0n | 12 | [NAME] |  |  | So….. Night shift when hollyday or sunday is day after:
2009-12-29 00:00:00 | Workday | [NAME] | 20-08 | 2a6n2d | 2+2 | [NAME] |  |  | start time | 20:00:00 | end time | 08:00:00
2009-12-30 00:00:00 | Workday | free_00 | 0 | 0 | 6+2 | [NAME]
2009-12-31 00:00:00 | Workday | [NAME] | 20-08 | 2a6n2d | 2+2 | [NAME] |  |  |  | 20:00-22:00 | 22:00-24:00 | 0:00-8:00
2010-01-01 00:00:00 | Holliday | [NAME] | 08-16 | 0a8d0n | 8+8 | [NAME] |  |  |  | 1.2 | 1.5 | 1,5 (1,2)
 |  | 188 | #N/A | #N/A | 168 | 196
Desc | Type
Total | 0
Holiday | 1
Sunday | 2
night shift | 3
afternoon | 4
regular | 5