Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting

[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?

 

[Shane Devenshire]

Hi,

In both cases something like

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