sammie9rCopper ContributorOct 26, 2021which 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 ...Show More
sammie9rCopper ContributorOct 26, 2021Hi i entered =COUNTIF(C16:K16,"sick")*7.5 and it came up with 60 hours
