I have a simple Employee time sheet with a value list that has 'vacation and sick' as the two choices. I have another field for total days. I am using a portal that gives me a line for each block of time and on that line I can choose the type of time off and enter the total days for that block.
Example: Employee 1 takes January 5-7 off as vacation (3 days), January 10 as sick (1 day) and January 14 as vacation (1 day).
I am looking for a calculation to return (4 vacation and 1 sick day used)
Thanks in advance, I am sure this is fairly easy but I am stuck.