Configure overtime calculations in your timesheet templates in Dashpivot to automatically calculate overtime hours based on your organisation’s rules. This helps ensure accurate payroll reporting and consistent tracking of standard and overtime hours.
Video Walkthrough
Prerequisites
Before you begin make sure you have the following:
Plan: All Plan Types
Permission: Org Controller
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot
Step-by-Step Instructions
Open the Timesheet template in the Templates section.
Add the following columns to your default table:
Employee
Start
Finish
Break
Total regular hours
Total overtime hours
Total hours
Set up your table cell references as follows:
A1: Employee
B1: Start
C1: Finish
D1: Break
E1: Total regular hours
F1: Total overtime hours
G1: Total hours
In the Total regular hours column, enter the following calculation. This limits standard hours to 8 per day — if total worked time exceeds 8 hours, only 8 are counted as regular:
=IF(TIMEDIF(B1,C1)-D1>8,8,TIMEDIF(B1,C1)-D1)In the Total overtime hours column, enter the following calculation. This captures any hours worked beyond 8, returning 0 if the total is within the standard threshold:
=IF(TIMEDIF(B1,C1)-D1>8,TIMEDIF(B1,C1)-D1-8,0)