Spreadsheet: 167347d1341955697-excel-2007-calculating-sick-hours-out-of-a-forty-hour-work-week-employees-sick-hrs-nicks-version
Sheet: 2010

Employees Sick Hours for the year 2010
Name | Allowed Hrs | Date | Used Hrs | Remaining Hrs
Lance | 40+8 (8 hrs from last yr) | 2010-01-28 00:00:00 | 8 | 40
[NAME] | 40 | 2010-03-19 00:00:00 | 3 hrs 45 mins | 36 hrs 15 mins
 |  | 2010-03-22 00:00:00 | 8 hrs | 28 hrs 15 mins
 |  | 2010-07-20 00:00:00 | 6 hrs 20 mins | 21 hrs 55 mins
 |  | 2010-08-16 00:00:00 | 4 hrs 20 mins | 17 hr 35 mins
 |  | 2010-10-07 00:00:00 | 11 hrs | 6 hrs 35 mins
 |  | 2010-11-29 00:00:00 | 6 hrs 35 mins | 0
[NAME] | 48 | 2010-02-05 00:00:00 | 8 hrs | 40 hrs
[NAME] | 40
2010-01-18 00:00:00 | 2 hrs 10 mins |  |  | 31 hrs 50 mins
2010-01-19 00:00:00 | 8 hrs |  |  | 23 hrs 50 mins
2010-03-29 00:00:00 | 7 hrs 45 mins |  |  | 16 hrs 5 mins
Kristen | 40 | 2010-01-20 00:00:00 | 6 hrs 35 mins | 34 hrs 25 mins
 |  | 2010-02-10 00:00:00 | 5 hrs | 29 hrs 25 min
 |  | 2010-04-16 00:00:00 | 8hrs | 21 hrs 25 mins
 |  | 2010-05-19 00:00:00 | 8 hrs | 13 hrs 25 mins
 |  | 2010-05-26 00:00:00 | 2hrs 30 mins | 11 hrs 05 mins
 |  | 2010-09-17 00:00:00 | 8 hrs | 3 hrs 05 mins
[NAME] | 40
 |  | 2010-03-04 00:00:00 | 8 | 32
 |  | 2010-03-30 00:00:00 | 6.55 | 25.45 | 25.05
 |  | 2010-09-02 00:00:00 | 5.55 | 19.1
 |  | 2010-10-21 00:00:00 | 6.1 | 13
 |  | 2010-12-17 00:00:00 | 8 | 5
Evelina | 40 | 2010-02-24 00:00:00 | 8 hrs | 32 hrs
 |  | 2010-03-01 00:00:00 | 2 hrs 45 mins | 29 hrs 15 mins
 |  | 2010-03-05 00:00:00 | 8 hrs | 21 hrs 15 mins
 |  | 2010-03-19 00:00:00 | 3 hr 30 mins | 17 hrs 45 mins
 |  | 2010-04-12 00:00:00 | 8 hrs 25 mins | 9hrs 20 mins
 |  | 2010-08-09 00:00:00 | 8 hrs | 1 hrs 20 mins
Audrette | 40 | 2010-04-07 00:00:00 | 7 hrs 40 mins | 32 hrs 20 mins
 |  | 2010-05-10 00:00:00 | 7 hrs 55 mins | 24 hrs 15 mins
 |  | 2010-08-19 00:00:00 | 8 hrs | 16 hrs 15 mins
 |  | 2010-09-17 00:00:00 | 7 hrs 50 mins | 8 hrs 15 mins
 |  | 2010-11-01 00:00:00 | 8 hrs 15 mins | 0
Roxy | 40 |  | 6 hrs 40 mins | 33 hrs 20mins
 |  |  | 7hrs 40 mins | 25 hrs 40 mins
 |  |  | 7hrs 55mins | 17hrs 45 mins
 |  | 2010-07-12 00:00:00 | 7 hrs 50 mins | 9hrs 55 mins
 |  | 2010-08-09 00:00:00 | 3 hrs | 6 hrs 55 mins
 |  | 2010-10-28 00:00:00 | 5 hrs 25 mins | 1 hr 30 mins
[NAME] | 37 | 2010-02-12 00:00:00 | 8 | 29
 |  | 2010-02-10 00:00:00 | 8 | 21
 |  | 2010-04-20 00:00:00 | 7hrs 35 mins | 13 hrs 25 mins
 |  | 2010-09-16 00:00:00 | 3 hrs 55 mins | 9 hrs 30 mins
[NAME] | 30 | 2010-01-18 00:00:00 | 1 hr 40 mins | 28 hrs 20 mins
 |  | 2010-06-28 00:00:00 | 6hrs | 22 hrs 20 mins
 |  | 2010-10-26 00:00:00 | 6 hrs | 16 hrs 20 mins
[NAME] | 40 | 2010-01-18 00:00:00 | 8 hrs | 32 hrs
 |  | 2010-01-19 00:00:00 | 3 hrs 25 mins | 28 hrs 35 mins
 |  | 2010-02-01 00:00:00
 |  | 2010-02-02 00:00:00
 |  | 2010-02-03 00:00:00
 |  | 2010-02-22 00:00:00 | 6 hrs 30 mins | 22 hrs 5 mins
 |  | 2010-04-05 00:00:00 | 8hrs | 14 hrs 5 mins
 |  | 2010-10-11 00:00:00 | 8 hrs | 6 hrs 5 mins
 |  | 2010-12-07 00:00:00 | 6 hrs 5 mins | 0
[NAME] | 20 as of June | 2010-06-24 00:00:00 | 4 hrs 25 mins | 15 hrs 35 mins
 |  |  | 2 hrs 05 mins | 13 hrs 30 mins
Christina | 10 as july | 2010-07-01 00:00:00 | 1 hours | 9 hours
 |  | 2010-08-26 00:00:00 | 6 hrs 10 mins | 2 hrs 50 mins
Reggi | 26 as of Dec | 2010-10-07 00:00:00 | 8 hrs | 14 hrs
 |  | 2010-11-18 00:00:00 | 2 hrs 30 mins | 11 hrs 30 mins
 |  | 2010-11-23 00:00:00 | 8 hrs | 3 hrs 30 mins
[NAME] | 20 as of December
Violet | 20 as of December | 2010-12-14 00:00:00