Daily and Weekly Overtime formula

Hi everyone - I just joined today, as I have come to the conclusion that I am wasting my time and should just ask for help from all of you.

I am trying to create a formula to check the compliance to an overtime policy. Per the contract, the work week runs from Monday to Sunday, and the regular work week is 10 hours per day, Mon - Thursday, 40 hours per week. Anything over 10 hours per day or 40 hours per week would be overtime. I have 3 years of data to analyze, with hundreds of employees, and I need to figure out the amount of overtime that should not have been paid for each employee, for each week. UGH.

The data that I have been provided is in the attached format document after being sanitized for all relevant proprietary and private information of course!)

I was thinking that as the overtime needs to reset each week, that I need to have a weeknum in there somewhere, but I am quite lost as to how to tackle this!

Any assistance would be greatly appreciated!!