Calculadora Horas Extras

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 5

Horas Minutos Jornada Ordinaria Jornada

00 00 1 IJD 6 0 6.0
01 05 2 FJD 20 59 21.0
02 10 3
03 15 4
04 20 5
05 25 6
06 30 7
07 35 8
08 40 9
09 45 10
10 50 11
11 55 12
12 59 13
13 00 14
14 N/A 15
15 16
16 17
17 18
18 19
19 20
20 21
21 22
22 23
23 24
00
N/A
Valor Hora Recargo Hora Recargo Hora Recargo Hora Límite Horas
Ordinaria Nocturna Extra Diurna Extra Nocturna Extras X Día
$ 3,000.00 35% 25% 75% 2
HORA DE HORA DE HORA DE HORA DE
JORNADA INGRESO DESCANSO REGRESO Total horas Horas Ordinarias Labo
CEDULA NOMBRE APELLIDOS SALIDA
ORDINARIA Laboradas
hh mm hh mm hh mm hh mm Total
12345678 Jaime Barragan 8 08 : 00 12 : 00 14 : 00 22 : 00 12.0 8.0
92408250 Pedro Cano 8 08 : 00 12 : 00 14 : 00 20 : 00 10.0 8.0
90963745 Samuel Lopez 8 14 : 00 18 : 00 19 : 00 02 : 00 11.0 8.0
96097193 Camilo Cifuentes 8 08 : 00 12 : 00 15 : 00 23 : 00 12.0 8.0
93638537 Jhon Berrio 8 18 : 00 N/A : N/A N/A : N/A 02 : 00 8.0 8.0
98702520 Esteban Mira 8 22 : 00 N/A : N/A N/A : N/A 08 : 00 10.0 8.0
95721889 Johana Aristizabal 8 08 : 00 12 : 00 14 : 00 18 : 00 8.0 8.0
92722045 Jose Contreras 8 08 : 00 12 : 00 14 : 00 20 : 00 10.0 8.0
97527365 Mauricio Gutierrez 8 14 : 00 18 : 00 19 : 00 01 : 00 10.0 8.0
97070960 Maryi Alvarez 8 08 : 00 12 : 00 15 : 00 23 : 00 12.0 8.0
94144851 Diana Escobar 8 18 : 00 N/A : N/A N/A : N/A 02 : 00 8.0 8.0
92931162 Andres Lopez 8 22 : 00 N/A : N/A N/A : N/A 08 : 00 10.0 8.0
96554557 David Bedoya 8 08 : 00 12 : 00 14 : 00 18 : 00 8.0 8.0
92456336 Cindi Lopera 8 08 : 00 12 : 00 14 : 00 20 : 00 10.0 8.0
95807147 Gladys Ospina 8 14 : 00 18 : 00 19 : 00 00 : 00 9.0 8.0
92963879 Laura Zapata 8 08 : 00 12 : 00 15 : 00 23 : 00 12.0 8.0
94180411 Carlos Muñoz 8 18 : 00 N/A : N/A N/A : N/A 02 : 00 8.0 8.0
91666050 Gonzalo Munera 8 22 : 00 N/A : N/A N/A : N/A 08 : 00 10.0 8.0
99166507 German Lara 8 22 : 00 N/A : N/A N/A : N/A 08 : 00 10.0 8.0
86987512 Aminta Perez 4 08 : 00 12 : 00 14 : 00 16 : 00 6.0 4.0
Horas Ordinarias Laboradas Horas Extras Laboradas $ trabajo Valor total del
$ trabajo $ trabajo
extra trabajo extra y/o
nocturno extra diurno
Diurnas Nocturnas Total Diurnas Nocturnas nocturno nocturno

8.0 0.0 4.0 3.0 1.0 $ - $ 11,250 $ 5,250 $ 16,500


8.0 0.0 2.0 2.0 0.0 $ - $ 7,500 $ - $ 7,500
6.0 2.0 3.0 0.0 3.0 $ 8,100 $ - $ 15,750 $ 23,850
8.0 0.0 4.0 2.0 2.0 $ - $ 7,500 $ 10,500 $ 18,000
3.0 5.0 0.0 0.0 0.0 $ 20,250 $ - $ - $ 20,250
0.0 8.0 2.0 2.0 0.0 $ 32,400 $ 7,500 $ - $ 39,900
8.0 0.0 0.0 0.0 0.0 $ - $ - $ - $ -
8.0 0.0 2.0 2.0 0.0 $ - $ 7,500 $ - $ 7,500
6.0 2.0 2.0 0.0 2.0 $ 8,100 $ - $ 10,500 $ 18,600
8.0 0.0 4.0 2.0 2.0 $ - $ 7,500 $ 10,500 $ 18,000
3.0 5.0 0.0 0.0 0.0 $ 20,250 $ - $ - $ 20,250
0.0 8.0 2.0 2.0 0.0 $ 32,400 $ 7,500 $ - $ 39,900
8.0 0.0 0.0 0.0 0.0 $ - $ - $ - $ -
8.0 0.0 2.0 2.0 0.0 $ - $ 7,500 $ - $ 7,500
6.0 2.0 1.0 0.0 1.0 $ 8,100 $ - $ 5,250 $ 13,350
8.0 0.0 4.0 2.0 2.0 $ - $ 7,500 $ 10,500 $ 18,000
3.0 5.0 0.0 0.0 0.0 $ 20,250 $ - $ - $ 20,250
0.0 8.0 2.0 2.0 0.0 $ 32,400 $ 7,500 $ - $ 39,900
0.0 8.0 2.0 2.0 0.0 $ 32,400 $ 7,500 $ - $ 39,900
4.0 0.0 2.0 2.0 0.0 $ - $ 7,500 $ - $ 7,500
Mensaje

Excedio el límite de horas Extras en 2

Excedio el límite de horas Extras en 1


Excedio el límite de horas Extras en 2

Excedio el límite de horas Extras en 2

Excedio el límite de horas Extras en 2

You might also like