Spreadsheet: 525547d1498766682-calculating-sick-leave-absent-but-no-pay-test
Sheet: May

AFTER | 2017
After | Days Remaning |  | Comments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month Hours
 |  |  |  | 2017-05-01 00:00:00 | 2017-05-02 00:00:00 | 2017-05-03 00:00:00 | 2017-05-04 00:00:00 | 2017-05-05 00:00:00 | 2017-05-06 00:00:00 | 2017-05-07 00:00:00 | 2017-05-08 00:00:00 | 2017-05-09 00:00:00 | 2017-05-10 00:00:00 | 2017-05-11 00:00:00 | 2017-05-12 00:00:00 | 2017-05-13 00:00:00 | 2017-05-14 00:00:00 | 2017-05-15 00:00:00 | 2017-05-16 00:00:00 | 2017-05-17 00:00:00 | 2017-05-18 00:00:00 | 2017-05-19 00:00:00 | 2017-05-20 00:00:00 | 2017-05-21 00:00:00 | 2017-05-22 00:00:00 | 2017-05-23 00:00:00 | 2017-05-24 00:00:00 | 2017-05-25 00:00:00 | 2017-05-26 00:00:00 | 2017-05-27 00:00:00 | 2017-05-28 00:00:00 | 2017-05-29 00:00:00 | 2017-05-30 00:00:00 | 2017-05-31 00:00:00
Vacation/Floating Holiday |  | 176 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation/Floating Holiday
Sick |  | 120 |  |  | 8 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
Personal |  | 24 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal
Holiday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
Compassion |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compassion
On Job Injury |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Job Injury
Meeting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meeting
Contract |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract
AAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAR
Operations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Operations
Operations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Operations
Operations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Operations
Mobile |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
MOW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MOW
Derailment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Derailment
Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 |  |  | Total Daily Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Month Hours
 |  |  | Total Weekly Hours
Worksheet May (After)
-employee took 1 personal day 5/1(8 hours) cell E6
-employee took 1 sick day with doctors note 5/2 (8 hours) cell F5
-employee took 1 sick day with NO doctors note 5/3 (8 hours) cell G5
I need to calculate the sick leave formula in cell B5 to show G5 as 8 hours subtracted from sick leave total but also to show 0 hours worked