Overtime and premiums in Colombia

v1Ejemplo de AXIOMA
What overtime, night work and Sundays and holidays pay, under the 2025 labour reform rules.
ProyectarCalcular en lote

Composición del método

Las fórmulas se ejecutan de arriba abajo. Un paso usa el resultado de otro anterior cuando lee una variable con el mismo nombre.

Entradas
  • Monthly salary
  • Ordinary hours in the month
  • Daytime overtime hours
  • Night overtime hours
  • Ordinary hours at night
  • Ordinary Sunday or holiday hours, by day
  • Ordinary Sunday or holiday hours, at night
  • How the Sunday is made up for
  • Sunday and holiday premium (%)
  • Sunday or holiday overtime, by day
  • Sunday or holiday overtime, at night

  1. Paso 1: Fórmula Value of an ordinary hour

    Usa
    • Monthly salaryentrada
    • Ordinary hours in the monthentrada
    Produce
    valor_hora

  2. Paso 2: Fórmula Daytime overtime

    Usa
    • Daytime overtime hoursentrada
    • Value of an ordinary hourdel paso 1
    Produce
    extra_diurna

  3. Paso 3: Fórmula Night overtime

    Usa
    • Night overtime hoursentrada
    • Value of an ordinary hourdel paso 1
    Produce
    extra_nocturna

  4. Paso 4: Fórmula Night premium

    Usa
    • Ordinary hours at nightentrada
    • Value of an ordinary hourdel paso 1
    Produce
    recargo_nocturno

  5. Paso 5: Fórmula Sundays and holidays

    Usa
    • Ordinary Sunday or holiday hours, by dayentrada
    • Ordinary Sunday or holiday hours, at nightentrada
    • How the Sunday is made up forentrada
    • Sunday and holiday premium (%)entrada
    • Value of an ordinary hourdel paso 1
    Produce
    dominical

  6. Paso 6: Fórmula Sunday and holiday overtime

    Usa
    • Sunday or holiday overtime, by dayentrada
    • Sunday or holiday overtime, at nightentrada
    • Sunday and holiday premium (%)entrada
    • Value of an ordinary hourdel paso 1
    Produce
    extra_dominical

  7. Paso 7: Fórmula Total on top of the salary

    Usa
    • Daytime overtimedel paso 2
    • Night overtimedel paso 3
    • Night premiumdel paso 4
    • Sundays and holidaysdel paso 5
    • Sunday and holiday overtimedel paso 6
    Produce
    total_recargos
Resultados
  • valor_hora
  • extra_diurna
  • extra_nocturna
  • recargo_nocturno
  • dominical
  • extra_dominical
  • total_recargos

PruebaEjecutar método
Listo
Asigna valores a las entradas del método y comprueba lo que produce cada paso.
Valores de entrada
salario
horas_mes
horas_extra_diurnas
horas_extra_nocturnas
horas_nocturnas
horas_dominicales_diurnas
horas_dominicales_nocturnas
compensacion_dominical
Paid in money
recargo_dominical
horas_extra_dominicales_diurnas
horas_extra_dominicales_nocturnas
Resultadototal_recargos
Ejecuta el método para ver el resultado.

How it is worked out

Work out overtime, night and Sunday premiums in Colombia with the 42-hour week and the 90 % Sunday premium in force since July 2026.

Every hour is paid on the value of an ordinary hour: the monthly salary divided by the hours in the month, 210 with the 42-hour week. Daytime overtime is worth 25 % more, night overtime 75 % more, an ordinary hour at night carries a 35 % premium and one on a Sunday or public holiday 90 % since 1 July 2026. Sunday premiums add up with the overtime and night ones.

The formulas that run, in order

  1. Value of an ordinary hourvalor_hora = salario / horas_mes
  2. Daytime overtimeextra_diurna = horas_extra_diurnas * valor_hora * 1.25
  3. Night overtimeextra_nocturna = horas_extra_nocturnas * valor_hora * 1.75
  4. Night premiumrecargo_nocturno = horas_nocturnas * valor_hora * 0.35
  5. Sundays and holidaysdominical = valor_hora * (horas_dominicales_diurnas * ((compensacion_dominical == "dinero" ? 1 : 0) + recargo_dominical / 100) + horas_dominicales_nocturnas * ((compensacion_dominical == "dinero" ? 1 : 0) + recargo_dominical / 100 + 0.35))
  6. Sunday and holiday overtimeextra_dominical = valor_hora * (horas_extra_dominicales_diurnas * (1.25 + recargo_dominical / 100) + horas_extra_dominicales_nocturnas * (1.75 + recargo_dominical / 100))
  7. Total on top of the salarytotal_recargos = extra_diurna + extra_nocturna + recargo_nocturno + dominical + extra_dominical

