=SUMPRODUCT(--((EXACT(E1:E20,"hAM"))+(EXACT(E1:E20,"hPM"))))*0.5 +COUNTIF(E1:E20,"h")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"GCC" wrote in message
...
I am trying to set up a holiday spreadsheet for work and I have got it so
it
adds up all the words holiday to say how many days each employee has taken
but I need to to add up the holiday AM and holiday PM as 0.5. Does anyone
know the formula to do this?