Spreadsheet: 53032d1252945631-subtracting-hours-in-a-work-schedule-schedule-for-3-and-15_1-1
Sheet: Store 3

STORE 3
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 |  | GRAND TOTAL |  |  |  | EMPLOYEE |  | # DAYS | # NIGHT | HOLIDAY | SPLIT1 | SPLIT2 | VAC6.25 | VAC6.5 | VAC6.75 | VAC7.25 | WD
DARCELL | 14:00:00 | 21:15:00 | 6.749999999999998 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:15:00 | 6.750000000000001 | 08:15:00 | 16:00:00 | 7.249999999999999 |  |  | 0 | 09:00:00 | 16:15:00 | 6.750000000000001 | 34 |  | DARCELL |  | 40 |  | DARCELL |  | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CLINTON | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:00:00 | 21:15:00 | 6.749999999999998 | 14:15:00 | 21:15:00 | 6.499999999999999 | 13:30:00 | 21:15:00 | 7.249999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 39.99999999999999 |  | CLINTON |  | 39.99999999999999 |  | CLINTON |  | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LAURA | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:00:00 | 21:15:00 | 6.749999999999998 | 09:00:00 | 16:00:00 | 6.499999999999999 | 13:30:00 | 21:15:00 | 7.249999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 39.99999999999999 |  | LAURA |  | 39.99999999999999 |  | LAURA |  | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 | SPLIT1 |  | 9 |  |  | 0 |  |  | 0 | 9 |  | CATHERINE |  | 9 |  | CATHERINE |  | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | SPLIT2 |  | 7.25 |  |  | 0 | 7.25 |  | TERENCE |  | 7.25 |  | TERENCE |  | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | NICK |  | 0 |  | NICK |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LYNN |  | 0 |  | LYNN |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TROY |  | 0 |  | TROY |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | BILL |  | 0 |  | BILL |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | HELP |  | 0 |  | HELP |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
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 |  | DARCELL |  | 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 |  | LAURA |  | 0 | 0
CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CATHERINE |  | 0 |  | CATHERINE |  | 0 | 0
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TERENCE |  | 0 |  | TERENCE |  | 0 | 0
NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | NICK |  | 0 |  | NICK |  | 0 | 0
LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LYNN |  | 0 |  | LYNN |  | 0 | 0
TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TROY |  | 0 |  | TROY |  | 0 | 0
BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | BILL |  | 0 |  | BILL |  | 0 | 0
HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | HELP |  | 0 |  | HELP |  | 0 | 0
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 |  | DARCELL |  | 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 |  | LAURA |  | 0 | 0
CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CATHERINE |  | 0 |  | CATHERINE |  | 0 | 0
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TERENCE |  | 0 |  | TERENCE |  | 0 | 0
NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | NICK |  | 0 |  | NICK |  | 0 | 0
LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LYNN |  | 0 |  | LYNN |  | 0 | 0
TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TROY |  | 0 |  | TROY |  | 0 | 0
BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | BILL |  | 0 |  | BILL |  | 0 | 0
HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | HELP |  | 0 |  | HELP |  | 0 | 0
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 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | DARCELL |  | 0 |  | DARCELL |  | 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 |  | LAURA |  | 0 | 0
CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CATHERINE |  | 0 |  | CATHERINE |  | 0 | 0
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TERENCE |  | 0 |  | TERENCE |  | 0 | 0
NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | NICK |  | 0 |  | NICK |  | 0 | 0
LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LYNN |  | 0 |  | LYNN |  | 0 | 0
TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TROY |  | 0 |  | TROY |  | 0 | 0
BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | BILL |  | 0 |  | BILL |  | 0 | 0
HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | HELP |  | 0 |  | HELP |  | 0 | 0
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 |  | DARCELL |  | 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 |  | LAURA |  | 0 | 0
CATHERINE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | CATHERINE |  | 0 |  | CATHERINE |  | 0 | 0
TERENCE |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TERENCE |  | 0 |  | TERENCE |  | 0 | 0
NICK |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | NICK |  | 0 |  | NICK |  | 0 | 0
LYNN |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | LYNN |  | 0 |  | LYNN |  | 0 | 0
TROY |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | TROY |  | 0 |  | TROY |  | 0 | 0
BILL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | BILL |  | 0 |  | BILL |  | 0 | 0
HELP |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | HELP |  | 0 |  | HELP |  | 0 | 0