Each formula reads what the earlier ones produced, by its name. The fields arrive with an example filled in: put your own numbers in and run it again.

What if the calculation were yours?

This calculator is not hand-written: it is an Axioma method, formulas that run one after another. Open it to see every step, adapt it to your case or run it for a whole payroll from a spreadsheet.

Open this method in the editor

What each extra hour is worth on a 2 million salary

With the 42-hour week in force since 15 July 2026, a month has 210 ordinary hours: 7 a day for 30 days. On a salary of 2,000,000 pesos an ordinary hour is worth 9,523.81 pesos, and everything else follows from it: an hour of daytime overtime is worth 11,904.76 and one of night overtime 16,666.67.

Ten hours of daytime overtime, four at night, eight ordinary hours at night and an eight-hour Sunday paid in money come to 357,142.86 pesos in the month: 119,047.62 for daytime overtime, 66,666.67 for night overtime, 26,666.67 of night premium and 144,761.90 for the Sunday.

What the 2025 labour reform changed

Law 2466 of 2025 moved the start of the night to 7 p.m. from 25 December 2025; it used to start at 9 p.m. An ordinary hour between 7 p.m. and 6 a.m. carries the 35 % night premium, which is not added to night overtime: that hour is already worth 75 % more.

The premium for working on a Sunday or public holiday rises in stages: 80 % from 1 July 2025, 90 % from 1 July 2026 and 100 % from 1 July 2027. A company may pay more sooner. That is why the percentage is a field: on 1 July 2027 it is enough to type 100.

Sundays and holidays: money or a day off

Someone who works an occasional Sunday, up to two in the month, chooses between being paid for it or taking a compensatory day off. Paid, the hour carries the 90 % premium, 1.9 times an ordinary hour; with the day off, only the premium is paid in money, because the free day pays the hour. For 8 hours that is 144,761.90 or 68,571.43 pesos.

Someone who works Sundays regularly, three or more in the month, gets full pay and the day off as well. Overtime on a Sunday adds both premiums: daytime Sunday overtime is worth 2.15 times an ordinary hour and night Sunday overtime 2.65 times.

Which divisor to use, and who is left out

No law sets how many hours the salary is divided by. Payroll practice uses 210 for a 42-hour week, as the Ministry of Labour’s 2023 unifying opinion did, but an opinion of the same ministry in March 2026 put it at 182 (42 × 52 / 12), which makes each hour dearer: 10,989.01 pesos on 2 million. The field takes either.

Managers and positions of trust have no overtime, though they do get night, Sunday and holiday premiums. An all-inclusive salary already makes up for all of it unless the contract says otherwise. And nobody may work more than 2 hours of overtime a day or 12 a week.

Frequently asked questions

How much is an hour of overtime worth in Colombia in 2026?
Daytime overtime pays 125 % of an ordinary hour and night overtime 175 %. On the 2026 minimum wage and 210 hours a month, the ordinary hour is 8,337.64 pesos, daytime overtime 10,422.05 and night overtime 14,590.88.
When does night work start in Colombia?
At 7 p.m., until 6 a.m., since 25 December 2025, when the change made by Law 2466 of 2025 came into force. Before that, the night started at 9 p.m. Every ordinary hour in that window carries a 35 % premium on the ordinary hour.
What is the Sunday premium in Colombia in 2026?
80 % until 30 June 2026 and 90 % from 1 July 2026; from 1 July 2027 it will be 100 %. It is added to the overtime or night premium: an hour of night overtime on a Sunday is worth 2.65 times an ordinary hour.
How many hours of overtime can be worked in a day?
Up to 2 a day and 12 a week, under article 22 of Law 50 of 1990 as the labour reform left it. Private security and the health sector have exceptions, and managers and positions of trust have no overtime at all.