Forum Discussion

sammie9r's avatar
sammie9r
Copper Contributor
Oct 26, 2021

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 ...
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 26, 2021

sammie9r 

=COUNTIF(A2:F2,"sick")*7.5

Is this the forumla you are looking for? 

  • sammie9r's avatar
    sammie9r
    Copper Contributor
    Oct 26, 2021
    Hi Nearly there but the total for one weeks sick should be 37.5 hours 7,5 hours per day not 67.5 hours
    • OliverScheurich's avatar
      OliverScheurich
      Gold Contributor
      Oct 26, 2021

      sammie9r 

      =COUNTIF(A2:E2,"sick")*F2

      Please try formula above.

      • sammie9r's avatar
        sammie9r
        Copper Contributor
        Oct 26, 2021
        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