Skip to main content
Dawmly

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 free

Next step: Attendance app · Payroll from real attendance · Overtime calculator

What's in the file

How to use the overtime sheet

  1. Enter the month, and change the working hours a month if your contracts differ.
  2. Enter each employee's monthly salary.
  3. 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.
  4. 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.

Frequently asked questions

Is the overtime sheet free?

Yes, completely free with no signup. It works in Excel, Google Sheets and LibreOffice.

What are the overtime rates under the new labor law?

135% of the hourly rate for day overtime and 170% for night overtime, under Article 121 of Labor Law No. 14 of 2025.

How is the hourly rate worked out?

Monthly salary ÷ working hours a month. The sheet uses 208 hours (26 days × 8 hours) by default, and you can change it.

Does it cover work on public holidays?

Yes. Working a public holiday adds two days' wages (Article 129), and working the weekly rest day adds one (Article 121).

Keep reading