In order to correctly calculate the overtime, it is essential that the administrator has full knowledge of the relevant labor legislation or use a reliable tool to assist him in this task. One of the topics that most requires attention is the night work, which presents some peculiarities that must be well understood within the payroll calculation. Understand now how the extra night works and learn how our Extras-Time Calculation Worksheet can help you control the spreadsheet in your company.
Rules of Night Addition
The nightly surcharge is a right guaranteed by the Federal Constitution of 1988, more precisely in Article 7 of Chapter II. Its guidelines are established by the Consolidation of Labor Laws - CLT, the main legislative source of the area in force in Brazil. In the first place, it should be noted that the legislation considers night time, in urban terms, the period from 22: 00 to 05: 00.
Once you know the time interval that falls as night work, the next step is to check what the legislation provides for the hours worked in this period. The CLT stipulates that the remuneration of the night worker must be increased by at least 20% in relation to the daytime hours. Another factor of extreme importance is that the duration of this hour is computed differently. Instead of conventional 60 minutes, the night time, for work purposes, has 52 minutes and 30 seconds. In the end, this reduction makes the workday is seven hours, thus compensating for the natural biological wear that the night shift causes in the worker.
Calculating nighttime overtime
To better understand the calculation of overtime in night work, let's work from a hypothetical situation. In our example, an employee whose journey ranges from 15: 00 to 21: 00 worked, on a given day, up to 23: 00.
When organizing the data related to the hours worked, we have the normal working day, which in this example is six hours, an extra hour worked in the daytime period and an extra hour worked in the night period.
Calculating the overtime worked from 21: 00 to 22: 00 obeys the simple calculation system. Already the period worked from 22: 00 to 23: 00 fits in the rules of the night time, in which, as we have already seen, the time corresponds to 52 minutes and 30 seconds. Doing the conversion, we realize that the night time equals 1,14286 of the normal time.
To calculate the value, we will follow the following steps:
- Apply the nightly surcharge of 20% to the value of the time worked;
- Calculate the overtime based on this value (worked hour + additional night);
- Finally, apply the equivalent night time index, to get the correct value. That is, multiply the value obtained by 1,14286. With this, we will get the effective value of 22 worked-over time: 00 to 23: 00, in this example.
How to perform an efficient overtime control
Initially, on the "general premises" tab, employees are recorded, detailing their base salary and working hours, as well as defining the percentage applied for each type of overtime and how these hours are paid. This information must be accurately posted so that the calculations are performed correctly.
In the second tab, "monthly launches", the working day must be recorded by employees individually, each day. We can see in the right part of the image that the worksheet automatically gives a summary of the hours worked in the month, including the amount due, according to the information recorded in the previous tab. In the case of night hours, the conversion is also done automatically.
The other tabs are focused on information management, providing consolidated results, charts and reports, and issuing alerts and tips from the numbers obtained.
The control of overtime is very important in the management of a company's human resources, and the correct application of legal devices, such as nighttime add-on, must be strictly followed. Meet our spreadsheet 3.0 and avoid problems in your company!