Hi
I am using the excel spreadsheet template and would like to assign a value for a half day, this is the formula I have now in the vacation column

=COUNTIF($B6:$AF6,"V")

I would like V to be designated as 1 and v as 1/2

Can anyone please help?

Thank you