Overtime calculation sheet (Excel)
A ready Excel sheet that works out a whole team's overtime for the month: enter each employee's salary, day and night overtime hours, and the rest days and holidays worked, and it calculates the hourly rate, each kind of overtime pay and the total, with the same rates as our overtime calculator. Free, no signup.
Adding up overtime from paper sheets?
Dawmly records each employee's real check-in and check-out and totals their day and night overtime, so the numbers are ready at the end of the month. Free for up to 3 employees, no card needed, with a 14-day free trial of every feature.
Start freeNext step: Attendance app · Payroll from real attendance · Overtime calculator
What's in the file
- The monthly overtime sheet: 30 employees with salary, day and night overtime hours, and rest days and public holidays worked.
- Automatic sums: hourly rate, 135% day and 170% night overtime pay, rest-day and holiday pay, and totals per employee and for the company.
- Editable monthly hours: 208 by default (26 days × 8 hours), plus a how-to sheet with the legal articles.
How to use the overtime sheet
- Enter the month, and change the working hours a month if your contracts differ.
- Enter each employee's monthly salary.
- Enter their day overtime hours (until 9 pm) and night overtime hours (9 pm to 6 am), and the rest days and public holidays worked.
- Read each employee's total overtime and carry it to the payroll sheet.
How is overtime worked out under the labor law?
Under Article 121 of Egypt's Labor Law No. 14 of 2025, day overtime is paid at 135% of the hourly rate and night overtime at 170%, and working the weekly rest day adds a day's wage. Working a public holiday adds two days' wages (Article 129). The sheet uses these rates, with the hourly rate as salary ÷ monthly hours.
This is an estimate, not legal advice, and your contract or sector may set higher rates. For worked examples, read how to calculate overtime in Egypt.