Overtime rules

Last updated - Sep 08, 2022 at 9:20AM

TimeDock records the clock IN and clock OUT times for each employee to provide hours worked, in real-time. By default, these hours are not split between regular and overtime.

When required (and if compatible), TimeDock can build and apply custom overtime rules to exported data. This means that employee hours can be split between regular and overtime hours and applied to exported data either within a custom CSV template, or one of the supported payroll apps that TimeDock integrates with. When being applied to an integrated payroll app, that app must support the ability to import overtime hours.

Overtime rules are executed and applied to exported data only. Overtime hours are not visible within the web dashboard data.


Payroll export

If your payroll app is included in the TimeDock list of integrated apps, and it supports the option of importing overtime hours, it may be possible to apply custom overtime rules to your payroll export.

After an initial consultation with you regarding your overtime rules, and providing they're within the scope of what TimeDock supports, we will provide you with a document detailing your rules for sign-off. Once the document is signed-off, we will implement your overtime rules specifically for your account and for your selected payroll export.

Once implemented, when you export your timesheets to your payroll app, any overtime hours will be automatically split out.

Example:

Raw exported data

Employee Date Pay Type Hours
John Doe 01 Aug, 2022 Normal 7.5
John Doe 02 Aug, 2022 Normal 8.75

Exported data with overtime applied after 8 hours in a day

Employee Date Pay Type Hours
John Doe 01 Aug, 2022 Normal 7.5
John Doe 02 Aug, 2022 Normal 8
John Doe 02 Aug, 2022 Overtime 0.75


Contact support@timedock.com to discuss your overtime requirements.

Implementation of custom overtime rules for payroll export will incur a one-off setup fee.


Custom CSV export template

Depending on your requirements, we may be able to build a custom CSV export template into your account, with your choice of columns, and with custom overtime calculations applied to the exported timesheet data.

After an initial consultation with you regarding your overtime and template requirements, and providing it's within the scope of what TimeDock supports, we will provide you with a document detailing your rules and template for sign-off. Once the document is signed-off, we will build and add your custom export template to your account.

Once implemented, you'll be able to access your export template by navigating to Export > Custom CSV, click on the From Template option, and click on your template name from the list to export.

Example:

Exported data template with overtime applied after 8 hours in a day

Employee Date Project Activity Normal Hours Overtime Hours Doubletime Hours
John Doe 01 Aug, 2022 Auckland Depot Framing 7.5 0 0
John Doe 02 Aug, 2022 Auckland Depot Framing 6 0 0
John Doe 02 Aug, 2022 Auckland Depot Welding 2 0.75 0


Contact support@timedock.com to discuss your overtime requirements.

Implementation of a custom CSV export template with overtime rules will incur a one-off setup fee.


D.I.Y using Excel macro

If you export timesheets to a file (Excel, CSV, TXT), you can create an Excel macro to automatically apply overtime rules to your exported data.

An Excel macro records styles, formatting and forumlas in a spreadsheet, and saves it as a procedure to run on any future spreadsheets. That means that you only need to record writing your overtime rules once, and then you can simply run your saved macro on your timesheet export files to automatically apply the calculations.

Follow these steps to create an overtime macro:

  1. Download your timesheet file to payroll or custom CSV.

  2. Open the file in Excel. If the file doesn't automatically open in Excel, open a new Excel workbook, click on the Data tab in the top ribbon, then click From Text/CSV and follow the steps in the wizard. Excel import data from file

  3. Enable the Developer tab by following these instructions: https://support.microsoft.com/en-us/topic/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45

  4. Click on the Developer tab in the top ribbon, then click Record Macro. Excel record macro

  5. Give your macro a name, and ensure you choose to store the macro in Personal Macro Workbook. Click OK. Excel new macro

  6. Use Excel formulas to calculate overtime based on the Hours column, and apply any formatting such as adding/renaming columns.

  7. Once you've finished applying your overtime calculations and formatting to the spreadsheet, click on Stop Recording in the Developer tab. Excel stop recording macro

Follow these steps to run your overtime macro on exported timesheets:

  1. Download your timesheet file to payroll or custom CSV. Note this file must be in the same format that your macro was recorded for.

  2. Open the file in Excel. If the file doesn't automatically open in Excel, open a new Excel workbook, click on the Data tab in the top ribbon, then click From Text/CSV and follow the steps in the wizard. Excel import data from file

  3. Click on the Developer tab in the top ribbon, then click Macros. Excel macros

  4. Ensure that you've chosen macros in All Open Workbooks, click on your macro name from the list, then click Run. Excel run macro

  5. Your overtime calculations and formatting will be automatically applied to the spreadsheet data.

Example:

Exported data in Excel before running macro

Excel data before macro

Exported data in Excel after running macro

Excel data after macro