Spreadsheet: 52721d1252555160-subtracting-hours-in-a-work-schedule-schedule-for-3-and-15_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
DARCELL | 14:15:00 | 16:00:00 | 1.249999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 33.74999999999999 |  | DARCELL |  | 40.24999999999999 |  | DARCELL
CLINTON | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | CLINTON |  | 77.99999999999999 |  | CLINTON
LAURA | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | LAURA |  | 77.99999999999999 |  | LAURA
CATHERINE | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | CATHERINE |  | 77.99999999999999 |  | CATHERINE
TERENCE | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | TERENCE |  | 77.99999999999999 |  | TERENCE
NICK | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | NICK |  | 77.99999999999999 |  | NICK
LYNN | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | LYNN |  | 77.99999999999999 |  | LYNN
TROY | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 33 |  | TROY |  | 66 |  | TROY
BILL | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | BILL |  | 77.99999999999999 |  | BILL
HELP | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  |  |  |  | 0 | 26 |  | HELP |  | 26 |  | 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
DARCELL |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 | 6.499999999999999 |  | DARCELL |  | 40.24999999999999
CLINTON | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | CLINTON |  | 77.99999999999999
LAURA | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | LAURA |  | 77.99999999999999
CATHERINE | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | CATHERINE |  | 77.99999999999999
TERENCE | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | TERENCE |  | 77.99999999999999
NICK | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | NICK |  | 77.99999999999999
LYNN | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | LYNN |  | 77.99999999999999
TROY | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 33 |  | TROY |  | 66
BILL | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | BILL |  | 77.99999999999999
HELP | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | HELP |  | 26
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 | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 | 6.499999999999999 |  | DARCELL |  | 40.24999999999999
CLINTON | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | CLINTON |  | 77.99999999999999
LAURA | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | LAURA |  | 77.99999999999999
CATHERINE | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | CATHERINE |  | 77.99999999999999
TERENCE | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | TERENCE |  | 77.99999999999999
NICK | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | NICK |  | 77.99999999999999
LYNN | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | LYNN |  | 77.99999999999999
TROY | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 33 |  | TROY |  | 66
BILL | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | BILL |  | 77.99999999999999
HELP | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | HELP |  | 26
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 | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 | 6.499999999999999 |  | DARCELL |  | 40.24999999999999
CLINTON | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | CLINTON |  | 77.99999999999999
LAURA | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | LAURA |  | 77.99999999999999
CATHERINE | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | CATHERINE |  | 77.99999999999999
TERENCE | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | TERENCE |  | 77.99999999999999
NICK | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | NICK |  | 77.99999999999999
LYNN | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | LYNN |  | 77.99999999999999
TROY | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 33 |  | TROY |  | 66
BILL | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 38.99999999999999 |  | BILL |  | 77.99999999999999
HELP | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 38.99999999999999 |  | HELP |  | 26
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 |  | 40.24999999999999
CLINTON | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 |  |  | 0 | 26 |  | CLINTON |  | 77.99999999999999
LAURA | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 |  |  | 0 | 26 |  | LAURA |  | 77.99999999999999
CATHERINE | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 |  |  | 0 | 26 |  | CATHERINE |  | 77.99999999999999
TERENCE | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 |  |  | 0 | 26 |  | TERENCE |  | 77.99999999999999
NICK | 09:00:00 | 16:00:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 |  |  | 0 |  |  | 0 | 26 |  | NICK |  | 77.99999999999999
LYNN | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 |  |  | 0 | 26 |  | LYNN |  | 77.99999999999999
TROY | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 | 09:00:00 | 15:00:00 | 5.5 |  |  | 0 |  |  | 0 | 22 |  | TROY |  | 66
BILL | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 | 14:15:00 | 21:15:00 | 6.499999999999999 |  |  | 0 |  |  | 0 | 26 |  | BILL |  | 77.99999999999999
HELP | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 | 09:00:00 | 16:00:00 | 6.499999999999999 |  |  | 0 |  |  | 0 | 26 |  | HELP |  | 26