Punch-in clock broken at work - need to address pay discrepancies

Hello,

The time tracker at work is on the fritz and now we have to reconcile instances in which workers' time was under reported or over reported. Then we have to correct their pay.

There are three important contingencies:

1. On weekdays, workers can work no more than 7 hours before overtime pay is allotted.
2. On weekends, they can work 8 hours before overtime pay is allotted.
3. Note that in some cases (see rows 8 and 18 for examples) a worker was shorted time that requires both regular pay and overtime pay.

I'm open to ideas for how to arrange this neatly and accurately. The attached sheet is a very small example (real names are changed) but there are hundreds of employees affected.

Thank you for suggestions!

It works! Thank you, Bernie. That was only a simplified sample sheet, so I'll try on my own to translate your formula to the real sheet. Then, I'll officially label this one solved.