Hi
I'm setting up a spreadsheet to calculate people's holidays. So far for each person I have a formula for counting the number of days a 'H' is input for holiday which is =COUNTIF(B2:AF2,"H") which is fine for counting full days, but I need a formula for counting half days so that if HH is input it will count the number of times it is input but add half each time.
I hope this makes sense.
Please help!!!
Thanks
Jackie