Spreadsheet: 706235d1606551890-help-with-time-formulas-start-end-hrswork-ot-new-schedule
Sheet: Sheet1

INBOUND TEAM |  |  | SUN NOV 29 |  |  |  |  | MON NOV 30 |  |  |  |  | TUE DEC 1 |  |  |  |  | WED DEC 2 |  |  |  |  | THU DEC 3 |  |  |  |  | FRI DEC 4 |  |  |  |  | SAT DEC 5 |  |  |  |  | WEEKLY TOTALS
REGION | NAME | SKILL | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | TOTAL HRS | TOTAL OT | LATE
ALL REGIONS |  | CDN NDC INBOUND EN | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:45:00 |  |  |  | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 19:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND EN | 06:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND EN | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND EN | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 |  | CDN NDC INBOUND EN | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
REGION | AREA COORDINATOR |  | SUN DEC 6 |  |  |  |  | MON DEC 7 |  |  |  |  | TUE DEC 8 |  |  |  |  | WED DEC 9 |  |  |  |  | THUR DEC 10 |  |  |  |  | FRI DEC 11 |  |  |  |  | SAT DEC 12 |  |  |  |  | TOTAL HRS | TOTAL OT | LATE
EAST |  | CDN NDC INBOUND F/E | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
EAST |  | CDN NDC INBOUND F/E | 08:00:00 | 16:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
EAST |  | CDN NDC INBOUND F/E | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
EAST |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
EAST |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
EAST |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
CENTRAL |  | CDN NDC INBOUND EN | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
CENTRAL |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
CENTRAL |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
WEST |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
WEST |  | CDN NDC INBOUND EN | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
WEST |  | CDN NDC INBOUND F/E | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00
 | TEAM LEAD | SKILL | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | START | END | TOTAL HRS WRK | OT | LATE | TOTAL HRS | TOTAL OT | LATE
 |  | ALL | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 16:00:00 |  |  |  | 07:00:00 | 16:00:00
 |  | ALL | 06:00:00 | 19:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00 |  |  |  | 07:00:00 | 15:00:00