Hello.
I need assistance building a simple spreadsheet to track sick leave that has a 1 hour for every 40 worked accrual rate. This needs to be a rolling balance set-up so if a PT employee works 25 hours one week and 30 the next, the accrual will be triggered by the 40 hour mark and start the next 40 hour clock with the remaining 15 hours of that 2 week example. The time can be used in 1/4 hour increments and a balance has to be shown to the employee monthly. We pay once a month for hours worked and can track the sick leave hours in line with that period structure.
Thanks.
JC
I need assistance building a simple spreadsheet to track sick leave that has a 1 hour for every 40 worked accrual rate. This needs to be a rolling balance set-up so if a PT employee works 25 hours one week and 30 the next, the accrual will be triggered by the 40 hour mark and start the next 40 hour clock with the remaining 15 hours of that 2 week example. The time can be used in 1/4 hour increments and a balance has to be shown to the employee monthly. We pay once a month for hours worked and can track the sick leave hours in line with that period structure.
Thanks.
JC
