Skip to main content

Calculate Employee Sick/Vacation time

  • November 5, 2020
  • 1 reply
  • 1 view

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!
Heather

1 reply

  • New Participant
  • 1 reply
  • November 11, 2020

Hello,

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!

Best,
Galia


Reply