This 100% free online overtime calculator allows you to download a dynamically calculated overtime table.
How to calculate overtime?
This question frequently arises for employees or HR managers who are legally required to calculate overtime hours worked beyond 35 hours per week, or any other weekly work threshold.
This free overtime simulator allows you to estimate your weekly overtime hours.
It also enables you to apply overtime premiums according to the rules set by your collective agreement.
This 100% free online tool offers several ways to calculate overtime:
1) You can directly enter the total hours worked per week.
2) You can use the advanced hourly calculation mode to record overtime hours by specific dates.
3) The simulator also offers a timesheet and activities mode, allowing you to log hours by date, and the tool automatically calculates overtime.
These options make it easy to integrate the following parameters:
Consideration of night hours.
Overtime calculation for specific days, e.g., Sundays or public holidays.
the ability to define the time entry method, namely declaring hours in a cumulative way, or by specifying the start time and end time.
PDF export of results for HR tracking.
Overtime Simulator and Use Cases
More than just an overtime calculation simulator, JOUROFF, a time tracking solution provider, offers you an online timesheet that works like a calculator to add up actual working hours. Whether you are an HR manager, accountant, or employee, this tool allows you to run time calculation simulations by integrating multiple configuration options, depending on the different employee contracts.
Indeed, since time reporting involves HR rules that vary from one company or employee to another, this tool provides several options for calculating working hours.
Calculating Overtime Based on Total Hours Worked
You can enter the total weekly hours worked by the employee.
This option avoids recording hours day by day.
The simulator then calculates overtime based on the total hours entered.
Overtime Simulator – Hourly Entry by Date
The calculation of overtime can be carried out either for compensation purposes based on the employee’s hourly wage, or for time-off recovery.
In both cases, it is essential to be precise about the time tracking performed by the employee.
This is why the overtime simulator offers an option to enter hours by date.
This calculation method provides greater accuracy regarding dates and time slots.
In cases where overtime premiums must be applied to night hours or public holidays, accuracy is crucial.
In a standard case of overtime premium calculation, time brackets are taken into account.
For example, hours worked between 35 and 43 hours are increased by 25%, and beyond 43 hours, the increase is 50%.
A simulation for an employee with a 35-hour weekly contract would look like this:
(1) Declared weekly hours: 39h
> Gross overtime hours for Threshold_1 = 39 – 35 = 4h
> Overtime premium = 4 × 25/100 = 1h
> Total overtime = 4 + 1 = 5h
(2) Declared weekly hours: 45h
> Overtime for Threshold_1 = 43 – 35 = 8h
> Overtime for Threshold_2 = 45 – 43 = 2h
…The employee worked 10 hours of gross overtime
> Overtime premium = (8 × 25/100) + (2 × 50/100) = (2) + (1) = 3
> Total overtime = 10 + 3 = 13h
It should be noted that these premium rates do not apply the same way in all companies, as they depend on each collective agreement or company agreement, which should be carefully reviewed.
The overtime simulator performs these time calculations automatically, and you can then export the results into a PDF file for internal use within your company.
Overtime and Work Contracts
The overtime simulator allows you to enable the tracking of actual working hours while ensuring the calculation of overtime triggered by exceeding the weekly threshold.
Indeed, this overtime calculation and premium simulator gives HR managers the ability to evaluate working hours and analyze the activities that form the basis of overtime calculation.
This helps maintain control over HR time management processes while also analyzing key indicators for operational performance.
This feature gives the overtime simulator the dimension of an online timesheet and activity tracking tool.
As a result, any company can use this free calculator as a real time entry tool within the organization.
Advanced Calculation Mode
To take into account the specific needs of each company, the overtime simulator offers two time entry methods: either cumulative daily hours or by specifying the start time and end time.
In both cases, the timesheet provides the total number of hours worked per week. Like a real online calendar, this overtime simulator allows you to navigate by month or year to allocate entries to the week of your choice.
Calculation of additional hours
This calculator also allows for the calculation of additional hours.
As a reminder, additional hours are hours worked by a part-time employee beyond their contractual hours.
These differ from overtime in terms of legal framework and hourly quota (cap).
However, the calculation principle is the same: on one side, the weekly hours specified in the contract, and on the other, the application of a threshold to determine hours beyond the contractual hours.
In any case, the calculator allows you to dynamically define thresholds and premiums according to the type of contract.
Overtime calculation – gross and net hourly rate
The purpose of the overtime simulator is to provide you with a record of hours and overtime without applying the wage rate.
In other words, the simulator provides the hourly indicators… it is up to you to apply your wage rate to estimate your pay for overtime hours.
However, the calculator provides results in the form of a summary table of gross overtime hours before applying the premium thresholds, as well as overtime hours with premiums by time band.
Overtime calculation: how does it work?
Overtime threshold for calculating hours worked on Sundays
Overtime threshold for calculating hours worked on public holidays
Overtime threshold for night hours and overtime premiums
Weekly overtime threshold for compensatory time off
Weekly overtime threshold for payable overtime
In some collective agreements, overtime hours are systematically paid.
In this case, the calculator does not activate compensatory time off.
Example of overtime calculation rule:
> From 35 h to 43 h => hours are to be compensated (compensatory rest)
> Beyond 43 h => payment of overtime based on the contractual hourly rate
It is clear that the organization of hours in HR management varies according to each company’s constraints.
Therefore, to calculate overtime, this online overtime simulator offers two calculation methods.
(1) Using the timesheet and activities to calculate overtime:
In this method, employees enter hours week by week.
At the same time, the overtime calculator accounts for the overtime hours.
The advantage of weekly entry is that the timesheet can be used to manage annualized hours, but only if your company manages employees with annualized contracts.
Annualized hour accounting is a distinct HR area.
This concerns companies with seasonality and activity variations. In this context, hours can be adjusted according to periods of high or low activity throughout the year.
It should be noted that modulation requires the implementation of a modulation agreement within the company.
(2) Calculating overtime from direct employee declaration:
To avoid overloading the overtime calculation process, employees can directly report the overtime hours they believe they have worked, week by week.
This calculation method avoids entering total weekly hours.
However, the HR manager can reject the timesheet or simply validate it if the hours are accurate.
Features of the online overtime calculation tool
HR Settings
Scope of application
Contractual hours. Example: 35 h (weekly working hours)
Overtime calculation requires declaring the number of hours to be worked per week. This allows the employee to fill in their timesheet so that the calculation tool can automatically compute the overtime hours.
The automation system for overtime relies on the configuration of overtime thresholds.
For example, if the employee’s contract stipulates 35 hours per week:
(1) Total hours entered = 39 hours
Overtime calculation for Threshold-1 = 39 h – 35 h = 4 h
Overtime with premium = 4 h × (25/100) = 1 h
Total overtime = 4 h + 1 h = 5 h
The total overtime hours multiplied by the current hourly wage, for example €8/h…
Thus, the salary due for overtime = 5 h × €8 = €40
(2) Total hours entered = 45 hours
Overtime for Threshold-1 = 43 h – 35 h = 8 h
Overtime for Threshold-2 = 45 h – 43 h = 2 h
This gives 10 hours of gross overtime
Premium overtime = 8 h × (25/100) + 2 h × (50/100) = 2 h + 1 h = 3 h
Total overtime = 10 h + 3 h = 13 h
This total overtime can be multiplied by the hourly wage, for example €8/h…
Salary due for overtime = 13 h × €8 = €104
Our overtime calculation simulator allows tracking of hours worked over the year. This is for managing annualized hours.
In this case, annual indicators to track include: scheduled hours, hours worked, and remaining hours to be worked.
