Oct 26 2021 08:40 AM
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 to excel i am trying to do a formula that would automatically put 7,5 hours in the sick column if someone went sick on a particular day i got so far as =if(G1="SICK",7.5"0"
It works for one day but if they were sick for the whole week i need it to total 37.5 hours anyone help please
Oct 26 2021 09:11 AM
Oct 26 2021 09:27 AM
Oct 26 2021 09:49 AM
Oct 26 2021 09:54 AM
Oct 26 2021 10:15 AM
=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.
Oct 26 2021 10:33 AM