Forum Discussion
which formula works
B/H Monday Tuesday Wednesday Thursday Friday TOTAL HOURS SICK ANNUAL LEAVE Total hrs remaining 09:00 - 17:00 sick 09:00 - 17:00 09:00 - 17:00 22.5 7.5 7.5 278 Hi I'm new ...
Hi Nearly there but the total for one weeks sick should be 37.5 hours 7,5 hours per day not 67.5 hours
- Thank you i also need the annual leave column to do the same thing but you have bank holiday and A/L how do you get them both to work in the same cell
=278-COUNTIF(A2:E2,"A/L")*F2
I assume that a day A/L reduces the Annual Leave by 7,5 hours and a bank holiday doesn't.