Need Suggestion on Absence Requirement

Content

Currently we have a set of population who are niether using  cloud time(time data flows from legacy to cloud), payroll of these population is also not run in cloud, Absence is handled using sheets. Another set of population uses absence managment , time flows from 3rd party system

Future state

1. This population will enter absence is cloud

2.Payroll will be calculated in cloud.(Currently payroll is not in cloud)

The payroll requirement is to grant an employee 1 hour of Sick time per every 40 hours worked. For example, if a driver works 40 hours this week, he would accrue 1 hour of sick time. If he works 60 hours this week, he would accrue 1.5 hours of Sick time. If he worked 20 hours this week, he would accrue 0.5 hours of Sick time.