Spreadsheet: 108929d1305843855-if-formula-working-with-work-shifts-work-schedule-blank-hours-worksheet
Sheet: Sheet2

 |  | RAC WORK SCHEDULE |  |  |  |  |  |  |  |  |  |  |  |  |  | DEPARTMENT: |  |  |  |  | Service Desk
 | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  |  |  | SUNDAY
 | 04:30:00 |  | 12:30:00 |  | 04:30:00 |  | 12:30:00 |  | 04:30:00 |  | 12:30:00 |  | 04:30:00 |  | 12:30:00 |  | 04:30:00 |  | 12:30:00 |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8 | 8 | 0 | 0 |  | 40
 | 10 | 30 | 08:30:00 |  | 10 | 30 | 08:30:00 |  | 10 | 30 | 08:30:00 |  | 10 | 30 | 08:30:00 |  | 10 | 30 | 08:30:00 |  |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0 | 0 |  | 37.5
 | sub: |  |  |  | sub: |  |  |  | sub: |  |  |  | sub: |  |  |  | sub:
 | 12:30:00 |  | 16:00:00 |  | 12:30:00 |  | 16:00:00 |  | 12:30:00 |  | 16:00:00 |  | 12:30:00 |  | 16:00:00 |  | 12:30:00 |  | 16:00:00 |  |  |  |  |  |  |  |  |  | 3.499999999999998 | 3.499999999999998 | 3.499999999999998 | 3.499999999999998 | 3.499999999999998 | 0 | 0 |  | 17.49999999999999
 | 10 |  |  |  | 10 |  |  |  | 10 |  |  |  | 10 |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 17.49999999999999
 | sub: |  |  |  | sub: |  |  |  | sub: |  |  |  | sub: |  |  |  | sub:
 | 16:00:00 |  | 22:30:00 |  | 16:00:00 |  | 22:30:00 |  | 16:00:00 |  | 22:30:00 |  |  |  |  |  |  |  |  |  | 08:30:00 |  | 17:30:00 |  | 07:30:00 |  | 15:00:00 |  | 6.500000000000001 | 6.500000000000001 | 6.500000000000001 | 0 | 0 | 8.999999999999998 | 7.5 |  | 36
 | 10 |  |  |  | 10 |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  | 10 | 30 |  |  | 10 | 30 | 11:30:00 |  | 0.5 | 0.5 | 0.5 | 0 | 0 | 0.5 | 0.5 |  | 33.5
 | sub: |  |  |  | sub: |  |  |  | sub: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sub:
 |  |  |  |  | 17:00:00 |  | 20:30:00 |  |  |  |  |  | 17:00:00 |  | 22:30:00 |  | 17:00:00 |  | 22:30:00 |  | 15:00:00 |  | 21:30:00 |  | 15:00:00 |  | 21:30:00 |  | 0 | 3.499999999999998 | 0 | 5.499999999999999 | 5.499999999999999 | 6.500000000000001 | 6.500000000000001 |  | 27.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 10 |  |  |  | 10 | 30 | 17:00:00 |  | 10 | 30 | 18:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0.5 | 0.5 |  | 26.5
 |  |  |  |  |  |  |  |  |  |  |  |  | sub: |  |  |  | sub: |  |  |  | sub: |  |  |  | sub:
 | 16:00:00 |  | 20:00:00 |  |  |  |  |  | 16:00:00 |  | 20:30:00 |  | 16:00:00 |  | 20:30:00 |  |  |  |  |  | 07:30:00 |  | 15:00:00 |  | 11:00:00 |  | 20:00:00 |  | 4.000000000000002 | 0 | 4.5 | 4.5 | 0 | 7.5 | 9.000000000000002 |  | 29.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 30 | 11:00:00 |  | 10 | 30 | 15:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0.5 | 0.5 |  | 28.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sub: |  |  |  | sub:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Breaks must be taken before you have worked for 6 hours and 1 minute. If staffing is unavailable for your break, please note it on your time card.
 | WEEK OF: