Manpower Ledger Book a demo

OT Calculation in UAE for Site Workers, With Excel

The law's overtime rules fit on half a page. Applying them to forty workers on five sites is where offices slip. Here are the rates, the limits, one worked example and the Excel formulas.

In short
  • Normal working hours in the UAE's private sector are 8 a day or 48 a week.
  • An overtime hour is paid at the basic wage for that hour plus at least 25 percent, or plus at least 50 percent between 10 pm and 4 am.
  • Work on the rest day earns another rest day in its place, or the basic wage plus at least 50 percent.
  • Overtime may not pass two hours a day, with exceptions, and total working hours may not pass 144 in three weeks.

The rules in one table

These come from the UAE's labour law, Federal Decree-Law No. 33 of 2021, and from the government's portal. The percentages are minimums: a contract may give more, never less.

Hours What the law gives
Normal hours 8 hours a day or 48 hours a week
An ordinary overtime hour The basic wage for the hour, plus at least 25 percent
An overtime hour between 10 pm and 4 am The basic wage for the hour, plus at least 50 percent. This does not apply to workers on shifts
Work on the weekly rest day Another rest day in its place, or the wage for the day plus at least 50 percent of the basic wage
Work on a public holiday Another day off in its place, or the wage for the day plus at least 50 percent of the basic wage
During Ramadan The working day is two hours shorter

Two words in that table do a lot of work.

Basic wage. Overtime is counted on the basic wage, without allowances such as housing or transport. For a worker with an hourly rate and no allowances, the hourly rate is the base.

At least. The law sets a floor. If your contract with the worker promises 50 percent on every overtime hour, you owe 50 percent.

The limits

  • Overtime may not be more than two hours a day, except in the cases the law's regulations allow.
  • Total working hours may not be more than 144 hours in any three weeks.
  • After five hours of work in a row a worker is due a break, and the breaks of a day add up to at least one hour. Breaks are not working hours.
  • From 15 June to 15 September, work in the open sun stops between 12:30 and 3 pm. This is the midday break.

The law's regulations list the few kinds of worker who are outside these rules. Site workers are not among them.

Look at the second limit again. 144 hours is three weeks of 48 hours. A worker on six eight-hour days is already at it, so overtime in every week goes over. Three weeks like the example below would be 159 hours. Ask your PRO how the limit is applied to your sites before you plan regular overtime.

A timesheet that shows a worker at 12 hours a day for a whole month is therefore more than a salary question. It is a record, signed by the customer, of hours beyond the limit. Notice it when the sheet arrives, not when an inspector does.

A worked example

Imran is a pipe fitter with a basic hourly rate of AED 10.00. The figures are made up. This is one of his weeks.

Day Hours worked Normal Overtime
Monday 8 8 0
Tuesday 10 8 2
Wednesday 10 8 2
Thursday 8 8 0
Friday (rest day) 0 0 0
Saturday 9 8 1
Sunday 8 8 0
Week 53 48 5
Line Working Amount (AED)
Normal hours 48 h × 10.00 480.00
Overtime hours at the basic rate 5 h × 10.00 50.00
Overtime extra 5 h × 10.00 × 25% 12.50
Pay for the week 542.50

Said in another way: each overtime hour is worth 1.25 times the basic hour. Five hours times 12.50 is 62.50, the same as 50.00 plus 12.50.

If two of those overtime hours had been worked after 10 pm, they would carry 50 percent instead of 25: 2 × 10.00 × 1.5 = 30.00 for those two hours.

The Excel formulas

Suppose the hours of one worker's month are in cells F9 to AJ9, one cell for each day, with an A on absent days. The basic hourly rate is in AP9.

What you want Formula
Overtime hours of one day (hours in B2) =IF(ISNUMBER(B2),MAX(0,B2-8),0)
Overtime hours of the month =SUMIF(F9:AJ9,">8")-8*COUNTIF(F9:AJ9,">8")
Normal hours of the month =AK9-AL9 with the total hours in AK9 and the overtime hours in AL9
Pay for normal hours =(AK9-AL9)*AP9
Pay for overtime hours =AL9*AP9*1.25

The second formula works because SUMIF and COUNTIF skip the cells that hold an A. It adds up the days above eight hours, then takes eight off for each of those days.

Two limits of these formulas. They count overtime by the day. If your contract counts it by the week, above 48 hours, you need a weekly sum instead. And they treat every overtime hour as an ordinary one: night hours and rest-day hours need their own columns on the timesheet. The free timesheet format has a column for rest-day hours.

Ramadan

During Ramadan the working day is two hours shorter. It is commonly read like this: a worker whose normal day is eight hours has a normal day of six, and the hours beyond six count as overtime. If your sites work different hours in Ramadan, say so on the timesheet, so that the office does not apply the eight-hour rule out of habit.

What manpower supply offices get wrong

One flat rate for all hours. Some companies agree a single hourly rate with the worker and pay every hour at it. If the worker does overtime, check that what he gets is not below the law's minimum for those hours.

The customer pays overtime, the worker does not get it. Your charge rate and your pay rate are two separate agreements. What the customer pays you for overtime does not decide what you owe the worker. The law does.

Overtime counted on the wrong base. It is counted on the basic wage. Counting it on the full package costs you money; counting it on less than the basic wage is underpayment.

Nobody separated the hours. A sheet that shows only "10" for a day cannot tell you whether two of those hours were at night. If night work happens on your sites, the sheet needs a place for it.

Questions people ask

How is overtime calculated in the UAE?

Take the basic wage for one hour and add at least 25 percent for each overtime hour, or at least 50 percent for overtime between 10 pm and 4 am. A worker with a basic hourly rate of AED 10 gets at least AED 12.50 for an ordinary overtime hour.

How many hours of overtime are allowed?

Not more than two hours a day, apart from the exceptions in the law's regulations, and total working hours may not pass 144 in any three weeks.

Is overtime calculated on basic salary or total salary?

On the basic wage. Allowances are not part of the base.

How is work on Friday or the rest day paid?

The worker gets another rest day in its place, or the wage for that day plus at least 50 percent of the basic wage. The rest day is the one in the contract; it does not have to be Friday.

How do I calculate overtime in Ramadan?

The normal day is two hours shorter in Ramadan. Hours beyond the shorter day are commonly treated as overtime, at the same rates as in the rest of the year.

Sources

  1. The UAE Government portal, Working hours, updated 12 August 2026.
  2. Federal Decree-Law No. 33 of 2021 on the Regulation of Employment Relationships, Articles 17 to 19 and 28, in the English translation published on the UAE Government portal (the text of January 2022).
  3. The UAE Government portal, Health and safety at the workplace, updated 24 September 2026.

This guide explains the rules as we read them on 19 November 2026. Rules change, and your bank or exchange house may ask for more. It is not legal advice: for a decision that matters, check with the authority concerned, your PRO or your accountant.

See it with your own timesheet

Send us one sheet from one of your sites. In a short call we show you your own hours, read and worked out into salaries.

Book a demo