Calculate Employee Sick/Vacation time

Hi All, I have a great working time sheet base that calculates day totals and accrued vacation and sick time, but now I want to be able to subtract USED vacation and sick time from those accruals. I’m wondering if I can use check boxes to identify entries that are sick or vacation and the work those checked boxes into a formula that subtracts the identified records from the total accrued.

Here’s a screenshot:

Thanks for any help you’ve got!

1 Like


I am looking for a time sheet base that does exactly that. Would you mind sharing that base? I am not so good with formulas and have been trying to create this for 2 days now :cry::sweat_smile:

Any help would be so appreciated!


This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.