Spreadsheet: 53973d1253897405-subtracting-hours-in-a-work-schedule-store-3-and-15-schedule-side-by-side
Sheet: Store 3 and 15

STORE 3 | 2009-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | WORK SCHEDULE |  |  |  |  |  |  |  | STORE 15 | 2009-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | WORK SCHEDULE
DATE |  |  |  | 2009-10-01 00:00:00 |  |  | 2009-10-02 00:00:00 |  |  | 2009-10-03 00:00:00 |  |  | 2009-10-05 00:00:00 |  |  | 2009-10-06 00:00:00 |  |  |  |  | DATE |  |  |  | 2009-10-01 00:00:00 |  |  | 2009-10-02 00:00:00 |  |  | 2009-10-03 00:00:00 |  |  | 2009-10-05 00:00:00 |  |  | 2009-10-06 00:00:00
EMPLOYEE | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | MONDAY |  |  | TUESDAY |  |  | TOTAL HOURS |  | EMPLOYEE | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | MONDAY |  |  | TUESDAY |  |  | TOTAL HOURS |  |  | GRAND TOTAL |  |  |  | EMPLOYEE |  | # DAYS | # NIGHT
DARCELL | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 | 14:15:00 | 21:15:00 | 6.499999999999999 |  |  | 0 |  |  | 0 |  |  | 0 | 13 |  | DARCELL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 14:15:00 | 21:15:00 | 6.499999999999999 |  |  | 0 | 6.499999999999999 |  |  | DARCELL |  | 19.5 |  | DARCELL |  | 0 | 0
CLINTON |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CLINTON |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | CLINTON |  | 0 |  | CLINTON |  | 0 | 0
LAURA |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LAURA |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | LAURA |  | 0 |  | LAURA
CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | CATHERINE |  | 0 |  | CATHERINE
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TERENCE |  | 0 |  | TERENCE
NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | NICK |  | 0 |  | NICK
LYNN | 15:00:00 | 21:15:00 | 6.249999999999999 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 6.249999999999999 |  | LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | LYNN |  | 6.249999999999999 |  | LYNN
TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TROY |  | 0 |  | TROY
BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | BILL |  | 0 |  | BILL
HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | HELP |  | 0 |  | HELP
DATE | 2009-10-07 00:00:00 |  |  | 2009-10-08 00:00:00 |  |  | 2009-10-09 00:00:00 |  |  | 2009-10-10 00:00:00 |  |  | 2009-10-12 00:00:00 |  |  | 2009-10-13 00:00:00 |  |  |  |  | DATE | 2009-10-07 00:00:00 |  |  | 2009-10-08 00:00:00 |  |  | 2009-10-09 00:00:00 |  |  | 2009-10-10 00:00:00 |  |  | 2009-10-12 00:00:00 |  |  | 2009-10-13 00:00:00
DARCELL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | DARCELL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | DARCELL |  | 0 |  | DARCELL
CLINTON |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CLINTON |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | CLINTON |  | 0 |  | CLINTON
LAURA |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LAURA |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | LAURA |  | 0 |  | LAURA
CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | CATHERINE |  | 0 |  | CATHERINE
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TERENCE |  | 0 |  | TERENCE
NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | NICK |  | 0 |  | NICK
LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | LYNN |  | 0 |  | LYNN
TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TROY |  | 0 |  | TROY
BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | BILL |  | 0 |  | BILL
HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | HELP |  | 0 |  | HELP
DATE | 2009-10-14 00:00:00 |  |  | 2009-10-15 00:00:00 |  |  | 2009-10-16 00:00:00 |  |  | 2009-10-17 00:00:00 |  |  | 2009-10-19 00:00:00 |  |  | 2009-10-20 00:00:00 |  |  |  |  | DATE | 2009-10-14 00:00:00 |  |  | 2009-10-15 00:00:00 |  |  | 2009-10-16 00:00:00 |  |  | 2009-10-17 00:00:00 |  |  | 2009-10-19 00:00:00 |  |  | 2009-10-20 00:00:00
DARCELL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | DARCELL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | DARCELL |  | 0 |  | DARCELL
CLINTON |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CLINTON |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | CLINTON |  | 0 |  | CLINTON
LAURA |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LAURA |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | LAURA |  | 0 |  | LAURA
CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | CATHERINE |  | 0 |  | CATHERINE
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TERENCE |  | 0 |  | TERENCE
NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | NICK |  | 0 |  | NICK
LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | LYNN |  | 0 |  | LYNN
TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TROY |  | 0 |  | TROY
BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | BILL |  | 0 |  | BILL
HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | HELP |  | 0 |  | HELP
DATE | 2009-10-21 00:00:00 |  |  | 2009-10-22 00:00:00 |  |  | 2009-10-23 00:00:00 |  |  | 2009-10-24 00:00:00 |  |  | 2009-10-26 00:00:00 |  |  | 2009-10-27 00:00:00 |  |  |  |  | DATE | 2009-10-21 00:00:00 |  |  | 2009-10-22 00:00:00 |  |  | 2009-10-23 00:00:00 |  |  | 2009-10-24 00:00:00 |  |  | 2009-10-26 00:00:00 |  |  | 2009-10-27 00:00:00
DARCELL | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 6.499999999999999 |  | DARCELL |  |  | 0 | 14:15:00 | 21:15:00 | 6.499999999999999 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 6.499999999999999 |  |  | DARCELL |  | 13 |  | DARCELL
CLINTON |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CLINTON |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | CLINTON |  | 0 |  | CLINTON
LAURA |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LAURA |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | LAURA |  | 0 |  | LAURA
CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | CATHERINE |  | 0 |  | CATHERINE
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TERENCE |  | 0 |  | TERENCE
NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | NICK |  | 0 |  | NICK
LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | LYNN |  | 0 |  | LYNN
TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TROY |  | 0 |  | TROY
BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | BILL |  | 0 |  | BILL
HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | HELP |  | 0 |  | HELP
DATE | 2009-10-28 00:00:00 |  |  | 2009-10-29 00:00:00 |  |  | 2009-10-30 00:00:00 |  |  | 2009-10-31 00:00:00 |  |  |  |  |  |  |  |  |  |  | DATE | 2009-10-28 00:00:00 |  |  | 2009-10-29 00:00:00 |  |  | 2009-10-30 00:00:00 |  |  | 2009-10-31 00:00:00
DARCELL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | DARCELL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | DARCELL |  | 0 |  | DARCELL
CLINTON |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CLINTON |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | CLINTON |  | 0 |  | CLINTON
LAURA |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LAURA |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | LAURA |  | 0 |  | LAURA
CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | CATHERINE |  | 0 |  | CATHERINE
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TERENCE |  | 0 |  | TERENCE
NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | NICK |  | 0 |  | NICK
LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | LYNN |  | 0 |  | LYNN
TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | TROY |  | 0 |  | TROY
BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | BILL |  | 0 |  | BILL
HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  |  | HELP |  | 0 |  | HELP
 |  | SPLIT1 = 8:15AM-12NOON, 4:00PM-9:15PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPLIT1 = 8:15AM-12NOON, 4:00PM-9:15PM
 |  | SPLIT2 = 9:00AM-12NOON, 5:00PM-9:15PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPLIT2 = 9:00AM-12NOON, 5:00PM-9:15PM