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)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"DJ" wrote:

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?