Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting

  • Thread starter Thread starter DJ
  • Start date Start date
D

DJ

I am setting a up bit of a complicated spreadsheet to coincide with our
vacation and sick policy.

For instance a staffer accrues 3.5 hours per pay period, howerever I need a
formula to calculate those 3.5 hours per pay period but not to exceed 210
hours.

Also for vacation accrual, staffers are only allowed to carry over 70 hours
of vacation per year, is there a formual to automatically deduct access hours
to bring the amount of vacation hours back to 70 hours?
 
Hi,

In both cases something like

=MIN(VacationCalculation,79)
=MIN(SickCalculation,210)
 
Back
Top