I'm trying to automate calculation of overtime pay for employees.
Employee timesheets are exported from our time system as Excel spreadsheets.
They contain two weeks of data. Each day of the week might have multiple time entries. Here's an example of part of a spreadsheet:
<tbody>
Date...