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

2011 Employees Sick Hours
Name | Allowed hrs | Used hrs | Date | Ramaining hrs | Note | Updated 12/27/11
[NAME] | 40 | 01:20:00 | 2011-03-09 00:00:00 | 38.4
 |  | 4 | 2011-04-15 00:00:00 | 34.4
 |  | 1 | 2011-06-23 00:00:00 | 33.4
 |  | 1.5 | 2011-07-21 00:00:00 | 31.5
 |  | 8 | 2011-07-27 00:00:00 | 23.5
 |  | 7.15 | 2011-12-14 00:00:00 | 16.35
Kristen | 40 | 4 | 2011-02-23 00:00:00 | 36
 |  | 6 | 2011-05-26 00:00:00 | 30 |  | Bf is hopitalize, came in for a meeting
 |  | 8 | 2011-06-15 00:00:00 | 22
 |  | 8 | 2011-09-19 00:00:00 | 14
 |  | 8 | 2011-11-02 00:00:00 | 6
[NAME] | 40 | 8 | 2011-09-26 00:00:00 | 32
 |  | 8 | 2011-11-18 00:00:00 | 24
[NAME] | 40 | 8 | 1/27/11 | 32 | Sick | *At first I only input 7:10, and add back in 50 mins for the next pay period.
 |  | 8 | 2011-03-24 00:00:00 | 24 | Sick
 |  | 01:20:00 | 2011-03-21 00:00:00 | 22:40:00 | Sick
 |  | 07:40:00 | 2011-04-08 00:00:00 | 15 | sick
 |  | 0.5 | 2011-06-17 00:00:00 | 14.1
 |  | 7.55 | 2011-08-12 00:00:00 | 6.15
 |  | 5.1 | 2011-09-09 00:00:00 | 1.05
Evelina | 40 | 06:30:00 | 2011-03-10 00:00:00 | 33.3
 |  | 07:10:00 | 2011-04-01 00:00:00 | 26.2
 |  | 7 | 2011-10-17 00:00:00 | 19.2
[NAME] | 40 | 8 | 2011-01-24 00:00:00 | 32 | sick
 |  | 8 | 2011-04-25 00:00:00 | 24
 |  | 3.4 | 2011-09-12 00:00:00 | 20.2
 |  | 4 | 2011-10-27 00:00:00 | 16.2
 |  | 4.5 | 2011-10-28 00:00:00 | 11.3
[NAME] | 30 | 6 | 2011-05-19 00:00:00 | 24
 |  | 6 | 2011-07-08 00:00:00 | 18
 |  | 6.3 | 2011-10-12 00:00:00 | 11.3
 |  | 2 | 2011-11-04 00:00:00 | 9.3
Turk | 40 | 8 | 2011-04-01 00:00:00 | 32
Audrette | 40 | 8 | 2011-01-27 00:00:00 | 32 | sick
 |  | 8 | 2011-03-10 00:00:00 | 24 | sick
 |  | 8 | 2011-03-11 00:00:00 | 16 | sick
 |  | 7 | 2011-06-27 00:00:00 | 9
 |  | 8 | 2011-09-30 00:00:00 | 1
Roxane | 40 | 07:50:00 | 2011-05-06 00:00:00 | 32:10
 |  | 8 | 2011-05-16 00:00:00 | 24:10
 |  | 07:45:00 | 2011-05-17 00:00:00 | 16:15
 |  | 13.3 | 8/23,8/24/11 | 2.45
 |  | 2.45 | 2011-12-08 00:00:00 | 0
[NAME] | 40 | 8 | 2011-05-09 00:00:00 | 32
 |  | 2 | 2011-09-12 00:00:00 | 30
 |  | 0.3 | 2011-10-07 00:00:00 | 29.3
 |  | 8 | 2011-11-09 00:00:00 | 21.3
 |  | 8 | 2011-11-15 00:00:00 | 13.3
 |  | 3.15 | 2011-11-16 00:00:00 | 10.15
Christina | 30 | 6 | 2011-01-27 00:00:00 | 24 | sick
 |  | 3 | 2011-04-25 00:00:00 | 21
 |  | 4 | 2011-04-26 00:00:00 | 27
 |  | 6 | 2011-10-06 00:00:00 | 21
Victoria | 40 | 07:30:00 | 2011-04-22 00:00:00 | 32:30
 |  | 4 | 2011-06-24 00:00:00 | 28.3
 |  | 5 | 2011-06-29 00:00:00 | 23.3
 |  | 3.25 | 2011-06-30 00:00:00 | 20.05
 |  | 2.15 | 2011-07-11 00:00:00 | 17.5
 |  | 7.2 | 2011-10-03 00:00:00 | 10.3
 |  | 7.3 | 2011-12-06 00:00:00 | 3
Reggi | 40 | 6 | 2011-03-18 00:00:00 | 34
 |  | 8 | 2011-04-12 00:00:00 | 26
 |  | 8 | 2011-05-02 00:00:00 | 18
 |  | 8 | 2011-06-13 00:00:00 | 10
 |  | 8 | 2011-06-20 00:00:00 | 2
 |  | 1 | 2011-06-17 00:00:00 | 1
 |  | 1 | 2011-07-25 00:00:00 | 0
[NAME] | 40 | 07:30:00 | 2011-02-18 00:00:00 | 32:30
 |  | 04:30:00 | 2011-04-05 00:00:00 | 28:30
 |  | 8 | 2011-06-10 00:00:00 | 20:30
 |  | 4 | 2011-08-15 00:00:00 | 16.3
 |  | 8 | 2011-11-14 00:00:00 | 8.3
Violet | 40 | 8 | 2011-04-20 00:00:00 | 32
 |  | 8 | 2011-06-20 00:00:00 | 24
 |  | 8 | 2011-08-08 00:00:00 | 16
 |  | 5.2 | 2011-09-19 00:00:00 | 10.4
 |  | 7.25 | 2011-11-15 00:00:00 | 3.15
Rebecca | 40 | 6 | 2011-01-24 00:00:00 | 34
 |  | 8 | 2011-04-19 00:00:00 |  | [NAME] was ill
 |  | 8 | 2011-04-20 00:00:00
 |  | 8 | 2011-04-21 00:00:00
 |  | 8 | 2011-04-22 00:00:00 | 2
[NAME] | 30 as of Sep | 6.3 | 2011-09-21 00:00:00 | 23.3
 |  | 6 | 2011-10-21 00:00:00 | 17.3
[NAME] | 30 as of Oct | 4.45 | 2011-07-21 00:00:00 | 25.15
[NAME] | 20 as of Sep | 1.3 | 2011-10-17 00:00:00 | 18.3