View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GCC GCC is offline
external usenet poster
 
Posts: 12
Default how do I add words, holiday =1, holiday am=0.5

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?