Contents of this article are applicable to the following users
Tier: CICO, ESSENTIAL, GROWTH, SCALE
Platform: Web
Access Level: Owner & Manager
When exporting individual timesheets, you might see an option that says Average out OT across worked days. Checking ✅ this box changes the timesheet calculation such that:
Staff’s overtime will be calculated based on a new overtime limit. This limit is based on their total number of worked days in the timesheet period. (See below for exact formula)
Some days staff might have worked more than their contract hours and some days they might have worked less. This option will consolidate the ups and downs in hours to reduce the final OT you have to pay.
How does it show up in the export?
Find the Averaged OT Value in the row just below Total row called Consolidation row.
How exactly does the formula work?
Example 1 (if staff daily OT limit is set):
Say that the timesheet is filtered from 1 Jan to 23 Jan (24 Days)
John worked for 17 days in that period
Daily OT limit for John is 8hrs
Now, if the option is checked, the following formula is applied instead:
Consolidated OT = (17*8 - total_hours_worked)
Example 2 (if staff daily OT limit is not set):
Say that the timesheet is filtered from 1 Jan to 23 Jan (24 Days)
John worked for 17 days in that period
Daily OT limit is not set for John
Now, if the option is checked, the following formula is applied instead:
Consolidated OT = (17*24 - total_hours_worked)