Per a new Massachusetts sick time law, we need to accrue sick time at a rate of 1 hour sick time for every 30 hours worked up to a maximum of 40 accrued sick time hours per year. The calculation field below handles the accrual just fine, but can't seem to stop the accrual once the total accrual reaches the 40 hour mark.
(Sick Time 2016 Carry Over + Facility Wkday Hrs + Fac Hol Wday OT Hrs + Homecare Wkday Hrs + Home Hol Wday OT Hr + Office Staff Regular Hours + Other Hours + Visits Wkday Hours + Visits Wkend Hours + # of Travel Hrs + # of Travel OT HOL Hrs + Office Staff Regular OT Hours) * .03334
This field creates the per shift accrual based on the various payroll fields.
Does anyone have any ideas on how to stop this accrual once the YTD total reaches 40 Hours of accrual?