Absence Accrual Matrix formula with vesting period, look back days and accruals based on every hour

Summary:

Absence Accrual Matrix formula with vesting period, look back days and accruals based on every hour worked.

Content (please ensure you mask any confidential information):

Hello all,

I have requirement to accrue the balance of 0.034 for every hour worked, but this has a vesting period of 90 days and look back days of 90 and Maximum accrual of 72hrs /Year.

Look back days is the first shift worked across all legal entities and jurisdictions. Can we achieve this using Accrual Matrix formula?? If yes, could you please let me know the parameters that can be used for Look back days in the formula.