I have created calendars in Excel to track my emp. personal time. My dilemma is that I used letters in the calenders so P=1 and the formula counts the days but we allow them to use half days so I need the formula to recognize PH as 0.5 and count that as well. How would I go about doing that and incorporating it into my formula
EX:
Jane takes the 28 and 29 as personal days and she uses a whole and a half day so in essense she has a P and a PH how can I get the formula to count 1.5?
HELP PLEASE
EX:
Jane takes the 28 and 29 as personal days and she uses a whole and a half day so in essense she has a P and a PH how can I get the formula to count 1.5?
HELP PLEASE