I am trying to create a salary rule that does the following:

For every Sunday that falls between the payslip dates, count the hours worked on the previous 7 days (mon-sun). For each check, if the total is more than 40, subtract 40 to get the weekly overtime hours; else, make 0, or disregard. Sum all results and multiply by ( contract.hourly_wage * 2 ) to get the final result.

This should give the total number of hour worked over 40 hours in each calendar week that finished in this pay period.

If anyone can help or at least point me in the right direction, I'd be so grateful!