Calculate Employee Sick/Vacation time

Topic Labels: Formulas
1440 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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:
Screen Shot 2020-11-04 at 4.37.09 PM

Thanks for any help you’ve got!

1 Reply 1
4 - Data Explorer
4 - Data Explorer


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: :grinning_face_with_sweat:

Any help would be so appreciated!