Hi I am trying to create a formula for part-time/full-time employees sick time accrual. The employee will get 1 hour for every 30 hours worked. I have a spreadsheet set-up that calculates that one line, but doesn't calculate the lines below to keep adding each line until it reaches 30 hours to earn that sick hour.
I have attached a screen shot of the spread sheet i have made so far. I am not sure If i am making sense.
Can anyone help? The rules are: every 30 hours worked= 1 hour; may carry-over 40 hours the next year (years are starting on 1/1 payroll period (monday thru sunday paid weekly every friday).
sickaccrual.jpg
Bookmarks