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
Bookmarks