I was wondering if anyone could help with a formula I have a holidday
spreadsheet that tracks employees holidays and sick throughout the year at
work.

I have a colum that counts the number of holidays ane employee taske but I
am not sure how to count half days can any one help my formula is below


=COUNTIF(M6:GL6,"Bh")+(COUNTIF(M23:GK23,"Bh"))=COU NTIF(M6:GL6,"Bh")/0.05

thanks
--
N/A