How to calculate the Overtime? See Examples!

Additional Night: Learn how it works and how to use an overtime control worksheet
Excel Spreadsheets

In a work contract of 8 hours per day, 6 days a week, a worker fulfills about 220 hours per month. By dividing your salary by 220, you will discover your hourly wage. This value, added to an increase of 50%, legal percentage of overtime, is the value of each of the extra hours fulfilled.

For, work overtime correctly, you need to know:

  • Overtime types (normal, compensated, holiday, night, etc.)
  • Extra percentage paid for each type
  • Number of hours worked in the month
  • Quantity of overtime worked in the month

Excel overtime calculation spreadsheet banner

Before entering into the calculation itself, let's see what it is and why to <a href="">calculate overtime</a> in your business:

  • What is it: Overtime is all work time that employees perform outside the usual scale. Overtime usually occurs due to the need for specific job conclusions. 

  • Why calculate: Business management includes a number of factors that are not always entirely clear, especially for beginning entrepreneurs. Among these factors appears the calculation of overtime, which may seem very simple, but which offers risks to the company's health. Many labor claims arise from an overtime calculation error within the payroll, or, simply by negligence of that management.

And you who are starting your venture, already know how to count and calculate overtime of your employees? Stay tuned for this little tutorial and get your doubts about this key element in running the business.

Calculate Overtime: What do I need to know?

1. Calculate the number of hours worked in the month

Before starting an employment contract, you must establish the number of hours worked in the month. The CLT (consolidation of labor laws) foresees the maximum of 220 monthly hours distributed on weekdays. If a holiday occurs during the month, the day is counted normally, so if you work on that day, the company must pay overtime to the employee.

Banner Overtime Calculation Worksheet

2. Concept of overtime

Any time that the employee is at the service of the company and exceeds the monthly work limit is considered overtime. However, not all overtime has the same weight or value. Thus, the overtime worked on normal employee days has an increase of a certain percentage. Hours on extraordinary days, regardless of the accumulation of service or force majeure, will have a higher percentage increase in the value of overtime.

3. What is the percentage in the overtime calculation?

To facilitate the calculation of overtime, we will use the values ​​defined by the CLT. These values ​​correspond to 50% increase over the hour value on normal days that only exceed the employee's departure time. Already, for days that require the extraordinary displacement in the service of the company, the percentage is of 100%.

How to use time bank - hours bank system

4. Types of Overtime

It's important that you know what the possible overtime is:

  • Normal
  • Compensated
  • Holiday
  • break (before 11 hours of rest)
  • Intrajornada (during rest time / lunch)
  • Normal night
  • Compensated night
  • Night time holiday
  • DSR (Paid Weekly Break)
  • DSR Night

How to calculate overtime

Let us suppose the following situation. Employee A works on the CLT scheme for 220 monthly hours distributed from Monday to Saturday. The salary of A is $ 1200. In this way the calculation is as follows:

Step 1: Calculate the value of the time worked

This calculation is simple, just take the monthly salary and divide by the number of hours, which is. In this example, 1200/220, the value found is 5,46.

2: Calculate the Overtime Value on Normal Days

The overtime value is the value of the time worked, in the 5,46 case, plus 50%. The value found is 8,19.

3 Step: Calculating the Overtime Value for Holidays, Saturdays, and Sundays

The same as the previous calculation. But in this case the increment is 100%. The value found is 10,92.

Excel overtime calculation spreadsheet banner

Once this is done, simply add the overtime worked on normal days and multiply by 8,19 and the hours worked on extraordinary days by 10,92 and add to the salary of the employee.

How to use hour bank - summary of overtime of the month

Step 4: Items that may affect your overtime calculation

Usually one should calculate overtime from an employee's gross salary. It turns out that this gross salary may be increased depending on the type of activity it performs and this can affect the value of the overtime. Therefore, before arriving at the final value of the hour, find out if these items affect the salary of the employee:

Tips for calculating overtime

  1. All overtime is reflected in vacation payments and thirteen first salary.
  2. The INSS and other discounts as well as FGTS payment are made on the gross salary, ie, salary plus overtime.
  3. In collective bargaining agreement between companies and category unions there may be other values ​​for extra overtime. It is important to pay close attention to this factor.

Did you see how important it is to calculate overtime correctly? The has launched a Extra Time Calculation Worksheet especially for your function! Get this tool already and get organized successfully!

Excel overtime calculation spreadsheet banner

Excel Spreadsheets



Please, write your comment
Please enter your name