title: =Counta recognise 0.5 conditional formatting as half
body: <p>I've conditionally formatted a row so that when you put H or S or P in it changes colour.
  At the end of the row I have done the =Counta formula so that I can get the total. </p>
  
  <p>The problem is I also have H-0.5,S-0.5 and P-0.5 (Half day). Is there a way to make =counta at recognise this?</p>
  
  <p>The total is linked to another spreadsheet and if some of the employee's only have 14.5 days remaining of holiday it will say 15 for example.</p>
  
  <p>Thanks</p>