{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Nómina","Horas extras y demás","Listas y Controles","Asignación de Turnos","Registro de Turnos","Consulta de Turnos por Cédula"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Nómina","index":0,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,6,2,8],[3,6,3,8],[4,10,4,14],[5,10,5,14],[5,15,6,15],[5,16,6,16],[0,6,0,9],[0,10,3,13],[0,14,0,16],[1,6,1,8],[1,14,1,16],[2,14,2,16],[3,14,3,16],[0,1,3,5],[4,2,4,9],[5,1,6,1],[5,2,5,9],[22,1,22,3],[24,1,25,1],[24,3,25,12],[31,9,31,11],[32,9,32,11],[33,9,33,11],[35,9,35,11],[36,9,36,11],[38,9,38,11],[39,9,39,11],[36,2,36,5],[36,6,36,7],[37,2,37,5],[37,6,37,7],[38,2,38,5],[38,6,38,7],[39,2,39,5],[39,6,39,7],[27,2,27,7],[27,9,28,12],[29,2,29,7],[29,9,29,11],[30,9,30,11],[31,2,34,7],[32,1,35,1]]}
[null,null,null,null,null,null,"Diligencie los siguientes valores de referencia:",null,null,null,null,null,null,null,"Periodo de pago"]
[null,null,null,null,null,null,"Salario mínimo",null,null,908526.0,null,null,null,null,"Abril 01 2021 - Abril 30 2021"]
[null,null,null,null,null,null,"Auxilio de transporte",null,null,106454.0,null,null,null,null,"Fecha de liquidación"]
[null,null,null,null,null,null,"¿Está exonerado del pago de aportes?",null,null,"Si",null,null,null,null,"2021-04-30"]
[]
[null,"Nombre del\nempleado","Devengado",null,null,null,null,null,null,null,"Deducciones",null,null,null,null,"Neto\n pagado","Firma del \n empleado"]
[null,null,"Salario \nbásico","Días \nliquidados","Salario \ndevengado","Horas \nextras","Recargos \nnocturnos","Trabajo dominical \ny festivo","Auxilio de\ntransporte","Total\ndevengado","Salud","Pensión","Fondo de solidaridad\npensional","Retención en \nla fuente","Otras\n deducciones"]
[null,"Pedro",1200000.0,30.0,{"$f":"(C8/30)*D8","v":1200000},150000.0,85000.0,170000.0,{"$f":"IF(C8>$J$2*2,0,($J$3/30*D8))","v":106454},{"$f":"SUM(E8:I8)","v":1711454},{"$f":"(J8-I8)*0.04","v":64200},{"$f":"(J8-I8)*0.04","v":64200},{"$f":"(J8-I8)*(IF(AND(((J8-I8)/$J$2)>=4,((J8-I8)/$J$2)<16),1,IF(AND(((J8-I8)/$J$2)>=16,((J8-I8)/$J$2)<=17),1.2,IF(AND(((J8-I8)/$J$2)>17,((J8-I8)/$J$2)<=18),1.4,IF(AND(((J8-I8)/$J$2)>18,((J8-I8)/$J$2)<=19),1.6,IF(AND(((J8-I8)/$J$2)>19,((J8-I8)/$J$2)<=20),1.8,IF(((J8-I8)/$J$2)>20,2,0))))))/100)","v":0},0.0,0.0,{"$f":"J8-K8-L8-M8-N8-O8","v":1583054}]
[null,"María",6000000.0,30.0,6000000,180000.0,null,null,0,6180000,247200,247200,61800,null,null,5623800]
[null,"Oscar",1.0E7,30.0,10000000,0.0,null,null,0,10000000,400000,400000,100000,null,null,9100000]
[null,"Angela",1400000.0,30.0,1400000,120000.0,null,null,106454,1626454,60800,60800,0,null,null,1504854]
[null,"Arturo",1280000.0,30.0,1280000,0.0,null,null,106454,1386454,51200,51200,0,null,null,1284054]
[null,"Angie",1600000.0,15.0,800000,0.0,null,null,53227,853227,32000,32000,0,null,null,789227]
[null,"Camila",900000.0,30.0,900000,0.0,null,null,106454,1006454,36000,36000,0,null,null,934454]
[null,"Alejandra",900000.0,30.0,900000,0.0,null,null,106454,1006454,36000,36000,0,null,null,934454]
[null,"Cleopatra",900000.0,30.0,900000,130000.0,null,null,106454,1136454,41200,41200,0,null,null,1054054]
[null,"Juana de Arco",900000.0,20.0,600000,0.0,null,null,70969.33333,670969.3333,24000,24000,0,null,null,622969.3333]
[null,"Magda",1.0E7,30.0,10000000,0.0,null,null,0,10000000,400000,400000,100000,null,null,9100000]
[null,"Inés",1000000.0,30.0,1000000,210000.0,null,null,106454,1316454,48400,48400,0,null,null,1219654]
[null,"Clara",1000000.0,30.0,1000000,0.0,null,null,106454,1106454,40000,40000,0,null,null,1026454]
[null,"César",1000000.0,30.0,1000000,0.0,null,null,106454,1106454,40000,40000,0,null,null,1026454]
[null,"Susana",1000000.0,10.0,333333.3333,60000.0,null,null,35484.66667,428818,15733.33333,15733.33333,0,null,null,397351.3333]
[null,"Totales",null,null,{"$f":"SUM(E8:E22)","v":37313333.33},850000,85000,170000,1117767,39536100.33,1536733.333,1536733.333,261800,0,0,36200833.67]
[]
[null,{"$f":"ROUND(P23,0)","v":36200834}]
[]
[]
[null,"Comprobante de Pago Nº:",null,null,null,null,null,null,null,"Provisiones de nómina a \ncargo del empleador."]
[]
[null,"Fecha de",{"$f":"O4","v":"2021-04-30"},null,null,null,null,null,null,"Aportes a pensión",null,null,{"$f":"(J23-I23)*0.12","v":4610200}]
[null,null,null,null,null,null,null,null,null,"Aportes a salud",null,null,{"$f":"IF(J4=\"Si\",(SUMIF(J8:J22,\">\"&J2*10,J8:J22))*0.085,(J23-I23)*0.085)","v":1700000}]
[null,"Observaciones",null,null,null,null,null,null,null,"Aportes a riesgos laborales",null,null,{"$f":"(J23-I23)*0.00522","v":200543.7}]
[null,null,null,null,null,null,null,null,null,"Sena",null,null,{"$f":"IF(J4=\"Si\",(SUMIF(J8:J22,\">\"&J2*10,J8:J22))*0.02,(J23-I23)*0.02)","v":400000}]
[null,null,null,null,null,null,null,null,null,"Icbf",null,null,{"$f":"IF(J4=\"Si\",(SUMIF(J8:J22,\">\"&J2*10,J8:J22))*0.03,(J23-I23)*0.03)","v":600000}]
[null,null,null,null,null,null,null,null,null,"Cajas de compensación",null,null,{"$f":"(J23-I23)*0.04","v":1536733.333}]
[null,null,null,null,null,null,null,null,null,"Prima de servicios",null,null,{"$f":"J23*0.0833","v":3293357.158}]
[null,"Elaborador Por:","Revisado Por:",null,null,null,"Aprobado Por:",null,null,"Cesantía",null,null,{"$f":"J23*0.0833","v":3293357.158}]
[null,null,null,null,null,null,null,null,null,"Intereses sobre cesantías",null,null,{"$f":"M37*0.12","v":395202.8589}]
[null,null,null,null,null,null,null,null,null,"Provisón de vacaciones",null,null,{"$f":"(J23-F23-H23-I23)*0.0417","v":1559510.5}]
[null,null,null,null,null,null,null,null,null,"Total provisiones",null,null,{"$f":"SUM(M30:M39)","v":17588904.71}]

{"sheet":"Horas extras y demás","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,5,1,6],[9,1,11,4]]}
[null,"Horas extrsa, recargos nocturnos, dominicales y festivos"]
[null,"Seleccione el trabajador a liquidar:","Pedro","Sueldo de ",{"$f":"C2","v":"Pedro"},{"$f":"VLOOKUP(E2,'Nómina'!B8:C22,2,0)","v":1200000}]
[null,"Concepto","Porcentaje de recargo","Factor","Valor de la hora con el recargo","Ingrese las horas trabajadas","Valor total"]
[null,"Recargo Nocturno",0.35,1.35,{"$f":"($F$2/240)*D4","v":6750},2.0,{"$f":"E4*F4","v":13500}]
[null,"Hora extra diurna",0.25,1.25,{"$f":"($F$2/240)*C5","v":1250},5.0,6250]
[null,"Hora extra nocturna",0.75,1.75,3750,2.0,7500]
[null,"Hora Ordinaria dominical o festivo",0.75,1.75,3750,1.0,3750]
[null,"Hora extra diurna dominical o festivo",1.0,2.0,5000,3.0,15000]
[null,"Hora extra nocturna dominical o festivo",1.5,2.5,7500,4.0,30000]
[null,null,null,null,null,"Subtotal trabajo extra",{"$f":"G5+G6","v":13750}]
[null,null,null,null,null,"Subtotal recargo nocturno",{"$f":"G4","v":13500}]
[null,null,null,null,null,"Subtotal trabajo dominical y festivo",{"$f":"G7+G8+G9","v":48750}]

{"sheet":"Listas y Controles","index":2,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,4,0,7]]}
["Horas","Minutos","Jornada Ordinaria",null,"Jornada",null,null,null,null,"Valor Hora Ordinaria","Recargo Hora Nocturna","Recargo Hora Extra Diurna","Recargo Hora Extra Nocturna",null,"Límite Horas Extras X Día"]
["00","00",1.0,null,"IJD",6.0,0.0,{"$f":"((F2*60)+G2)/60","v":6},null,3000.0,0.35,0.25,0.75,null,2.0]
["01","05",2.0,null,"FJD",20.0,59.0,20.98333333]
["02","10",3.0]
["03",15.0,4.0]
["04",20.0,5.0]
["05",25.0,6.0]
["06",30.0,7.0]
["07",35.0,8.0]
["08",40.0,9.0]
["09",45.0,10.0]
["10",50.0,11.0]
["11",55.0,12.0]
["12",59.0,13.0]
["13","00",14.0]
["14","N/A",15.0]
["15",null,16.0]
["16",null,17.0]
["17",null,18.0]
["18",null,19.0]
["19",null,20.0]
["20",null,21.0]
["21",null,22.0]
["22",null,23.0]
["23",null,24.0]
["00"]
["N/A"]

{"sheet":"Asignación de Turnos","index":3,"n_rows":105,"n_cols":53,"rows_kept":105,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,6],[0,7,0,9],[0,10,0,12],[31,4,31,6],[0,13,0,15],[0,16,1,16],[0,17,1,17],[0,18,1,18],[0,19,1,19],[0,20,1,20],[0,21,0,23],[0,50,1,50],[0,51,1,51],[0,52,1,52],[0,24,0,26],[0,27,0,32],[0,33,0,35],[0,36,0,41],[0,42,0,47],[0,48,1,48],[0,49,1,49]]}
["CEDULA","NOMBRE","APELLIDOS","JORNADA ORDINARIA","HORA DE INGRESO",null,null,"HORA DE DESCANSO",null,null,"HORA DE REGRESO",null,null,"HORA DE SALIDA",null,null,"I","D","R","S","Total horas Laboradas","Horas Ordinarias Laboradas",null,null,"Horas Extras Laboradas",null,null,"Ingreso a Descanso",null,null,null,null,null,"Descanso a Regreso",null,null,"Regreso a Salida",null,null,null,null,null,"Ingreso a Salida (Para turnos sin descanso)",null,null,null,null,null,"$ trabajo nocturno","$ trabajo extra diurno","$ trabajo extra nocturno","Valor total del trabajo extra y/o nocturno","Mensaje"]
[null,null,null,null,"hh",null,"mm","hh",null,"mm","hh",null,"mm","hh",null,"mm",null,null,null,null,null,"Total","Diurnas","Nocturnas","Total","Diurnas","Nocturnas","Laboradas","Diurnas","Nocturnas","Extras","Diurnas","Nocturnas","Descanzadas","Diurnas","Nocturnas","Laboradas","Diurnas","Nocturnas","Extras","Diurnas","Nocturnas","Laboradas","Diurnas","Nocturnas","Extras","Diurnas","Nocturnas"]
[1.2345678E7,"Jaime","Barragan",8.0,"08",":","00","12",":","00","14",":","00","22",":","00",{"$f":"((IF(VALUE(LEFT(E3,1))=0,VALUE(RIGHT(E3,1)),VALUE(E3))*60)+IF(VALUE(LEFT(G3,1))=0,VALUE(RIGHT(G3,1)),VALUE(G3)))/60","v":8},{"$f":"((IF(VALUE(LEFT(H3,1))=0,VALUE(RIGHT(H3,1)),VALUE(H3))*60)+IF(VALUE(LEFT(J3,1))=0,VALUE(RIGHT(J3,1)),VALUE(J3)))/60","v":12},{"$f":"((IF(VALUE(LEFT(K3,1))=0,VALUE(RIGHT(K3,1)),VALUE(K3))*60)+IF(VALUE(LEFT(M3,1))=0,VALUE(RIGHT(M3,1)),VALUE(M3)))/60","v":14},{"$f":"((IF(VALUE(LEFT(N3,1))=0,VALUE(RIGHT(N3,1)),VALUE(N3))*60)+IF(VALUE(LEFT(P3,1))=0,VALUE(RIGHT(P3,1)),VALUE(P3)))/60","v":22},{"$f":"V3+Y3","v":12},{"$f":"W3+X3","v":8},{"$f":"ROUND(AC3-AF3+AL3-AO3+AR3-AU3,1)","v":8},0,{"$f":"Z3+AA3","v":4},{"$f":"ROUND(AF3+AO3+AU3,1)","v":3},1,{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(H3>E3,H3-E3,IF(H3<E3,24-E3+H3)),0)","v":4},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(R3>Q3,IF(AND(Q3>=IJD,R3<=FJD),R3-Q3,IF(AND(Q3<IJD,R3>FJD),FJD-IJD,IF(AND(Q3>=IJD,Q3<FJD,R3<24),FJD-Q3,IF(AND(Q3<IJD,R3>IJD,R3<FJD),R3-IJD,0)))),IF(R3<Q3,IF(AND(Q3>IJD,Q3<FJD,R3>=IJD,R3<FJD),FJD-Q3+R3-IJD,IF(AND(Q3>=IJD,Q3<FJD,R3<IJD),FJD-Q3,IF(AND(Q3>FJD,R3>IJD,R3<FJD),R3-IJD,IF(AND(Q3>FJD,R3>FJD),16,IF(AND(Q3<IJD,R3<IJD),16,0))))))),0)","v":4},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),AB3-AC3,0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(AB3>$D3,AB3-$D3,0),0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(AE3=0,0,IF(R3>IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3),IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>=IJD,R3<=FJD),R3-IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3),IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<IJD,R3>FJD),FJD-IJD,IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>=IJD,IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<FJD,R3<24),FJD-IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3),IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<IJD,R3>IJD,R3<FJD),R3-IJD,0)))),IF(R3<IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3),IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>IJD,IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<FJD,R3>=IJD,R3<FJD),FJD-IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)+R3-IJD,IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>=IJD,IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<FJD,R3<IJD),FJD-IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3),IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>FJD,R3>IJD,R3<FJD),R3-IJD,IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>FJD,R3>FJD),16,IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<IJD,R3<IJD),16,0)))))))),0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),AE3-AF3,0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(S3>R3,S3-R3,IF(S3<R3,24-R3+S3)),0)","v":2},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(S3>R3,IF(AND(R3>=IJD,S3<FJD),S3-R3,IF(AND(R3>=IJD,S3>FJD),IF(R3>FJD,R3-FJD,FJD-R3),IF(AND(R3<IJD,S3>=IJD,S3>FJD),S3-IJD-(S3-FJD),IF(AND(R3<IJD,S3>=IJD),S3-IJD,IF(AND(R3<IJD,S3<IJD),0))))),IF(S3<R3,IF(AND(R3>=FJD,S3<=IJD),0,IF(AND(R3<FJD,S3<=IJD),FJD-R3,IF(AND(R3>FJD,S3>IJD),S3-IJD,IF(AND(R3<FJD,S3>IJD),FJD-R3+S3-IJD)))))),0)","v":2},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),AH3-AI3,0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(T3>S3,T3-S3,IF(T3<S3,24-S3+T3)),0)","v":8},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(T3>S3,IF(AND(S3>=IJD,T3<=FJD),T3-S3,IF(AND(S3<IJD,T3>FJD),FJD-IJD,IF(AND(S3>=IJD,S3<FJD,T3<24),FJD-S3,IF(AND(S3<IJD,T3>IJD,T3<FJD),T3-IJD,0)))),IF(T3<S3,IF(AND(S3>IJD,S3<FJD,T3>=IJD,T3<FJD),FJD-S3+T3-IJD,IF(AND(S3>=IJD,S3<FJD,T3<IJD),FJD-S3,IF(AND(S3>FJD,T3>IJD,T3<FJD),T3-IJD,IF(AND(S3>FJD,T3>FJD),16,IF(AND(S3<IJD,T3<IJD),16,0))))))),0)","v":6.983333333},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),AK3-AL3,0)","v":1.016666667},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(AE3>0,AK3,IF(AK3+AB3>$D3,AK3+AB3-$D3,0)),0)","v":4},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(AN3=0,0,IF(T3>IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3),IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>=IJD,T3<=FJD),T3-IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3),IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<IJD,T3>FJD),FJD-IJD,IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>=IJD,IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<FJD,T3<24),FJD-IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3),IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<IJD,T3>IJD,T3<FJD),T3-IJD,0)))),IF(T3<IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3),IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>IJD,IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<FJD,T3>=IJD,T3<FJD),FJD-IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)+T3-IJD,IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>=IJD,IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<FJD,T3<IJD),FJD-IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3),IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>FJD,T3>IJD,T3<FJD),T3-IJD,IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>FJD,T3>FJD),16,IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<IJD,T3<IJD),16,0)))))))),0)","v":2.983333333},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),AN3-AO3,0)","v":1.016666667},{"$f":"IF(AND(H3=\"N/A\",K3=\"N/A\"),IF(T3>Q3,T3-Q3,IF(T3<Q3,24-Q3+T3)),0)","v":0},{"$f":"IF(AND(H3=\"N/A\",K3=\"N/A\"),IF(T3>Q3,IF(AND(Q3>=IJD,T3<=FJD),T3-Q3,IF(AND(Q3<IJD,T3>FJD),FJD-IJD,IF(AND(Q3>=IJD,Q3<FJD,T3<24),FJD-Q3,IF(AND(Q3<IJD,T3>IJD,T3<FJD),T3-IJD,0)))),IF(T3<Q3,IF(AND(Q3>IJD,Q3<FJD,T3>=IJD,T3<FJD),FJD-Q3+T3-IJD,IF(AND(Q3>=IJD,Q3<FJD,T3<IJD),FJD-Q3,IF(AND(Q3>FJD,T3>IJD,T3<FJD),T3-IJD,IF(AND(Q3>FJD,T3>FJD),16,IF(AND(Q3<IJD,T3<IJD),16,0))))))),0)","v":0},{"$f":"AQ3-AR3","v":0},{"$f":"IF(AND(H3=\"N/A\",K3=\"N/A\"),IF(AQ3>$D3,AQ3-$D3,0),0)","v":0},{"$f":"IF(AND(H3=\"N/A\",K3=\"N/A\"),IF(AT3=0,0,IF(T3>IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3),IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>=IJD,T3<=FJD),T3-IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3),IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<IJD,T3>FJD),FJD-IJD,IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>=IJD,IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<FJD,T3<24),FJD-IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3),IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<IJD,T3>IJD,T3<FJD),T3-IJD,0)))),IF(T3<IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3),IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>IJD,IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<FJD,T3>=IJD,T3<FJD),FJD-IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)+T3-IJD,IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>=IJD,IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<FJD,T3<IJD),FJD-IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3),IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>FJD,T3>IJD,T3<FJD),T3-IJD,IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>FJD,T3>FJD),16,IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<IJD,T3<IJD),16,0)))))))),0)","v":0},{"$f":"IF(AND(H3=\"N/A\",K3=\"N/A\"),AT3-AU3,0)","v":0},{"$f":"X3*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z3*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":11250},{"$f":"AA3*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":5250},{"$f":"SUM(AW3:AY3)","v":16500},{"$f":"IF(Y3>2,\"Excedio el límite de horas Extras en \" & Y3-LIMITEHORASEXTRAXDIA,\"\")","v":"Excedio el límite de horas Extras en 2"}]
[9.240825E7,"Pedro","Cano",8.0,"08",":","00","12",":","00","14",":","00","20",":","00",8,12,14,20,10,8,{"$f":"ROUND(AC4-AF4+AL4-AO4+AR4-AU4,1)","v":8},0,2,{"$f":"ROUND(AF4+AO4+AU4,1)","v":2},0,4,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),IF(R4>Q4,IF(AND(Q4>=IJD,R4<=FJD),R4-Q4,IF(AND(Q4<IJD,R4>FJD),FJD-IJD,IF(AND(Q4>=IJD,Q4<FJD,R4<24),FJD-Q4,IF(AND(Q4<IJD,R4>IJD,R4<FJD),R4-IJD,0)))),IF(R4<Q4,IF(AND(Q4>IJD,Q4<FJD,R4>=IJD,R4<FJD),FJD-Q4+R4-IJD,IF(AND(Q4>=IJD,Q4<FJD,R4<IJD),FJD-Q4,IF(AND(Q4>FJD,R4>IJD,R4<FJD),R4-IJD,IF(AND(Q4>FJD,R4>FJD),16,IF(AND(Q4<IJD,R4<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),IF(AE4=0,0,IF(R4>IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4),IF(AND(IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)>=IJD,R4<=FJD),R4-IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4),IF(AND(IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)<IJD,R4>FJD),FJD-IJD,IF(AND(IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)>=IJD,IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)<FJD,R4<24),FJD-IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4),IF(AND(IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)<IJD,R4>IJD,R4<FJD),R4-IJD,0)))),IF(R4<IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4),IF(AND(IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)>IJD,IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)<FJD,R4>=IJD,R4<FJD),FJD-IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)+R4-IJD,IF(AND(IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)>=IJD,IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)<FJD,R4<IJD),FJD-IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4),IF(AND(IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)>FJD,R4>IJD,R4<FJD),R4-IJD,IF(AND(IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)>FJD,R4>FJD),16,IF(AND(IF(Q4+AB4-AE4>24,(Q4+AB4-AE4)-24,Q4+AB4-AE4)<IJD,R4<IJD),16,0)))))))),0)","v":0},0,2,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),IF(S4>R4,IF(AND(R4>=IJD,S4<FJD),S4-R4,IF(AND(R4>=IJD,S4>FJD),IF(R4>FJD,R4-FJD,FJD-R4),IF(AND(R4<IJD,S4>=IJD,S4>FJD),S4-IJD-(S4-FJD),IF(AND(R4<IJD,S4>=IJD),S4-IJD,IF(AND(R4<IJD,S4<IJD),0))))),IF(S4<R4,IF(AND(R4>=FJD,S4<=IJD),0,IF(AND(R4<FJD,S4<=IJD),FJD-R4,IF(AND(R4>FJD,S4>IJD),S4-IJD,IF(AND(R4<FJD,S4>IJD),FJD-R4+S4-IJD)))))),0)","v":2},0,6,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),IF(T4>S4,IF(AND(S4>=IJD,T4<=FJD),T4-S4,IF(AND(S4<IJD,T4>FJD),FJD-IJD,IF(AND(S4>=IJD,S4<FJD,T4<24),FJD-S4,IF(AND(S4<IJD,T4>IJD,T4<FJD),T4-IJD,0)))),IF(T4<S4,IF(AND(S4>IJD,S4<FJD,T4>=IJD,T4<FJD),FJD-S4+T4-IJD,IF(AND(S4>=IJD,S4<FJD,T4<IJD),FJD-S4,IF(AND(S4>FJD,T4>IJD,T4<FJD),T4-IJD,IF(AND(S4>FJD,T4>FJD),16,IF(AND(S4<IJD,T4<IJD),16,0))))))),0)","v":6},0,2,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),IF(AN4=0,0,IF(T4>IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4),IF(AND(IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)>=IJD,T4<=FJD),T4-IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4),IF(AND(IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)<IJD,T4>FJD),FJD-IJD,IF(AND(IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)>=IJD,IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)<FJD,T4<24),FJD-IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4),IF(AND(IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)<IJD,T4>IJD,T4<FJD),T4-IJD,0)))),IF(T4<IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4),IF(AND(IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)>IJD,IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)<FJD,T4>=IJD,T4<FJD),FJD-IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)+T4-IJD,IF(AND(IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)>=IJD,IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)<FJD,T4<IJD),FJD-IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4),IF(AND(IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)>FJD,T4>IJD,T4<FJD),T4-IJD,IF(AND(IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)>FJD,T4>FJD),16,IF(AND(IF(S4+AK4-AN4>24,(S4+AK4-AN4)-24,S4+AK4-AN4)<IJD,T4<IJD),16,0)))))))),0)","v":2},0,0,{"$f":"IF(AND(H4=\"N/A\",K4=\"N/A\"),IF(T4>Q4,IF(AND(Q4>=IJD,T4<=FJD),T4-Q4,IF(AND(Q4<IJD,T4>FJD),FJD-IJD,IF(AND(Q4>=IJD,Q4<FJD,T4<24),FJD-Q4,IF(AND(Q4<IJD,T4>IJD,T4<FJD),T4-IJD,0)))),IF(T4<Q4,IF(AND(Q4>IJD,Q4<FJD,T4>=IJD,T4<FJD),FJD-Q4+T4-IJD,IF(AND(Q4>=IJD,Q4<FJD,T4<IJD),FJD-Q4,IF(AND(Q4>FJD,T4>IJD,T4<FJD),T4-IJD,IF(AND(Q4>FJD,T4>FJD),16,IF(AND(Q4<IJD,T4<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H4=\"N/A\",K4=\"N/A\"),IF(AT4=0,0,IF(T4>IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4),IF(AND(IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)>=IJD,T4<=FJD),T4-IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4),IF(AND(IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)<IJD,T4>FJD),FJD-IJD,IF(AND(IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)>=IJD,IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)<FJD,T4<24),FJD-IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4),IF(AND(IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)<IJD,T4>IJD,T4<FJD),T4-IJD,0)))),IF(T4<IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4),IF(AND(IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)>IJD,IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)<FJD,T4>=IJD,T4<FJD),FJD-IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)+T4-IJD,IF(AND(IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)>=IJD,IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)<FJD,T4<IJD),FJD-IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4),IF(AND(IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)>FJD,T4>IJD,T4<FJD),T4-IJD,IF(AND(IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)>FJD,T4>FJD),16,IF(AND(IF(Q4+AQ4-AT4>24,(Q4+AQ4-AT4)-24,Q4+AQ4-AT4)<IJD,T4<IJD),16,0)))))))),0)","v":0},0,{"$f":"X4*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z4*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA4*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},7500,{"$f":"IF(Y4>2,\"Excedio el límite de horas Extras en \" & Y4-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.0963745E7,"Samuel","Lopez",8.0,"14",":","00","18",":","00","19",":","00","02",":","00",14,18,19,2,11,8,{"$f":"ROUND(AC5-AF5+AL5-AO5+AR5-AU5,1)","v":6},2,3,{"$f":"ROUND(AF5+AO5+AU5,1)","v":0},3,4,{"$f":"IF(AND(H5<>\"N/A\",K5<>\"N/A\"),IF(R5>Q5,IF(AND(Q5>=IJD,R5<=FJD),R5-Q5,IF(AND(Q5<IJD,R5>FJD),FJD-IJD,IF(AND(Q5>=IJD,Q5<FJD,R5<24),FJD-Q5,IF(AND(Q5<IJD,R5>IJD,R5<FJD),R5-IJD,0)))),IF(R5<Q5,IF(AND(Q5>IJD,Q5<FJD,R5>=IJD,R5<FJD),FJD-Q5+R5-IJD,IF(AND(Q5>=IJD,Q5<FJD,R5<IJD),FJD-Q5,IF(AND(Q5>FJD,R5>IJD,R5<FJD),R5-IJD,IF(AND(Q5>FJD,R5>FJD),16,IF(AND(Q5<IJD,R5<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H5<>\"N/A\",K5<>\"N/A\"),IF(AE5=0,0,IF(R5>IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5),IF(AND(IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)>=IJD,R5<=FJD),R5-IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5),IF(AND(IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)<IJD,R5>FJD),FJD-IJD,IF(AND(IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)>=IJD,IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)<FJD,R5<24),FJD-IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5),IF(AND(IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)<IJD,R5>IJD,R5<FJD),R5-IJD,0)))),IF(R5<IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5),IF(AND(IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)>IJD,IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)<FJD,R5>=IJD,R5<FJD),FJD-IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)+R5-IJD,IF(AND(IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)>=IJD,IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)<FJD,R5<IJD),FJD-IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5),IF(AND(IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)>FJD,R5>IJD,R5<FJD),R5-IJD,IF(AND(IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)>FJD,R5>FJD),16,IF(AND(IF(Q5+AB5-AE5>24,(Q5+AB5-AE5)-24,Q5+AB5-AE5)<IJD,R5<IJD),16,0)))))))),0)","v":0},0,1,{"$f":"IF(AND(H5<>\"N/A\",K5<>\"N/A\"),IF(S5>R5,IF(AND(R5>=IJD,S5<FJD),S5-R5,IF(AND(R5>=IJD,S5>FJD),IF(R5>FJD,R5-FJD,FJD-R5),IF(AND(R5<IJD,S5>=IJD,S5>FJD),S5-IJD-(S5-FJD),IF(AND(R5<IJD,S5>=IJD),S5-IJD,IF(AND(R5<IJD,S5<IJD),0))))),IF(S5<R5,IF(AND(R5>=FJD,S5<=IJD),0,IF(AND(R5<FJD,S5<=IJD),FJD-R5,IF(AND(R5>FJD,S5>IJD),S5-IJD,IF(AND(R5<FJD,S5>IJD),FJD-R5+S5-IJD)))))),0)","v":1},0,7,{"$f":"IF(AND(H5<>\"N/A\",K5<>\"N/A\"),IF(T5>S5,IF(AND(S5>=IJD,T5<=FJD),T5-S5,IF(AND(S5<IJD,T5>FJD),FJD-IJD,IF(AND(S5>=IJD,S5<FJD,T5<24),FJD-S5,IF(AND(S5<IJD,T5>IJD,T5<FJD),T5-IJD,0)))),IF(T5<S5,IF(AND(S5>IJD,S5<FJD,T5>=IJD,T5<FJD),FJD-S5+T5-IJD,IF(AND(S5>=IJD,S5<FJD,T5<IJD),FJD-S5,IF(AND(S5>FJD,T5>IJD,T5<FJD),T5-IJD,IF(AND(S5>FJD,T5>FJD),16,IF(AND(S5<IJD,T5<IJD),16,0))))))),0)","v":1.983333333},5.016666667,3,{"$f":"IF(AND(H5<>\"N/A\",K5<>\"N/A\"),IF(AN5=0,0,IF(T5>IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5),IF(AND(IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)>=IJD,T5<=FJD),T5-IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5),IF(AND(IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)<IJD,T5>FJD),FJD-IJD,IF(AND(IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)>=IJD,IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)<FJD,T5<24),FJD-IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5),IF(AND(IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)<IJD,T5>IJD,T5<FJD),T5-IJD,0)))),IF(T5<IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5),IF(AND(IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)>IJD,IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)<FJD,T5>=IJD,T5<FJD),FJD-IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)+T5-IJD,IF(AND(IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)>=IJD,IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)<FJD,T5<IJD),FJD-IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5),IF(AND(IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)>FJD,T5>IJD,T5<FJD),T5-IJD,IF(AND(IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)>FJD,T5>FJD),16,IF(AND(IF(S5+AK5-AN5>24,(S5+AK5-AN5)-24,S5+AK5-AN5)<IJD,T5<IJD),16,0)))))))),0)","v":0},3,0,{"$f":"IF(AND(H5=\"N/A\",K5=\"N/A\"),IF(T5>Q5,IF(AND(Q5>=IJD,T5<=FJD),T5-Q5,IF(AND(Q5<IJD,T5>FJD),FJD-IJD,IF(AND(Q5>=IJD,Q5<FJD,T5<24),FJD-Q5,IF(AND(Q5<IJD,T5>IJD,T5<FJD),T5-IJD,0)))),IF(T5<Q5,IF(AND(Q5>IJD,Q5<FJD,T5>=IJD,T5<FJD),FJD-Q5+T5-IJD,IF(AND(Q5>=IJD,Q5<FJD,T5<IJD),FJD-Q5,IF(AND(Q5>FJD,T5>IJD,T5<FJD),T5-IJD,IF(AND(Q5>FJD,T5>FJD),16,IF(AND(Q5<IJD,T5<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H5=\"N/A\",K5=\"N/A\"),IF(AT5=0,0,IF(T5>IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5),IF(AND(IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)>=IJD,T5<=FJD),T5-IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5),IF(AND(IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)<IJD,T5>FJD),FJD-IJD,IF(AND(IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)>=IJD,IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)<FJD,T5<24),FJD-IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5),IF(AND(IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)<IJD,T5>IJD,T5<FJD),T5-IJD,0)))),IF(T5<IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5),IF(AND(IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)>IJD,IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)<FJD,T5>=IJD,T5<FJD),FJD-IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)+T5-IJD,IF(AND(IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)>=IJD,IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)<FJD,T5<IJD),FJD-IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5),IF(AND(IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)>FJD,T5>IJD,T5<FJD),T5-IJD,IF(AND(IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)>FJD,T5>FJD),16,IF(AND(IF(Q5+AQ5-AT5>24,(Q5+AQ5-AT5)-24,Q5+AQ5-AT5)<IJD,T5<IJD),16,0)))))))),0)","v":0},0,{"$f":"X5*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":8100},{"$f":"Z5*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":0},{"$f":"AA5*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":15750},23850,{"$f":"IF(Y5>2,\"Excedio el límite de horas Extras en \" & Y5-LIMITEHORASEXTRAXDIA,\"\")","v":"Excedio el límite de horas Extras en 1"}]
[9.6097193E7,"Camilo","Cifuentes",8.0,"08",":","00","12",":","00","15",":","00","23",":","00",8,12,15,23,12,8,{"$f":"ROUND(AC6-AF6+AL6-AO6+AR6-AU6,1)","v":8},0,4,{"$f":"ROUND(AF6+AO6+AU6,1)","v":2},2,4,{"$f":"IF(AND(H6<>\"N/A\",K6<>\"N/A\"),IF(R6>Q6,IF(AND(Q6>=IJD,R6<=FJD),R6-Q6,IF(AND(Q6<IJD,R6>FJD),FJD-IJD,IF(AND(Q6>=IJD,Q6<FJD,R6<24),FJD-Q6,IF(AND(Q6<IJD,R6>IJD,R6<FJD),R6-IJD,0)))),IF(R6<Q6,IF(AND(Q6>IJD,Q6<FJD,R6>=IJD,R6<FJD),FJD-Q6+R6-IJD,IF(AND(Q6>=IJD,Q6<FJD,R6<IJD),FJD-Q6,IF(AND(Q6>FJD,R6>IJD,R6<FJD),R6-IJD,IF(AND(Q6>FJD,R6>FJD),16,IF(AND(Q6<IJD,R6<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H6<>\"N/A\",K6<>\"N/A\"),IF(AE6=0,0,IF(R6>IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6),IF(AND(IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)>=IJD,R6<=FJD),R6-IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6),IF(AND(IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)<IJD,R6>FJD),FJD-IJD,IF(AND(IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)>=IJD,IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)<FJD,R6<24),FJD-IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6),IF(AND(IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)<IJD,R6>IJD,R6<FJD),R6-IJD,0)))),IF(R6<IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6),IF(AND(IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)>IJD,IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)<FJD,R6>=IJD,R6<FJD),FJD-IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)+R6-IJD,IF(AND(IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)>=IJD,IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)<FJD,R6<IJD),FJD-IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6),IF(AND(IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)>FJD,R6>IJD,R6<FJD),R6-IJD,IF(AND(IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)>FJD,R6>FJD),16,IF(AND(IF(Q6+AB6-AE6>24,(Q6+AB6-AE6)-24,Q6+AB6-AE6)<IJD,R6<IJD),16,0)))))))),0)","v":0},0,3,{"$f":"IF(AND(H6<>\"N/A\",K6<>\"N/A\"),IF(S6>R6,IF(AND(R6>=IJD,S6<FJD),S6-R6,IF(AND(R6>=IJD,S6>FJD),IF(R6>FJD,R6-FJD,FJD-R6),IF(AND(R6<IJD,S6>=IJD,S6>FJD),S6-IJD-(S6-FJD),IF(AND(R6<IJD,S6>=IJD),S6-IJD,IF(AND(R6<IJD,S6<IJD),0))))),IF(S6<R6,IF(AND(R6>=FJD,S6<=IJD),0,IF(AND(R6<FJD,S6<=IJD),FJD-R6,IF(AND(R6>FJD,S6>IJD),S6-IJD,IF(AND(R6<FJD,S6>IJD),FJD-R6+S6-IJD)))))),0)","v":3},0,8,{"$f":"IF(AND(H6<>\"N/A\",K6<>\"N/A\"),IF(T6>S6,IF(AND(S6>=IJD,T6<=FJD),T6-S6,IF(AND(S6<IJD,T6>FJD),FJD-IJD,IF(AND(S6>=IJD,S6<FJD,T6<24),FJD-S6,IF(AND(S6<IJD,T6>IJD,T6<FJD),T6-IJD,0)))),IF(T6<S6,IF(AND(S6>IJD,S6<FJD,T6>=IJD,T6<FJD),FJD-S6+T6-IJD,IF(AND(S6>=IJD,S6<FJD,T6<IJD),FJD-S6,IF(AND(S6>FJD,T6>IJD,T6<FJD),T6-IJD,IF(AND(S6>FJD,T6>FJD),16,IF(AND(S6<IJD,T6<IJD),16,0))))))),0)","v":5.983333333},2.016666667,4,{"$f":"IF(AND(H6<>\"N/A\",K6<>\"N/A\"),IF(AN6=0,0,IF(T6>IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6),IF(AND(IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)>=IJD,T6<=FJD),T6-IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6),IF(AND(IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)<IJD,T6>FJD),FJD-IJD,IF(AND(IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)>=IJD,IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)<FJD,T6<24),FJD-IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6),IF(AND(IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)<IJD,T6>IJD,T6<FJD),T6-IJD,0)))),IF(T6<IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6),IF(AND(IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)>IJD,IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)<FJD,T6>=IJD,T6<FJD),FJD-IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)+T6-IJD,IF(AND(IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)>=IJD,IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)<FJD,T6<IJD),FJD-IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6),IF(AND(IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)>FJD,T6>IJD,T6<FJD),T6-IJD,IF(AND(IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)>FJD,T6>FJD),16,IF(AND(IF(S6+AK6-AN6>24,(S6+AK6-AN6)-24,S6+AK6-AN6)<IJD,T6<IJD),16,0)))))))),0)","v":1.983333333},2.016666667,0,{"$f":"IF(AND(H6=\"N/A\",K6=\"N/A\"),IF(T6>Q6,IF(AND(Q6>=IJD,T6<=FJD),T6-Q6,IF(AND(Q6<IJD,T6>FJD),FJD-IJD,IF(AND(Q6>=IJD,Q6<FJD,T6<24),FJD-Q6,IF(AND(Q6<IJD,T6>IJD,T6<FJD),T6-IJD,0)))),IF(T6<Q6,IF(AND(Q6>IJD,Q6<FJD,T6>=IJD,T6<FJD),FJD-Q6+T6-IJD,IF(AND(Q6>=IJD,Q6<FJD,T6<IJD),FJD-Q6,IF(AND(Q6>FJD,T6>IJD,T6<FJD),T6-IJD,IF(AND(Q6>FJD,T6>FJD),16,IF(AND(Q6<IJD,T6<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H6=\"N/A\",K6=\"N/A\"),IF(AT6=0,0,IF(T6>IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6),IF(AND(IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)>=IJD,T6<=FJD),T6-IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6),IF(AND(IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)<IJD,T6>FJD),FJD-IJD,IF(AND(IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)>=IJD,IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)<FJD,T6<24),FJD-IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6),IF(AND(IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)<IJD,T6>IJD,T6<FJD),T6-IJD,0)))),IF(T6<IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6),IF(AND(IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)>IJD,IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)<FJD,T6>=IJD,T6<FJD),FJD-IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)+T6-IJD,IF(AND(IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)>=IJD,IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)<FJD,T6<IJD),FJD-IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6),IF(AND(IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)>FJD,T6>IJD,T6<FJD),T6-IJD,IF(AND(IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)>FJD,T6>FJD),16,IF(AND(IF(Q6+AQ6-AT6>24,(Q6+AQ6-AT6)-24,Q6+AQ6-AT6)<IJD,T6<IJD),16,0)))))))),0)","v":0},0,{"$f":"X6*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z6*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA6*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":10500},18000,{"$f":"IF(Y6>2,\"Excedio el límite de horas Extras en \" & Y6-LIMITEHORASEXTRAXDIA,\"\")","v":"Excedio el límite de horas Extras en 2"}]
[9.3638537E7,"Jhon","Berrio",8.0,"18",":","00","N/A",":","N/A","N/A",":","N/A","02",":","00",18,"#VALUE!","#VALUE!",2,8,8,{"$f":"ROUND(AC7-AF7+AL7-AO7+AR7-AU7,1)","v":3},5,0,{"$f":"ROUND(AF7+AO7+AU7,1)","v":0},0,0,{"$f":"IF(AND(H7<>\"N/A\",K7<>\"N/A\"),IF(R7>Q7,IF(AND(Q7>=IJD,R7<=FJD),R7-Q7,IF(AND(Q7<IJD,R7>FJD),FJD-IJD,IF(AND(Q7>=IJD,Q7<FJD,R7<24),FJD-Q7,IF(AND(Q7<IJD,R7>IJD,R7<FJD),R7-IJD,0)))),IF(R7<Q7,IF(AND(Q7>IJD,Q7<FJD,R7>=IJD,R7<FJD),FJD-Q7+R7-IJD,IF(AND(Q7>=IJD,Q7<FJD,R7<IJD),FJD-Q7,IF(AND(Q7>FJD,R7>IJD,R7<FJD),R7-IJD,IF(AND(Q7>FJD,R7>FJD),16,IF(AND(Q7<IJD,R7<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H7<>\"N/A\",K7<>\"N/A\"),IF(AE7=0,0,IF(R7>IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7),IF(AND(IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)>=IJD,R7<=FJD),R7-IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7),IF(AND(IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)<IJD,R7>FJD),FJD-IJD,IF(AND(IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)>=IJD,IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)<FJD,R7<24),FJD-IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7),IF(AND(IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)<IJD,R7>IJD,R7<FJD),R7-IJD,0)))),IF(R7<IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7),IF(AND(IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)>IJD,IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)<FJD,R7>=IJD,R7<FJD),FJD-IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)+R7-IJD,IF(AND(IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)>=IJD,IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)<FJD,R7<IJD),FJD-IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7),IF(AND(IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)>FJD,R7>IJD,R7<FJD),R7-IJD,IF(AND(IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)>FJD,R7>FJD),16,IF(AND(IF(Q7+AB7-AE7>24,(Q7+AB7-AE7)-24,Q7+AB7-AE7)<IJD,R7<IJD),16,0)))))))),0)","v":0},0,0,{"$f":"IF(AND(H7<>\"N/A\",K7<>\"N/A\"),IF(S7>R7,IF(AND(R7>=IJD,S7<FJD),S7-R7,IF(AND(R7>=IJD,S7>FJD),IF(R7>FJD,R7-FJD,FJD-R7),IF(AND(R7<IJD,S7>=IJD,S7>FJD),S7-IJD-(S7-FJD),IF(AND(R7<IJD,S7>=IJD),S7-IJD,IF(AND(R7<IJD,S7<IJD),0))))),IF(S7<R7,IF(AND(R7>=FJD,S7<=IJD),0,IF(AND(R7<FJD,S7<=IJD),FJD-R7,IF(AND(R7>FJD,S7>IJD),S7-IJD,IF(AND(R7<FJD,S7>IJD),FJD-R7+S7-IJD)))))),0)","v":0},0,0,{"$f":"IF(AND(H7<>\"N/A\",K7<>\"N/A\"),IF(T7>S7,IF(AND(S7>=IJD,T7<=FJD),T7-S7,IF(AND(S7<IJD,T7>FJD),FJD-IJD,IF(AND(S7>=IJD,S7<FJD,T7<24),FJD-S7,IF(AND(S7<IJD,T7>IJD,T7<FJD),T7-IJD,0)))),IF(T7<S7,IF(AND(S7>IJD,S7<FJD,T7>=IJD,T7<FJD),FJD-S7+T7-IJD,IF(AND(S7>=IJD,S7<FJD,T7<IJD),FJD-S7,IF(AND(S7>FJD,T7>IJD,T7<FJD),T7-IJD,IF(AND(S7>FJD,T7>FJD),16,IF(AND(S7<IJD,T7<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H7<>\"N/A\",K7<>\"N/A\"),IF(AN7=0,0,IF(T7>IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7),IF(AND(IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)>=IJD,T7<=FJD),T7-IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7),IF(AND(IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)<IJD,T7>FJD),FJD-IJD,IF(AND(IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)>=IJD,IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)<FJD,T7<24),FJD-IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7),IF(AND(IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)<IJD,T7>IJD,T7<FJD),T7-IJD,0)))),IF(T7<IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7),IF(AND(IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)>IJD,IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)<FJD,T7>=IJD,T7<FJD),FJD-IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)+T7-IJD,IF(AND(IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)>=IJD,IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)<FJD,T7<IJD),FJD-IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7),IF(AND(IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)>FJD,T7>IJD,T7<FJD),T7-IJD,IF(AND(IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)>FJD,T7>FJD),16,IF(AND(IF(S7+AK7-AN7>24,(S7+AK7-AN7)-24,S7+AK7-AN7)<IJD,T7<IJD),16,0)))))))),0)","v":0},0,8,{"$f":"IF(AND(H7=\"N/A\",K7=\"N/A\"),IF(T7>Q7,IF(AND(Q7>=IJD,T7<=FJD),T7-Q7,IF(AND(Q7<IJD,T7>FJD),FJD-IJD,IF(AND(Q7>=IJD,Q7<FJD,T7<24),FJD-Q7,IF(AND(Q7<IJD,T7>IJD,T7<FJD),T7-IJD,0)))),IF(T7<Q7,IF(AND(Q7>IJD,Q7<FJD,T7>=IJD,T7<FJD),FJD-Q7+T7-IJD,IF(AND(Q7>=IJD,Q7<FJD,T7<IJD),FJD-Q7,IF(AND(Q7>FJD,T7>IJD,T7<FJD),T7-IJD,IF(AND(Q7>FJD,T7>FJD),16,IF(AND(Q7<IJD,T7<IJD),16,0))))))),0)","v":2.983333333},5.016666667,0,{"$f":"IF(AND(H7=\"N/A\",K7=\"N/A\"),IF(AT7=0,0,IF(T7>IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7),IF(AND(IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)>=IJD,T7<=FJD),T7-IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7),IF(AND(IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)<IJD,T7>FJD),FJD-IJD,IF(AND(IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)>=IJD,IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)<FJD,T7<24),FJD-IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7),IF(AND(IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)<IJD,T7>IJD,T7<FJD),T7-IJD,0)))),IF(T7<IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7),IF(AND(IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)>IJD,IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)<FJD,T7>=IJD,T7<FJD),FJD-IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)+T7-IJD,IF(AND(IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)>=IJD,IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)<FJD,T7<IJD),FJD-IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7),IF(AND(IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)>FJD,T7>IJD,T7<FJD),T7-IJD,IF(AND(IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)>FJD,T7>FJD),16,IF(AND(IF(Q7+AQ7-AT7>24,(Q7+AQ7-AT7)-24,Q7+AQ7-AT7)<IJD,T7<IJD),16,0)))))))),0)","v":0},0,{"$f":"X7*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":20250},{"$f":"Z7*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":0},{"$f":"AA7*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},20250,{"$f":"IF(Y7>2,\"Excedio el límite de horas Extras en \" & Y7-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.870252E7,"Esteban","Mira",8.0,"22",":","00","N/A",":","N/A","N/A",":","N/A","08",":","00",22,"#VALUE!","#VALUE!",8,10,8,{"$f":"ROUND(AC8-AF8+AL8-AO8+AR8-AU8,1)","v":0},8,2,{"$f":"ROUND(AF8+AO8+AU8,1)","v":2},0,0,{"$f":"IF(AND(H8<>\"N/A\",K8<>\"N/A\"),IF(R8>Q8,IF(AND(Q8>=IJD,R8<=FJD),R8-Q8,IF(AND(Q8<IJD,R8>FJD),FJD-IJD,IF(AND(Q8>=IJD,Q8<FJD,R8<24),FJD-Q8,IF(AND(Q8<IJD,R8>IJD,R8<FJD),R8-IJD,0)))),IF(R8<Q8,IF(AND(Q8>IJD,Q8<FJD,R8>=IJD,R8<FJD),FJD-Q8+R8-IJD,IF(AND(Q8>=IJD,Q8<FJD,R8<IJD),FJD-Q8,IF(AND(Q8>FJD,R8>IJD,R8<FJD),R8-IJD,IF(AND(Q8>FJD,R8>FJD),16,IF(AND(Q8<IJD,R8<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H8<>\"N/A\",K8<>\"N/A\"),IF(AE8=0,0,IF(R8>IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8),IF(AND(IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)>=IJD,R8<=FJD),R8-IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8),IF(AND(IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)<IJD,R8>FJD),FJD-IJD,IF(AND(IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)>=IJD,IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)<FJD,R8<24),FJD-IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8),IF(AND(IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)<IJD,R8>IJD,R8<FJD),R8-IJD,0)))),IF(R8<IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8),IF(AND(IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)>IJD,IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)<FJD,R8>=IJD,R8<FJD),FJD-IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)+R8-IJD,IF(AND(IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)>=IJD,IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)<FJD,R8<IJD),FJD-IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8),IF(AND(IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)>FJD,R8>IJD,R8<FJD),R8-IJD,IF(AND(IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)>FJD,R8>FJD),16,IF(AND(IF(Q8+AB8-AE8>24,(Q8+AB8-AE8)-24,Q8+AB8-AE8)<IJD,R8<IJD),16,0)))))))),0)","v":0},0,0,{"$f":"IF(AND(H8<>\"N/A\",K8<>\"N/A\"),IF(S8>R8,IF(AND(R8>=IJD,S8<FJD),S8-R8,IF(AND(R8>=IJD,S8>FJD),IF(R8>FJD,R8-FJD,FJD-R8),IF(AND(R8<IJD,S8>=IJD,S8>FJD),S8-IJD-(S8-FJD),IF(AND(R8<IJD,S8>=IJD),S8-IJD,IF(AND(R8<IJD,S8<IJD),0))))),IF(S8<R8,IF(AND(R8>=FJD,S8<=IJD),0,IF(AND(R8<FJD,S8<=IJD),FJD-R8,IF(AND(R8>FJD,S8>IJD),S8-IJD,IF(AND(R8<FJD,S8>IJD),FJD-R8+S8-IJD)))))),0)","v":0},0,0,{"$f":"IF(AND(H8<>\"N/A\",K8<>\"N/A\"),IF(T8>S8,IF(AND(S8>=IJD,T8<=FJD),T8-S8,IF(AND(S8<IJD,T8>FJD),FJD-IJD,IF(AND(S8>=IJD,S8<FJD,T8<24),FJD-S8,IF(AND(S8<IJD,T8>IJD,T8<FJD),T8-IJD,0)))),IF(T8<S8,IF(AND(S8>IJD,S8<FJD,T8>=IJD,T8<FJD),FJD-S8+T8-IJD,IF(AND(S8>=IJD,S8<FJD,T8<IJD),FJD-S8,IF(AND(S8>FJD,T8>IJD,T8<FJD),T8-IJD,IF(AND(S8>FJD,T8>FJD),16,IF(AND(S8<IJD,T8<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H8<>\"N/A\",K8<>\"N/A\"),IF(AN8=0,0,IF(T8>IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8),IF(AND(IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)>=IJD,T8<=FJD),T8-IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8),IF(AND(IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)<IJD,T8>FJD),FJD-IJD,IF(AND(IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)>=IJD,IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)<FJD,T8<24),FJD-IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8),IF(AND(IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)<IJD,T8>IJD,T8<FJD),T8-IJD,0)))),IF(T8<IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8),IF(AND(IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)>IJD,IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)<FJD,T8>=IJD,T8<FJD),FJD-IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)+T8-IJD,IF(AND(IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)>=IJD,IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)<FJD,T8<IJD),FJD-IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8),IF(AND(IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)>FJD,T8>IJD,T8<FJD),T8-IJD,IF(AND(IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)>FJD,T8>FJD),16,IF(AND(IF(S8+AK8-AN8>24,(S8+AK8-AN8)-24,S8+AK8-AN8)<IJD,T8<IJD),16,0)))))))),0)","v":0},0,10,{"$f":"IF(AND(H8=\"N/A\",K8=\"N/A\"),IF(T8>Q8,IF(AND(Q8>=IJD,T8<=FJD),T8-Q8,IF(AND(Q8<IJD,T8>FJD),FJD-IJD,IF(AND(Q8>=IJD,Q8<FJD,T8<24),FJD-Q8,IF(AND(Q8<IJD,T8>IJD,T8<FJD),T8-IJD,0)))),IF(T8<Q8,IF(AND(Q8>IJD,Q8<FJD,T8>=IJD,T8<FJD),FJD-Q8+T8-IJD,IF(AND(Q8>=IJD,Q8<FJD,T8<IJD),FJD-Q8,IF(AND(Q8>FJD,T8>IJD,T8<FJD),T8-IJD,IF(AND(Q8>FJD,T8>FJD),16,IF(AND(Q8<IJD,T8<IJD),16,0))))))),0)","v":2},8,2,{"$f":"IF(AND(H8=\"N/A\",K8=\"N/A\"),IF(AT8=0,0,IF(T8>IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8),IF(AND(IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)>=IJD,T8<=FJD),T8-IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8),IF(AND(IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)<IJD,T8>FJD),FJD-IJD,IF(AND(IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)>=IJD,IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)<FJD,T8<24),FJD-IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8),IF(AND(IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)<IJD,T8>IJD,T8<FJD),T8-IJD,0)))),IF(T8<IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8),IF(AND(IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)>IJD,IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)<FJD,T8>=IJD,T8<FJD),FJD-IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)+T8-IJD,IF(AND(IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)>=IJD,IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)<FJD,T8<IJD),FJD-IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8),IF(AND(IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)>FJD,T8>IJD,T8<FJD),T8-IJD,IF(AND(IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)>FJD,T8>FJD),16,IF(AND(IF(Q8+AQ8-AT8>24,(Q8+AQ8-AT8)-24,Q8+AQ8-AT8)<IJD,T8<IJD),16,0)))))))),0)","v":2},0,{"$f":"X8*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":32400},{"$f":"Z8*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA8*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},39900,{"$f":"IF(Y8>2,\"Excedio el límite de horas Extras en \" & Y8-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.5721889E7,"Johana","Aristizabal",8.0,"08",":","00","12",":","00","14",":","00","18",":","00",8,12,14,18,8,8,{"$f":"ROUND(AC9-AF9+AL9-AO9+AR9-AU9,1)","v":8},0,0,{"$f":"ROUND(AF9+AO9+AU9,1)","v":0},0,4,{"$f":"IF(AND(H9<>\"N/A\",K9<>\"N/A\"),IF(R9>Q9,IF(AND(Q9>=IJD,R9<=FJD),R9-Q9,IF(AND(Q9<IJD,R9>FJD),FJD-IJD,IF(AND(Q9>=IJD,Q9<FJD,R9<24),FJD-Q9,IF(AND(Q9<IJD,R9>IJD,R9<FJD),R9-IJD,0)))),IF(R9<Q9,IF(AND(Q9>IJD,Q9<FJD,R9>=IJD,R9<FJD),FJD-Q9+R9-IJD,IF(AND(Q9>=IJD,Q9<FJD,R9<IJD),FJD-Q9,IF(AND(Q9>FJD,R9>IJD,R9<FJD),R9-IJD,IF(AND(Q9>FJD,R9>FJD),16,IF(AND(Q9<IJD,R9<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H9<>\"N/A\",K9<>\"N/A\"),IF(AE9=0,0,IF(R9>IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9),IF(AND(IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)>=IJD,R9<=FJD),R9-IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9),IF(AND(IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)<IJD,R9>FJD),FJD-IJD,IF(AND(IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)>=IJD,IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)<FJD,R9<24),FJD-IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9),IF(AND(IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)<IJD,R9>IJD,R9<FJD),R9-IJD,0)))),IF(R9<IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9),IF(AND(IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)>IJD,IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)<FJD,R9>=IJD,R9<FJD),FJD-IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)+R9-IJD,IF(AND(IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)>=IJD,IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)<FJD,R9<IJD),FJD-IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9),IF(AND(IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)>FJD,R9>IJD,R9<FJD),R9-IJD,IF(AND(IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)>FJD,R9>FJD),16,IF(AND(IF(Q9+AB9-AE9>24,(Q9+AB9-AE9)-24,Q9+AB9-AE9)<IJD,R9<IJD),16,0)))))))),0)","v":0},0,2,{"$f":"IF(AND(H9<>\"N/A\",K9<>\"N/A\"),IF(S9>R9,IF(AND(R9>=IJD,S9<FJD),S9-R9,IF(AND(R9>=IJD,S9>FJD),IF(R9>FJD,R9-FJD,FJD-R9),IF(AND(R9<IJD,S9>=IJD,S9>FJD),S9-IJD-(S9-FJD),IF(AND(R9<IJD,S9>=IJD),S9-IJD,IF(AND(R9<IJD,S9<IJD),0))))),IF(S9<R9,IF(AND(R9>=FJD,S9<=IJD),0,IF(AND(R9<FJD,S9<=IJD),FJD-R9,IF(AND(R9>FJD,S9>IJD),S9-IJD,IF(AND(R9<FJD,S9>IJD),FJD-R9+S9-IJD)))))),0)","v":2},0,4,{"$f":"IF(AND(H9<>\"N/A\",K9<>\"N/A\"),IF(T9>S9,IF(AND(S9>=IJD,T9<=FJD),T9-S9,IF(AND(S9<IJD,T9>FJD),FJD-IJD,IF(AND(S9>=IJD,S9<FJD,T9<24),FJD-S9,IF(AND(S9<IJD,T9>IJD,T9<FJD),T9-IJD,0)))),IF(T9<S9,IF(AND(S9>IJD,S9<FJD,T9>=IJD,T9<FJD),FJD-S9+T9-IJD,IF(AND(S9>=IJD,S9<FJD,T9<IJD),FJD-S9,IF(AND(S9>FJD,T9>IJD,T9<FJD),T9-IJD,IF(AND(S9>FJD,T9>FJD),16,IF(AND(S9<IJD,T9<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H9<>\"N/A\",K9<>\"N/A\"),IF(AN9=0,0,IF(T9>IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9),IF(AND(IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)>=IJD,T9<=FJD),T9-IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9),IF(AND(IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)<IJD,T9>FJD),FJD-IJD,IF(AND(IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)>=IJD,IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)<FJD,T9<24),FJD-IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9),IF(AND(IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)<IJD,T9>IJD,T9<FJD),T9-IJD,0)))),IF(T9<IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9),IF(AND(IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)>IJD,IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)<FJD,T9>=IJD,T9<FJD),FJD-IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)+T9-IJD,IF(AND(IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)>=IJD,IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)<FJD,T9<IJD),FJD-IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9),IF(AND(IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)>FJD,T9>IJD,T9<FJD),T9-IJD,IF(AND(IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)>FJD,T9>FJD),16,IF(AND(IF(S9+AK9-AN9>24,(S9+AK9-AN9)-24,S9+AK9-AN9)<IJD,T9<IJD),16,0)))))))),0)","v":0},0,0,{"$f":"IF(AND(H9=\"N/A\",K9=\"N/A\"),IF(T9>Q9,IF(AND(Q9>=IJD,T9<=FJD),T9-Q9,IF(AND(Q9<IJD,T9>FJD),FJD-IJD,IF(AND(Q9>=IJD,Q9<FJD,T9<24),FJD-Q9,IF(AND(Q9<IJD,T9>IJD,T9<FJD),T9-IJD,0)))),IF(T9<Q9,IF(AND(Q9>IJD,Q9<FJD,T9>=IJD,T9<FJD),FJD-Q9+T9-IJD,IF(AND(Q9>=IJD,Q9<FJD,T9<IJD),FJD-Q9,IF(AND(Q9>FJD,T9>IJD,T9<FJD),T9-IJD,IF(AND(Q9>FJD,T9>FJD),16,IF(AND(Q9<IJD,T9<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H9=\"N/A\",K9=\"N/A\"),IF(AT9=0,0,IF(T9>IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9),IF(AND(IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)>=IJD,T9<=FJD),T9-IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9),IF(AND(IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)<IJD,T9>FJD),FJD-IJD,IF(AND(IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)>=IJD,IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)<FJD,T9<24),FJD-IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9),IF(AND(IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)<IJD,T9>IJD,T9<FJD),T9-IJD,0)))),IF(T9<IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9),IF(AND(IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)>IJD,IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)<FJD,T9>=IJD,T9<FJD),FJD-IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)+T9-IJD,IF(AND(IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)>=IJD,IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)<FJD,T9<IJD),FJD-IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9),IF(AND(IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)>FJD,T9>IJD,T9<FJD),T9-IJD,IF(AND(IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)>FJD,T9>FJD),16,IF(AND(IF(Q9+AQ9-AT9>24,(Q9+AQ9-AT9)-24,Q9+AQ9-AT9)<IJD,T9<IJD),16,0)))))))),0)","v":0},0,{"$f":"X9*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z9*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":0},{"$f":"AA9*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},0,{"$f":"IF(Y9>2,\"Excedio el límite de horas Extras en \" & Y9-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.2722045E7,"Jose","Contreras",8.0,"08",":","00","12",":","00","14",":","00","20",":","00",8,12,14,20,10,8,{"$f":"ROUND(AC10-AF10+AL10-AO10+AR10-AU10,1)","v":8},0,2,{"$f":"ROUND(AF10+AO10+AU10,1)","v":2},0,4,{"$f":"IF(AND(H10<>\"N/A\",K10<>\"N/A\"),IF(R10>Q10,IF(AND(Q10>=IJD,R10<=FJD),R10-Q10,IF(AND(Q10<IJD,R10>FJD),FJD-IJD,IF(AND(Q10>=IJD,Q10<FJD,R10<24),FJD-Q10,IF(AND(Q10<IJD,R10>IJD,R10<FJD),R10-IJD,0)))),IF(R10<Q10,IF(AND(Q10>IJD,Q10<FJD,R10>=IJD,R10<FJD),FJD-Q10+R10-IJD,IF(AND(Q10>=IJD,Q10<FJD,R10<IJD),FJD-Q10,IF(AND(Q10>FJD,R10>IJD,R10<FJD),R10-IJD,IF(AND(Q10>FJD,R10>FJD),16,IF(AND(Q10<IJD,R10<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H10<>\"N/A\",K10<>\"N/A\"),IF(AE10=0,0,IF(R10>IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10),IF(AND(IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)>=IJD,R10<=FJD),R10-IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10),IF(AND(IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)<IJD,R10>FJD),FJD-IJD,IF(AND(IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)>=IJD,IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)<FJD,R10<24),FJD-IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10),IF(AND(IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)<IJD,R10>IJD,R10<FJD),R10-IJD,0)))),IF(R10<IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10),IF(AND(IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)>IJD,IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)<FJD,R10>=IJD,R10<FJD),FJD-IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)+R10-IJD,IF(AND(IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)>=IJD,IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)<FJD,R10<IJD),FJD-IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10),IF(AND(IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)>FJD,R10>IJD,R10<FJD),R10-IJD,IF(AND(IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)>FJD,R10>FJD),16,IF(AND(IF(Q10+AB10-AE10>24,(Q10+AB10-AE10)-24,Q10+AB10-AE10)<IJD,R10<IJD),16,0)))))))),0)","v":0},0,2,{"$f":"IF(AND(H10<>\"N/A\",K10<>\"N/A\"),IF(S10>R10,IF(AND(R10>=IJD,S10<FJD),S10-R10,IF(AND(R10>=IJD,S10>FJD),IF(R10>FJD,R10-FJD,FJD-R10),IF(AND(R10<IJD,S10>=IJD,S10>FJD),S10-IJD-(S10-FJD),IF(AND(R10<IJD,S10>=IJD),S10-IJD,IF(AND(R10<IJD,S10<IJD),0))))),IF(S10<R10,IF(AND(R10>=FJD,S10<=IJD),0,IF(AND(R10<FJD,S10<=IJD),FJD-R10,IF(AND(R10>FJD,S10>IJD),S10-IJD,IF(AND(R10<FJD,S10>IJD),FJD-R10+S10-IJD)))))),0)","v":2},0,6,{"$f":"IF(AND(H10<>\"N/A\",K10<>\"N/A\"),IF(T10>S10,IF(AND(S10>=IJD,T10<=FJD),T10-S10,IF(AND(S10<IJD,T10>FJD),FJD-IJD,IF(AND(S10>=IJD,S10<FJD,T10<24),FJD-S10,IF(AND(S10<IJD,T10>IJD,T10<FJD),T10-IJD,0)))),IF(T10<S10,IF(AND(S10>IJD,S10<FJD,T10>=IJD,T10<FJD),FJD-S10+T10-IJD,IF(AND(S10>=IJD,S10<FJD,T10<IJD),FJD-S10,IF(AND(S10>FJD,T10>IJD,T10<FJD),T10-IJD,IF(AND(S10>FJD,T10>FJD),16,IF(AND(S10<IJD,T10<IJD),16,0))))))),0)","v":6},0,2,{"$f":"IF(AND(H10<>\"N/A\",K10<>\"N/A\"),IF(AN10=0,0,IF(T10>IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10),IF(AND(IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)>=IJD,T10<=FJD),T10-IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10),IF(AND(IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)<IJD,T10>FJD),FJD-IJD,IF(AND(IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)>=IJD,IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)<FJD,T10<24),FJD-IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10),IF(AND(IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)<IJD,T10>IJD,T10<FJD),T10-IJD,0)))),IF(T10<IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10),IF(AND(IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)>IJD,IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)<FJD,T10>=IJD,T10<FJD),FJD-IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)+T10-IJD,IF(AND(IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)>=IJD,IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)<FJD,T10<IJD),FJD-IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10),IF(AND(IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)>FJD,T10>IJD,T10<FJD),T10-IJD,IF(AND(IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)>FJD,T10>FJD),16,IF(AND(IF(S10+AK10-AN10>24,(S10+AK10-AN10)-24,S10+AK10-AN10)<IJD,T10<IJD),16,0)))))))),0)","v":2},0,0,{"$f":"IF(AND(H10=\"N/A\",K10=\"N/A\"),IF(T10>Q10,IF(AND(Q10>=IJD,T10<=FJD),T10-Q10,IF(AND(Q10<IJD,T10>FJD),FJD-IJD,IF(AND(Q10>=IJD,Q10<FJD,T10<24),FJD-Q10,IF(AND(Q10<IJD,T10>IJD,T10<FJD),T10-IJD,0)))),IF(T10<Q10,IF(AND(Q10>IJD,Q10<FJD,T10>=IJD,T10<FJD),FJD-Q10+T10-IJD,IF(AND(Q10>=IJD,Q10<FJD,T10<IJD),FJD-Q10,IF(AND(Q10>FJD,T10>IJD,T10<FJD),T10-IJD,IF(AND(Q10>FJD,T10>FJD),16,IF(AND(Q10<IJD,T10<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H10=\"N/A\",K10=\"N/A\"),IF(AT10=0,0,IF(T10>IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10),IF(AND(IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)>=IJD,T10<=FJD),T10-IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10),IF(AND(IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)<IJD,T10>FJD),FJD-IJD,IF(AND(IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)>=IJD,IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)<FJD,T10<24),FJD-IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10),IF(AND(IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)<IJD,T10>IJD,T10<FJD),T10-IJD,0)))),IF(T10<IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10),IF(AND(IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)>IJD,IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)<FJD,T10>=IJD,T10<FJD),FJD-IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)+T10-IJD,IF(AND(IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)>=IJD,IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)<FJD,T10<IJD),FJD-IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10),IF(AND(IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)>FJD,T10>IJD,T10<FJD),T10-IJD,IF(AND(IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)>FJD,T10>FJD),16,IF(AND(IF(Q10+AQ10-AT10>24,(Q10+AQ10-AT10)-24,Q10+AQ10-AT10)<IJD,T10<IJD),16,0)))))))),0)","v":0},0,{"$f":"X10*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z10*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA10*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},7500,{"$f":"IF(Y10>2,\"Excedio el límite de horas Extras en \" & Y10-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.7527365E7,"Mauricio","Gutierrez",8.0,"14",":","00","18",":","00","19",":","00","01",":","00",14,18,19,1,10,8,{"$f":"ROUND(AC11-AF11+AL11-AO11+AR11-AU11,1)","v":6},2,2,{"$f":"ROUND(AF11+AO11+AU11,1)","v":0},2,4,{"$f":"IF(AND(H11<>\"N/A\",K11<>\"N/A\"),IF(R11>Q11,IF(AND(Q11>=IJD,R11<=FJD),R11-Q11,IF(AND(Q11<IJD,R11>FJD),FJD-IJD,IF(AND(Q11>=IJD,Q11<FJD,R11<24),FJD-Q11,IF(AND(Q11<IJD,R11>IJD,R11<FJD),R11-IJD,0)))),IF(R11<Q11,IF(AND(Q11>IJD,Q11<FJD,R11>=IJD,R11<FJD),FJD-Q11+R11-IJD,IF(AND(Q11>=IJD,Q11<FJD,R11<IJD),FJD-Q11,IF(AND(Q11>FJD,R11>IJD,R11<FJD),R11-IJD,IF(AND(Q11>FJD,R11>FJD),16,IF(AND(Q11<IJD,R11<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H11<>\"N/A\",K11<>\"N/A\"),IF(AE11=0,0,IF(R11>IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11),IF(AND(IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)>=IJD,R11<=FJD),R11-IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11),IF(AND(IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)<IJD,R11>FJD),FJD-IJD,IF(AND(IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)>=IJD,IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)<FJD,R11<24),FJD-IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11),IF(AND(IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)<IJD,R11>IJD,R11<FJD),R11-IJD,0)))),IF(R11<IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11),IF(AND(IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)>IJD,IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)<FJD,R11>=IJD,R11<FJD),FJD-IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)+R11-IJD,IF(AND(IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)>=IJD,IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)<FJD,R11<IJD),FJD-IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11),IF(AND(IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)>FJD,R11>IJD,R11<FJD),R11-IJD,IF(AND(IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)>FJD,R11>FJD),16,IF(AND(IF(Q11+AB11-AE11>24,(Q11+AB11-AE11)-24,Q11+AB11-AE11)<IJD,R11<IJD),16,0)))))))),0)","v":0},0,1,{"$f":"IF(AND(H11<>\"N/A\",K11<>\"N/A\"),IF(S11>R11,IF(AND(R11>=IJD,S11<FJD),S11-R11,IF(AND(R11>=IJD,S11>FJD),IF(R11>FJD,R11-FJD,FJD-R11),IF(AND(R11<IJD,S11>=IJD,S11>FJD),S11-IJD-(S11-FJD),IF(AND(R11<IJD,S11>=IJD),S11-IJD,IF(AND(R11<IJD,S11<IJD),0))))),IF(S11<R11,IF(AND(R11>=FJD,S11<=IJD),0,IF(AND(R11<FJD,S11<=IJD),FJD-R11,IF(AND(R11>FJD,S11>IJD),S11-IJD,IF(AND(R11<FJD,S11>IJD),FJD-R11+S11-IJD)))))),0)","v":1},0,6,{"$f":"IF(AND(H11<>\"N/A\",K11<>\"N/A\"),IF(T11>S11,IF(AND(S11>=IJD,T11<=FJD),T11-S11,IF(AND(S11<IJD,T11>FJD),FJD-IJD,IF(AND(S11>=IJD,S11<FJD,T11<24),FJD-S11,IF(AND(S11<IJD,T11>IJD,T11<FJD),T11-IJD,0)))),IF(T11<S11,IF(AND(S11>IJD,S11<FJD,T11>=IJD,T11<FJD),FJD-S11+T11-IJD,IF(AND(S11>=IJD,S11<FJD,T11<IJD),FJD-S11,IF(AND(S11>FJD,T11>IJD,T11<FJD),T11-IJD,IF(AND(S11>FJD,T11>FJD),16,IF(AND(S11<IJD,T11<IJD),16,0))))))),0)","v":1.983333333},4.016666667,2,{"$f":"IF(AND(H11<>\"N/A\",K11<>\"N/A\"),IF(AN11=0,0,IF(T11>IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11),IF(AND(IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)>=IJD,T11<=FJD),T11-IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11),IF(AND(IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)<IJD,T11>FJD),FJD-IJD,IF(AND(IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)>=IJD,IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)<FJD,T11<24),FJD-IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11),IF(AND(IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)<IJD,T11>IJD,T11<FJD),T11-IJD,0)))),IF(T11<IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11),IF(AND(IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)>IJD,IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)<FJD,T11>=IJD,T11<FJD),FJD-IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)+T11-IJD,IF(AND(IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)>=IJD,IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)<FJD,T11<IJD),FJD-IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11),IF(AND(IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)>FJD,T11>IJD,T11<FJD),T11-IJD,IF(AND(IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)>FJD,T11>FJD),16,IF(AND(IF(S11+AK11-AN11>24,(S11+AK11-AN11)-24,S11+AK11-AN11)<IJD,T11<IJD),16,0)))))))),0)","v":0},2,0,{"$f":"IF(AND(H11=\"N/A\",K11=\"N/A\"),IF(T11>Q11,IF(AND(Q11>=IJD,T11<=FJD),T11-Q11,IF(AND(Q11<IJD,T11>FJD),FJD-IJD,IF(AND(Q11>=IJD,Q11<FJD,T11<24),FJD-Q11,IF(AND(Q11<IJD,T11>IJD,T11<FJD),T11-IJD,0)))),IF(T11<Q11,IF(AND(Q11>IJD,Q11<FJD,T11>=IJD,T11<FJD),FJD-Q11+T11-IJD,IF(AND(Q11>=IJD,Q11<FJD,T11<IJD),FJD-Q11,IF(AND(Q11>FJD,T11>IJD,T11<FJD),T11-IJD,IF(AND(Q11>FJD,T11>FJD),16,IF(AND(Q11<IJD,T11<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H11=\"N/A\",K11=\"N/A\"),IF(AT11=0,0,IF(T11>IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11),IF(AND(IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)>=IJD,T11<=FJD),T11-IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11),IF(AND(IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)<IJD,T11>FJD),FJD-IJD,IF(AND(IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)>=IJD,IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)<FJD,T11<24),FJD-IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11),IF(AND(IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)<IJD,T11>IJD,T11<FJD),T11-IJD,0)))),IF(T11<IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11),IF(AND(IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)>IJD,IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)<FJD,T11>=IJD,T11<FJD),FJD-IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)+T11-IJD,IF(AND(IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)>=IJD,IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)<FJD,T11<IJD),FJD-IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11),IF(AND(IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)>FJD,T11>IJD,T11<FJD),T11-IJD,IF(AND(IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)>FJD,T11>FJD),16,IF(AND(IF(Q11+AQ11-AT11>24,(Q11+AQ11-AT11)-24,Q11+AQ11-AT11)<IJD,T11<IJD),16,0)))))))),0)","v":0},0,{"$f":"X11*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":8100},{"$f":"Z11*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":0},{"$f":"AA11*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":10500},18600,{"$f":"IF(Y11>2,\"Excedio el límite de horas Extras en \" & Y11-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.707096E7,"Maryi","Alvarez",8.0,"08",":","00","12",":","00","15",":","00","23",":","00",8,12,15,23,12,8,{"$f":"ROUND(AC12-AF12+AL12-AO12+AR12-AU12,1)","v":8},0,4,{"$f":"ROUND(AF12+AO12+AU12,1)","v":2},2,4,{"$f":"IF(AND(H12<>\"N/A\",K12<>\"N/A\"),IF(R12>Q12,IF(AND(Q12>=IJD,R12<=FJD),R12-Q12,IF(AND(Q12<IJD,R12>FJD),FJD-IJD,IF(AND(Q12>=IJD,Q12<FJD,R12<24),FJD-Q12,IF(AND(Q12<IJD,R12>IJD,R12<FJD),R12-IJD,0)))),IF(R12<Q12,IF(AND(Q12>IJD,Q12<FJD,R12>=IJD,R12<FJD),FJD-Q12+R12-IJD,IF(AND(Q12>=IJD,Q12<FJD,R12<IJD),FJD-Q12,IF(AND(Q12>FJD,R12>IJD,R12<FJD),R12-IJD,IF(AND(Q12>FJD,R12>FJD),16,IF(AND(Q12<IJD,R12<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H12<>\"N/A\",K12<>\"N/A\"),IF(AE12=0,0,IF(R12>IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12),IF(AND(IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)>=IJD,R12<=FJD),R12-IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12),IF(AND(IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)<IJD,R12>FJD),FJD-IJD,IF(AND(IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)>=IJD,IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)<FJD,R12<24),FJD-IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12),IF(AND(IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)<IJD,R12>IJD,R12<FJD),R12-IJD,0)))),IF(R12<IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12),IF(AND(IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)>IJD,IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)<FJD,R12>=IJD,R12<FJD),FJD-IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)+R12-IJD,IF(AND(IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)>=IJD,IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)<FJD,R12<IJD),FJD-IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12),IF(AND(IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)>FJD,R12>IJD,R12<FJD),R12-IJD,IF(AND(IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)>FJD,R12>FJD),16,IF(AND(IF(Q12+AB12-AE12>24,(Q12+AB12-AE12)-24,Q12+AB12-AE12)<IJD,R12<IJD),16,0)))))))),0)","v":0},0,3,{"$f":"IF(AND(H12<>\"N/A\",K12<>\"N/A\"),IF(S12>R12,IF(AND(R12>=IJD,S12<FJD),S12-R12,IF(AND(R12>=IJD,S12>FJD),IF(R12>FJD,R12-FJD,FJD-R12),IF(AND(R12<IJD,S12>=IJD,S12>FJD),S12-IJD-(S12-FJD),IF(AND(R12<IJD,S12>=IJD),S12-IJD,IF(AND(R12<IJD,S12<IJD),0))))),IF(S12<R12,IF(AND(R12>=FJD,S12<=IJD),0,IF(AND(R12<FJD,S12<=IJD),FJD-R12,IF(AND(R12>FJD,S12>IJD),S12-IJD,IF(AND(R12<FJD,S12>IJD),FJD-R12+S12-IJD)))))),0)","v":3},0,8,{"$f":"IF(AND(H12<>\"N/A\",K12<>\"N/A\"),IF(T12>S12,IF(AND(S12>=IJD,T12<=FJD),T12-S12,IF(AND(S12<IJD,T12>FJD),FJD-IJD,IF(AND(S12>=IJD,S12<FJD,T12<24),FJD-S12,IF(AND(S12<IJD,T12>IJD,T12<FJD),T12-IJD,0)))),IF(T12<S12,IF(AND(S12>IJD,S12<FJD,T12>=IJD,T12<FJD),FJD-S12+T12-IJD,IF(AND(S12>=IJD,S12<FJD,T12<IJD),FJD-S12,IF(AND(S12>FJD,T12>IJD,T12<FJD),T12-IJD,IF(AND(S12>FJD,T12>FJD),16,IF(AND(S12<IJD,T12<IJD),16,0))))))),0)","v":5.983333333},2.016666667,4,{"$f":"IF(AND(H12<>\"N/A\",K12<>\"N/A\"),IF(AN12=0,0,IF(T12>IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12),IF(AND(IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)>=IJD,T12<=FJD),T12-IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12),IF(AND(IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)<IJD,T12>FJD),FJD-IJD,IF(AND(IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)>=IJD,IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)<FJD,T12<24),FJD-IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12),IF(AND(IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)<IJD,T12>IJD,T12<FJD),T12-IJD,0)))),IF(T12<IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12),IF(AND(IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)>IJD,IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)<FJD,T12>=IJD,T12<FJD),FJD-IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)+T12-IJD,IF(AND(IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)>=IJD,IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)<FJD,T12<IJD),FJD-IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12),IF(AND(IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)>FJD,T12>IJD,T12<FJD),T12-IJD,IF(AND(IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)>FJD,T12>FJD),16,IF(AND(IF(S12+AK12-AN12>24,(S12+AK12-AN12)-24,S12+AK12-AN12)<IJD,T12<IJD),16,0)))))))),0)","v":1.983333333},2.016666667,0,{"$f":"IF(AND(H12=\"N/A\",K12=\"N/A\"),IF(T12>Q12,IF(AND(Q12>=IJD,T12<=FJD),T12-Q12,IF(AND(Q12<IJD,T12>FJD),FJD-IJD,IF(AND(Q12>=IJD,Q12<FJD,T12<24),FJD-Q12,IF(AND(Q12<IJD,T12>IJD,T12<FJD),T12-IJD,0)))),IF(T12<Q12,IF(AND(Q12>IJD,Q12<FJD,T12>=IJD,T12<FJD),FJD-Q12+T12-IJD,IF(AND(Q12>=IJD,Q12<FJD,T12<IJD),FJD-Q12,IF(AND(Q12>FJD,T12>IJD,T12<FJD),T12-IJD,IF(AND(Q12>FJD,T12>FJD),16,IF(AND(Q12<IJD,T12<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H12=\"N/A\",K12=\"N/A\"),IF(AT12=0,0,IF(T12>IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12),IF(AND(IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)>=IJD,T12<=FJD),T12-IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12),IF(AND(IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)<IJD,T12>FJD),FJD-IJD,IF(AND(IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)>=IJD,IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)<FJD,T12<24),FJD-IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12),IF(AND(IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)<IJD,T12>IJD,T12<FJD),T12-IJD,0)))),IF(T12<IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12),IF(AND(IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)>IJD,IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)<FJD,T12>=IJD,T12<FJD),FJD-IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)+T12-IJD,IF(AND(IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)>=IJD,IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)<FJD,T12<IJD),FJD-IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12),IF(AND(IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)>FJD,T12>IJD,T12<FJD),T12-IJD,IF(AND(IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)>FJD,T12>FJD),16,IF(AND(IF(Q12+AQ12-AT12>24,(Q12+AQ12-AT12)-24,Q12+AQ12-AT12)<IJD,T12<IJD),16,0)))))))),0)","v":0},0,{"$f":"X12*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z12*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA12*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":10500},18000,{"$f":"IF(Y12>2,\"Excedio el límite de horas Extras en \" & Y12-LIMITEHORASEXTRAXDIA,\"\")","v":"Excedio el límite de horas Extras en 2"}]
[9.4144851E7,"Diana","Escobar",8.0,"18",":","00","N/A",":","N/A","N/A",":","N/A","02",":","00",18,"#VALUE!","#VALUE!",2,8,8,{"$f":"ROUND(AC13-AF13+AL13-AO13+AR13-AU13,1)","v":3},5,0,{"$f":"ROUND(AF13+AO13+AU13,1)","v":0},0,0,{"$f":"IF(AND(H13<>\"N/A\",K13<>\"N/A\"),IF(R13>Q13,IF(AND(Q13>=IJD,R13<=FJD),R13-Q13,IF(AND(Q13<IJD,R13>FJD),FJD-IJD,IF(AND(Q13>=IJD,Q13<FJD,R13<24),FJD-Q13,IF(AND(Q13<IJD,R13>IJD,R13<FJD),R13-IJD,0)))),IF(R13<Q13,IF(AND(Q13>IJD,Q13<FJD,R13>=IJD,R13<FJD),FJD-Q13+R13-IJD,IF(AND(Q13>=IJD,Q13<FJD,R13<IJD),FJD-Q13,IF(AND(Q13>FJD,R13>IJD,R13<FJD),R13-IJD,IF(AND(Q13>FJD,R13>FJD),16,IF(AND(Q13<IJD,R13<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H13<>\"N/A\",K13<>\"N/A\"),IF(AE13=0,0,IF(R13>IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13),IF(AND(IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)>=IJD,R13<=FJD),R13-IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13),IF(AND(IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)<IJD,R13>FJD),FJD-IJD,IF(AND(IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)>=IJD,IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)<FJD,R13<24),FJD-IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13),IF(AND(IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)<IJD,R13>IJD,R13<FJD),R13-IJD,0)))),IF(R13<IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13),IF(AND(IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)>IJD,IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)<FJD,R13>=IJD,R13<FJD),FJD-IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)+R13-IJD,IF(AND(IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)>=IJD,IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)<FJD,R13<IJD),FJD-IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13),IF(AND(IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)>FJD,R13>IJD,R13<FJD),R13-IJD,IF(AND(IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)>FJD,R13>FJD),16,IF(AND(IF(Q13+AB13-AE13>24,(Q13+AB13-AE13)-24,Q13+AB13-AE13)<IJD,R13<IJD),16,0)))))))),0)","v":0},0,0,{"$f":"IF(AND(H13<>\"N/A\",K13<>\"N/A\"),IF(S13>R13,IF(AND(R13>=IJD,S13<FJD),S13-R13,IF(AND(R13>=IJD,S13>FJD),IF(R13>FJD,R13-FJD,FJD-R13),IF(AND(R13<IJD,S13>=IJD,S13>FJD),S13-IJD-(S13-FJD),IF(AND(R13<IJD,S13>=IJD),S13-IJD,IF(AND(R13<IJD,S13<IJD),0))))),IF(S13<R13,IF(AND(R13>=FJD,S13<=IJD),0,IF(AND(R13<FJD,S13<=IJD),FJD-R13,IF(AND(R13>FJD,S13>IJD),S13-IJD,IF(AND(R13<FJD,S13>IJD),FJD-R13+S13-IJD)))))),0)","v":0},0,0,{"$f":"IF(AND(H13<>\"N/A\",K13<>\"N/A\"),IF(T13>S13,IF(AND(S13>=IJD,T13<=FJD),T13-S13,IF(AND(S13<IJD,T13>FJD),FJD-IJD,IF(AND(S13>=IJD,S13<FJD,T13<24),FJD-S13,IF(AND(S13<IJD,T13>IJD,T13<FJD),T13-IJD,0)))),IF(T13<S13,IF(AND(S13>IJD,S13<FJD,T13>=IJD,T13<FJD),FJD-S13+T13-IJD,IF(AND(S13>=IJD,S13<FJD,T13<IJD),FJD-S13,IF(AND(S13>FJD,T13>IJD,T13<FJD),T13-IJD,IF(AND(S13>FJD,T13>FJD),16,IF(AND(S13<IJD,T13<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H13<>\"N/A\",K13<>\"N/A\"),IF(AN13=0,0,IF(T13>IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13),IF(AND(IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)>=IJD,T13<=FJD),T13-IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13),IF(AND(IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)<IJD,T13>FJD),FJD-IJD,IF(AND(IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)>=IJD,IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)<FJD,T13<24),FJD-IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13),IF(AND(IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)<IJD,T13>IJD,T13<FJD),T13-IJD,0)))),IF(T13<IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13),IF(AND(IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)>IJD,IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)<FJD,T13>=IJD,T13<FJD),FJD-IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)+T13-IJD,IF(AND(IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)>=IJD,IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)<FJD,T13<IJD),FJD-IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13),IF(AND(IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)>FJD,T13>IJD,T13<FJD),T13-IJD,IF(AND(IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)>FJD,T13>FJD),16,IF(AND(IF(S13+AK13-AN13>24,(S13+AK13-AN13)-24,S13+AK13-AN13)<IJD,T13<IJD),16,0)))))))),0)","v":0},0,8,{"$f":"IF(AND(H13=\"N/A\",K13=\"N/A\"),IF(T13>Q13,IF(AND(Q13>=IJD,T13<=FJD),T13-Q13,IF(AND(Q13<IJD,T13>FJD),FJD-IJD,IF(AND(Q13>=IJD,Q13<FJD,T13<24),FJD-Q13,IF(AND(Q13<IJD,T13>IJD,T13<FJD),T13-IJD,0)))),IF(T13<Q13,IF(AND(Q13>IJD,Q13<FJD,T13>=IJD,T13<FJD),FJD-Q13+T13-IJD,IF(AND(Q13>=IJD,Q13<FJD,T13<IJD),FJD-Q13,IF(AND(Q13>FJD,T13>IJD,T13<FJD),T13-IJD,IF(AND(Q13>FJD,T13>FJD),16,IF(AND(Q13<IJD,T13<IJD),16,0))))))),0)","v":2.983333333},5.016666667,0,{"$f":"IF(AND(H13=\"N/A\",K13=\"N/A\"),IF(AT13=0,0,IF(T13>IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13),IF(AND(IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)>=IJD,T13<=FJD),T13-IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13),IF(AND(IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)<IJD,T13>FJD),FJD-IJD,IF(AND(IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)>=IJD,IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)<FJD,T13<24),FJD-IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13),IF(AND(IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)<IJD,T13>IJD,T13<FJD),T13-IJD,0)))),IF(T13<IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13),IF(AND(IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)>IJD,IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)<FJD,T13>=IJD,T13<FJD),FJD-IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)+T13-IJD,IF(AND(IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)>=IJD,IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)<FJD,T13<IJD),FJD-IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13),IF(AND(IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)>FJD,T13>IJD,T13<FJD),T13-IJD,IF(AND(IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)>FJD,T13>FJD),16,IF(AND(IF(Q13+AQ13-AT13>24,(Q13+AQ13-AT13)-24,Q13+AQ13-AT13)<IJD,T13<IJD),16,0)))))))),0)","v":0},0,{"$f":"X13*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":20250},{"$f":"Z13*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":0},{"$f":"AA13*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},20250,{"$f":"IF(Y13>2,\"Excedio el límite de horas Extras en \" & Y13-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.2931162E7,"Andres","Lopez",8.0,"22",":","00","N/A",":","N/A","N/A",":","N/A","08",":","00",22,"#VALUE!","#VALUE!",8,10,8,{"$f":"ROUND(AC14-AF14+AL14-AO14+AR14-AU14,1)","v":0},8,2,{"$f":"ROUND(AF14+AO14+AU14,1)","v":2},0,0,{"$f":"IF(AND(H14<>\"N/A\",K14<>\"N/A\"),IF(R14>Q14,IF(AND(Q14>=IJD,R14<=FJD),R14-Q14,IF(AND(Q14<IJD,R14>FJD),FJD-IJD,IF(AND(Q14>=IJD,Q14<FJD,R14<24),FJD-Q14,IF(AND(Q14<IJD,R14>IJD,R14<FJD),R14-IJD,0)))),IF(R14<Q14,IF(AND(Q14>IJD,Q14<FJD,R14>=IJD,R14<FJD),FJD-Q14+R14-IJD,IF(AND(Q14>=IJD,Q14<FJD,R14<IJD),FJD-Q14,IF(AND(Q14>FJD,R14>IJD,R14<FJD),R14-IJD,IF(AND(Q14>FJD,R14>FJD),16,IF(AND(Q14<IJD,R14<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H14<>\"N/A\",K14<>\"N/A\"),IF(AE14=0,0,IF(R14>IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14),IF(AND(IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)>=IJD,R14<=FJD),R14-IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14),IF(AND(IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)<IJD,R14>FJD),FJD-IJD,IF(AND(IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)>=IJD,IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)<FJD,R14<24),FJD-IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14),IF(AND(IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)<IJD,R14>IJD,R14<FJD),R14-IJD,0)))),IF(R14<IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14),IF(AND(IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)>IJD,IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)<FJD,R14>=IJD,R14<FJD),FJD-IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)+R14-IJD,IF(AND(IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)>=IJD,IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)<FJD,R14<IJD),FJD-IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14),IF(AND(IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)>FJD,R14>IJD,R14<FJD),R14-IJD,IF(AND(IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)>FJD,R14>FJD),16,IF(AND(IF(Q14+AB14-AE14>24,(Q14+AB14-AE14)-24,Q14+AB14-AE14)<IJD,R14<IJD),16,0)))))))),0)","v":0},0,0,{"$f":"IF(AND(H14<>\"N/A\",K14<>\"N/A\"),IF(S14>R14,IF(AND(R14>=IJD,S14<FJD),S14-R14,IF(AND(R14>=IJD,S14>FJD),IF(R14>FJD,R14-FJD,FJD-R14),IF(AND(R14<IJD,S14>=IJD,S14>FJD),S14-IJD-(S14-FJD),IF(AND(R14<IJD,S14>=IJD),S14-IJD,IF(AND(R14<IJD,S14<IJD),0))))),IF(S14<R14,IF(AND(R14>=FJD,S14<=IJD),0,IF(AND(R14<FJD,S14<=IJD),FJD-R14,IF(AND(R14>FJD,S14>IJD),S14-IJD,IF(AND(R14<FJD,S14>IJD),FJD-R14+S14-IJD)))))),0)","v":0},0,0,{"$f":"IF(AND(H14<>\"N/A\",K14<>\"N/A\"),IF(T14>S14,IF(AND(S14>=IJD,T14<=FJD),T14-S14,IF(AND(S14<IJD,T14>FJD),FJD-IJD,IF(AND(S14>=IJD,S14<FJD,T14<24),FJD-S14,IF(AND(S14<IJD,T14>IJD,T14<FJD),T14-IJD,0)))),IF(T14<S14,IF(AND(S14>IJD,S14<FJD,T14>=IJD,T14<FJD),FJD-S14+T14-IJD,IF(AND(S14>=IJD,S14<FJD,T14<IJD),FJD-S14,IF(AND(S14>FJD,T14>IJD,T14<FJD),T14-IJD,IF(AND(S14>FJD,T14>FJD),16,IF(AND(S14<IJD,T14<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H14<>\"N/A\",K14<>\"N/A\"),IF(AN14=0,0,IF(T14>IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14),IF(AND(IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)>=IJD,T14<=FJD),T14-IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14),IF(AND(IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)<IJD,T14>FJD),FJD-IJD,IF(AND(IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)>=IJD,IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)<FJD,T14<24),FJD-IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14),IF(AND(IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)<IJD,T14>IJD,T14<FJD),T14-IJD,0)))),IF(T14<IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14),IF(AND(IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)>IJD,IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)<FJD,T14>=IJD,T14<FJD),FJD-IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)+T14-IJD,IF(AND(IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)>=IJD,IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)<FJD,T14<IJD),FJD-IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14),IF(AND(IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)>FJD,T14>IJD,T14<FJD),T14-IJD,IF(AND(IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)>FJD,T14>FJD),16,IF(AND(IF(S14+AK14-AN14>24,(S14+AK14-AN14)-24,S14+AK14-AN14)<IJD,T14<IJD),16,0)))))))),0)","v":0},0,10,{"$f":"IF(AND(H14=\"N/A\",K14=\"N/A\"),IF(T14>Q14,IF(AND(Q14>=IJD,T14<=FJD),T14-Q14,IF(AND(Q14<IJD,T14>FJD),FJD-IJD,IF(AND(Q14>=IJD,Q14<FJD,T14<24),FJD-Q14,IF(AND(Q14<IJD,T14>IJD,T14<FJD),T14-IJD,0)))),IF(T14<Q14,IF(AND(Q14>IJD,Q14<FJD,T14>=IJD,T14<FJD),FJD-Q14+T14-IJD,IF(AND(Q14>=IJD,Q14<FJD,T14<IJD),FJD-Q14,IF(AND(Q14>FJD,T14>IJD,T14<FJD),T14-IJD,IF(AND(Q14>FJD,T14>FJD),16,IF(AND(Q14<IJD,T14<IJD),16,0))))))),0)","v":2},8,2,{"$f":"IF(AND(H14=\"N/A\",K14=\"N/A\"),IF(AT14=0,0,IF(T14>IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14),IF(AND(IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)>=IJD,T14<=FJD),T14-IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14),IF(AND(IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)<IJD,T14>FJD),FJD-IJD,IF(AND(IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)>=IJD,IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)<FJD,T14<24),FJD-IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14),IF(AND(IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)<IJD,T14>IJD,T14<FJD),T14-IJD,0)))),IF(T14<IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14),IF(AND(IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)>IJD,IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)<FJD,T14>=IJD,T14<FJD),FJD-IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)+T14-IJD,IF(AND(IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)>=IJD,IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)<FJD,T14<IJD),FJD-IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14),IF(AND(IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)>FJD,T14>IJD,T14<FJD),T14-IJD,IF(AND(IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)>FJD,T14>FJD),16,IF(AND(IF(Q14+AQ14-AT14>24,(Q14+AQ14-AT14)-24,Q14+AQ14-AT14)<IJD,T14<IJD),16,0)))))))),0)","v":2},0,{"$f":"X14*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":32400},{"$f":"Z14*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA14*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},39900,{"$f":"IF(Y14>2,\"Excedio el límite de horas Extras en \" & Y14-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.6554557E7,"David","Bedoya",8.0,"08",":","00","12",":","00","14",":","00","18",":","00",8,12,14,18,8,8,{"$f":"ROUND(AC15-AF15+AL15-AO15+AR15-AU15,1)","v":8},0,0,{"$f":"ROUND(AF15+AO15+AU15,1)","v":0},0,4,{"$f":"IF(AND(H15<>\"N/A\",K15<>\"N/A\"),IF(R15>Q15,IF(AND(Q15>=IJD,R15<=FJD),R15-Q15,IF(AND(Q15<IJD,R15>FJD),FJD-IJD,IF(AND(Q15>=IJD,Q15<FJD,R15<24),FJD-Q15,IF(AND(Q15<IJD,R15>IJD,R15<FJD),R15-IJD,0)))),IF(R15<Q15,IF(AND(Q15>IJD,Q15<FJD,R15>=IJD,R15<FJD),FJD-Q15+R15-IJD,IF(AND(Q15>=IJD,Q15<FJD,R15<IJD),FJD-Q15,IF(AND(Q15>FJD,R15>IJD,R15<FJD),R15-IJD,IF(AND(Q15>FJD,R15>FJD),16,IF(AND(Q15<IJD,R15<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H15<>\"N/A\",K15<>\"N/A\"),IF(AE15=0,0,IF(R15>IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15),IF(AND(IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)>=IJD,R15<=FJD),R15-IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15),IF(AND(IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)<IJD,R15>FJD),FJD-IJD,IF(AND(IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)>=IJD,IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)<FJD,R15<24),FJD-IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15),IF(AND(IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)<IJD,R15>IJD,R15<FJD),R15-IJD,0)))),IF(R15<IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15),IF(AND(IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)>IJD,IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)<FJD,R15>=IJD,R15<FJD),FJD-IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)+R15-IJD,IF(AND(IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)>=IJD,IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)<FJD,R15<IJD),FJD-IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15),IF(AND(IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)>FJD,R15>IJD,R15<FJD),R15-IJD,IF(AND(IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)>FJD,R15>FJD),16,IF(AND(IF(Q15+AB15-AE15>24,(Q15+AB15-AE15)-24,Q15+AB15-AE15)<IJD,R15<IJD),16,0)))))))),0)","v":0},0,2,{"$f":"IF(AND(H15<>\"N/A\",K15<>\"N/A\"),IF(S15>R15,IF(AND(R15>=IJD,S15<FJD),S15-R15,IF(AND(R15>=IJD,S15>FJD),IF(R15>FJD,R15-FJD,FJD-R15),IF(AND(R15<IJD,S15>=IJD,S15>FJD),S15-IJD-(S15-FJD),IF(AND(R15<IJD,S15>=IJD),S15-IJD,IF(AND(R15<IJD,S15<IJD),0))))),IF(S15<R15,IF(AND(R15>=FJD,S15<=IJD),0,IF(AND(R15<FJD,S15<=IJD),FJD-R15,IF(AND(R15>FJD,S15>IJD),S15-IJD,IF(AND(R15<FJD,S15>IJD),FJD-R15+S15-IJD)))))),0)","v":2},0,4,{"$f":"IF(AND(H15<>\"N/A\",K15<>\"N/A\"),IF(T15>S15,IF(AND(S15>=IJD,T15<=FJD),T15-S15,IF(AND(S15<IJD,T15>FJD),FJD-IJD,IF(AND(S15>=IJD,S15<FJD,T15<24),FJD-S15,IF(AND(S15<IJD,T15>IJD,T15<FJD),T15-IJD,0)))),IF(T15<S15,IF(AND(S15>IJD,S15<FJD,T15>=IJD,T15<FJD),FJD-S15+T15-IJD,IF(AND(S15>=IJD,S15<FJD,T15<IJD),FJD-S15,IF(AND(S15>FJD,T15>IJD,T15<FJD),T15-IJD,IF(AND(S15>FJD,T15>FJD),16,IF(AND(S15<IJD,T15<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H15<>\"N/A\",K15<>\"N/A\"),IF(AN15=0,0,IF(T15>IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15),IF(AND(IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)>=IJD,T15<=FJD),T15-IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15),IF(AND(IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)<IJD,T15>FJD),FJD-IJD,IF(AND(IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)>=IJD,IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)<FJD,T15<24),FJD-IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15),IF(AND(IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)<IJD,T15>IJD,T15<FJD),T15-IJD,0)))),IF(T15<IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15),IF(AND(IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)>IJD,IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)<FJD,T15>=IJD,T15<FJD),FJD-IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)+T15-IJD,IF(AND(IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)>=IJD,IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)<FJD,T15<IJD),FJD-IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15),IF(AND(IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)>FJD,T15>IJD,T15<FJD),T15-IJD,IF(AND(IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)>FJD,T15>FJD),16,IF(AND(IF(S15+AK15-AN15>24,(S15+AK15-AN15)-24,S15+AK15-AN15)<IJD,T15<IJD),16,0)))))))),0)","v":0},0,0,{"$f":"IF(AND(H15=\"N/A\",K15=\"N/A\"),IF(T15>Q15,IF(AND(Q15>=IJD,T15<=FJD),T15-Q15,IF(AND(Q15<IJD,T15>FJD),FJD-IJD,IF(AND(Q15>=IJD,Q15<FJD,T15<24),FJD-Q15,IF(AND(Q15<IJD,T15>IJD,T15<FJD),T15-IJD,0)))),IF(T15<Q15,IF(AND(Q15>IJD,Q15<FJD,T15>=IJD,T15<FJD),FJD-Q15+T15-IJD,IF(AND(Q15>=IJD,Q15<FJD,T15<IJD),FJD-Q15,IF(AND(Q15>FJD,T15>IJD,T15<FJD),T15-IJD,IF(AND(Q15>FJD,T15>FJD),16,IF(AND(Q15<IJD,T15<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H15=\"N/A\",K15=\"N/A\"),IF(AT15=0,0,IF(T15>IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15),IF(AND(IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)>=IJD,T15<=FJD),T15-IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15),IF(AND(IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)<IJD,T15>FJD),FJD-IJD,IF(AND(IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)>=IJD,IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)<FJD,T15<24),FJD-IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15),IF(AND(IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)<IJD,T15>IJD,T15<FJD),T15-IJD,0)))),IF(T15<IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15),IF(AND(IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)>IJD,IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)<FJD,T15>=IJD,T15<FJD),FJD-IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)+T15-IJD,IF(AND(IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)>=IJD,IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)<FJD,T15<IJD),FJD-IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15),IF(AND(IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)>FJD,T15>IJD,T15<FJD),T15-IJD,IF(AND(IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)>FJD,T15>FJD),16,IF(AND(IF(Q15+AQ15-AT15>24,(Q15+AQ15-AT15)-24,Q15+AQ15-AT15)<IJD,T15<IJD),16,0)))))))),0)","v":0},0,{"$f":"X15*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z15*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":0},{"$f":"AA15*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},0,{"$f":"IF(Y15>2,\"Excedio el límite de horas Extras en \" & Y15-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.2456336E7,"Cindi","Lopera",8.0,"08",":","00","12",":","00","14",":","00","20",":","00",8,12,14,20,10,8,{"$f":"ROUND(AC16-AF16+AL16-AO16+AR16-AU16,1)","v":8},0,2,{"$f":"ROUND(AF16+AO16+AU16,1)","v":2},0,4,{"$f":"IF(AND(H16<>\"N/A\",K16<>\"N/A\"),IF(R16>Q16,IF(AND(Q16>=IJD,R16<=FJD),R16-Q16,IF(AND(Q16<IJD,R16>FJD),FJD-IJD,IF(AND(Q16>=IJD,Q16<FJD,R16<24),FJD-Q16,IF(AND(Q16<IJD,R16>IJD,R16<FJD),R16-IJD,0)))),IF(R16<Q16,IF(AND(Q16>IJD,Q16<FJD,R16>=IJD,R16<FJD),FJD-Q16+R16-IJD,IF(AND(Q16>=IJD,Q16<FJD,R16<IJD),FJD-Q16,IF(AND(Q16>FJD,R16>IJD,R16<FJD),R16-IJD,IF(AND(Q16>FJD,R16>FJD),16,IF(AND(Q16<IJD,R16<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H16<>\"N/A\",K16<>\"N/A\"),IF(AE16=0,0,IF(R16>IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16),IF(AND(IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)>=IJD,R16<=FJD),R16-IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16),IF(AND(IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)<IJD,R16>FJD),FJD-IJD,IF(AND(IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)>=IJD,IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)<FJD,R16<24),FJD-IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16),IF(AND(IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)<IJD,R16>IJD,R16<FJD),R16-IJD,0)))),IF(R16<IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16),IF(AND(IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)>IJD,IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)<FJD,R16>=IJD,R16<FJD),FJD-IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)+R16-IJD,IF(AND(IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)>=IJD,IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)<FJD,R16<IJD),FJD-IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16),IF(AND(IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)>FJD,R16>IJD,R16<FJD),R16-IJD,IF(AND(IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)>FJD,R16>FJD),16,IF(AND(IF(Q16+AB16-AE16>24,(Q16+AB16-AE16)-24,Q16+AB16-AE16)<IJD,R16<IJD),16,0)))))))),0)","v":0},0,2,{"$f":"IF(AND(H16<>\"N/A\",K16<>\"N/A\"),IF(S16>R16,IF(AND(R16>=IJD,S16<FJD),S16-R16,IF(AND(R16>=IJD,S16>FJD),IF(R16>FJD,R16-FJD,FJD-R16),IF(AND(R16<IJD,S16>=IJD,S16>FJD),S16-IJD-(S16-FJD),IF(AND(R16<IJD,S16>=IJD),S16-IJD,IF(AND(R16<IJD,S16<IJD),0))))),IF(S16<R16,IF(AND(R16>=FJD,S16<=IJD),0,IF(AND(R16<FJD,S16<=IJD),FJD-R16,IF(AND(R16>FJD,S16>IJD),S16-IJD,IF(AND(R16<FJD,S16>IJD),FJD-R16+S16-IJD)))))),0)","v":2},0,6,{"$f":"IF(AND(H16<>\"N/A\",K16<>\"N/A\"),IF(T16>S16,IF(AND(S16>=IJD,T16<=FJD),T16-S16,IF(AND(S16<IJD,T16>FJD),FJD-IJD,IF(AND(S16>=IJD,S16<FJD,T16<24),FJD-S16,IF(AND(S16<IJD,T16>IJD,T16<FJD),T16-IJD,0)))),IF(T16<S16,IF(AND(S16>IJD,S16<FJD,T16>=IJD,T16<FJD),FJD-S16+T16-IJD,IF(AND(S16>=IJD,S16<FJD,T16<IJD),FJD-S16,IF(AND(S16>FJD,T16>IJD,T16<FJD),T16-IJD,IF(AND(S16>FJD,T16>FJD),16,IF(AND(S16<IJD,T16<IJD),16,0))))))),0)","v":6},0,2,{"$f":"IF(AND(H16<>\"N/A\",K16<>\"N/A\"),IF(AN16=0,0,IF(T16>IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16),IF(AND(IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)>=IJD,T16<=FJD),T16-IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16),IF(AND(IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)<IJD,T16>FJD),FJD-IJD,IF(AND(IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)>=IJD,IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)<FJD,T16<24),FJD-IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16),IF(AND(IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)<IJD,T16>IJD,T16<FJD),T16-IJD,0)))),IF(T16<IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16),IF(AND(IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)>IJD,IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)<FJD,T16>=IJD,T16<FJD),FJD-IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)+T16-IJD,IF(AND(IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)>=IJD,IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)<FJD,T16<IJD),FJD-IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16),IF(AND(IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)>FJD,T16>IJD,T16<FJD),T16-IJD,IF(AND(IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)>FJD,T16>FJD),16,IF(AND(IF(S16+AK16-AN16>24,(S16+AK16-AN16)-24,S16+AK16-AN16)<IJD,T16<IJD),16,0)))))))),0)","v":2},0,0,{"$f":"IF(AND(H16=\"N/A\",K16=\"N/A\"),IF(T16>Q16,IF(AND(Q16>=IJD,T16<=FJD),T16-Q16,IF(AND(Q16<IJD,T16>FJD),FJD-IJD,IF(AND(Q16>=IJD,Q16<FJD,T16<24),FJD-Q16,IF(AND(Q16<IJD,T16>IJD,T16<FJD),T16-IJD,0)))),IF(T16<Q16,IF(AND(Q16>IJD,Q16<FJD,T16>=IJD,T16<FJD),FJD-Q16+T16-IJD,IF(AND(Q16>=IJD,Q16<FJD,T16<IJD),FJD-Q16,IF(AND(Q16>FJD,T16>IJD,T16<FJD),T16-IJD,IF(AND(Q16>FJD,T16>FJD),16,IF(AND(Q16<IJD,T16<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H16=\"N/A\",K16=\"N/A\"),IF(AT16=0,0,IF(T16>IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16),IF(AND(IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)>=IJD,T16<=FJD),T16-IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16),IF(AND(IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)<IJD,T16>FJD),FJD-IJD,IF(AND(IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)>=IJD,IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)<FJD,T16<24),FJD-IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16),IF(AND(IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)<IJD,T16>IJD,T16<FJD),T16-IJD,0)))),IF(T16<IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16),IF(AND(IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)>IJD,IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)<FJD,T16>=IJD,T16<FJD),FJD-IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)+T16-IJD,IF(AND(IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)>=IJD,IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)<FJD,T16<IJD),FJD-IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16),IF(AND(IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)>FJD,T16>IJD,T16<FJD),T16-IJD,IF(AND(IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)>FJD,T16>FJD),16,IF(AND(IF(Q16+AQ16-AT16>24,(Q16+AQ16-AT16)-24,Q16+AQ16-AT16)<IJD,T16<IJD),16,0)))))))),0)","v":0},0,{"$f":"X16*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z16*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA16*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},7500,{"$f":"IF(Y16>2,\"Excedio el límite de horas Extras en \" & Y16-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.5807147E7,"Gladys","Ospina",8.0,"14",":","00","18",":","00","19",":","00","00",":","00",14,18,19,0,9,8,{"$f":"ROUND(AC17-AF17+AL17-AO17+AR17-AU17,1)","v":6},2,1,{"$f":"ROUND(AF17+AO17+AU17,1)","v":0},1,4,{"$f":"IF(AND(H17<>\"N/A\",K17<>\"N/A\"),IF(R17>Q17,IF(AND(Q17>=IJD,R17<=FJD),R17-Q17,IF(AND(Q17<IJD,R17>FJD),FJD-IJD,IF(AND(Q17>=IJD,Q17<FJD,R17<24),FJD-Q17,IF(AND(Q17<IJD,R17>IJD,R17<FJD),R17-IJD,0)))),IF(R17<Q17,IF(AND(Q17>IJD,Q17<FJD,R17>=IJD,R17<FJD),FJD-Q17+R17-IJD,IF(AND(Q17>=IJD,Q17<FJD,R17<IJD),FJD-Q17,IF(AND(Q17>FJD,R17>IJD,R17<FJD),R17-IJD,IF(AND(Q17>FJD,R17>FJD),16,IF(AND(Q17<IJD,R17<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H17<>\"N/A\",K17<>\"N/A\"),IF(AE17=0,0,IF(R17>IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17),IF(AND(IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)>=IJD,R17<=FJD),R17-IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17),IF(AND(IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)<IJD,R17>FJD),FJD-IJD,IF(AND(IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)>=IJD,IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)<FJD,R17<24),FJD-IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17),IF(AND(IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)<IJD,R17>IJD,R17<FJD),R17-IJD,0)))),IF(R17<IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17),IF(AND(IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)>IJD,IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)<FJD,R17>=IJD,R17<FJD),FJD-IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)+R17-IJD,IF(AND(IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)>=IJD,IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)<FJD,R17<IJD),FJD-IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17),IF(AND(IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)>FJD,R17>IJD,R17<FJD),R17-IJD,IF(AND(IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)>FJD,R17>FJD),16,IF(AND(IF(Q17+AB17-AE17>24,(Q17+AB17-AE17)-24,Q17+AB17-AE17)<IJD,R17<IJD),16,0)))))))),0)","v":0},0,1,{"$f":"IF(AND(H17<>\"N/A\",K17<>\"N/A\"),IF(S17>R17,IF(AND(R17>=IJD,S17<FJD),S17-R17,IF(AND(R17>=IJD,S17>FJD),IF(R17>FJD,R17-FJD,FJD-R17),IF(AND(R17<IJD,S17>=IJD,S17>FJD),S17-IJD-(S17-FJD),IF(AND(R17<IJD,S17>=IJD),S17-IJD,IF(AND(R17<IJD,S17<IJD),0))))),IF(S17<R17,IF(AND(R17>=FJD,S17<=IJD),0,IF(AND(R17<FJD,S17<=IJD),FJD-R17,IF(AND(R17>FJD,S17>IJD),S17-IJD,IF(AND(R17<FJD,S17>IJD),FJD-R17+S17-IJD)))))),0)","v":1},0,5,{"$f":"IF(AND(H17<>\"N/A\",K17<>\"N/A\"),IF(T17>S17,IF(AND(S17>=IJD,T17<=FJD),T17-S17,IF(AND(S17<IJD,T17>FJD),FJD-IJD,IF(AND(S17>=IJD,S17<FJD,T17<24),FJD-S17,IF(AND(S17<IJD,T17>IJD,T17<FJD),T17-IJD,0)))),IF(T17<S17,IF(AND(S17>IJD,S17<FJD,T17>=IJD,T17<FJD),FJD-S17+T17-IJD,IF(AND(S17>=IJD,S17<FJD,T17<IJD),FJD-S17,IF(AND(S17>FJD,T17>IJD,T17<FJD),T17-IJD,IF(AND(S17>FJD,T17>FJD),16,IF(AND(S17<IJD,T17<IJD),16,0))))))),0)","v":1.983333333},3.016666667,1,{"$f":"IF(AND(H17<>\"N/A\",K17<>\"N/A\"),IF(AN17=0,0,IF(T17>IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17),IF(AND(IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)>=IJD,T17<=FJD),T17-IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17),IF(AND(IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)<IJD,T17>FJD),FJD-IJD,IF(AND(IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)>=IJD,IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)<FJD,T17<24),FJD-IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17),IF(AND(IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)<IJD,T17>IJD,T17<FJD),T17-IJD,0)))),IF(T17<IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17),IF(AND(IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)>IJD,IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)<FJD,T17>=IJD,T17<FJD),FJD-IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)+T17-IJD,IF(AND(IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)>=IJD,IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)<FJD,T17<IJD),FJD-IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17),IF(AND(IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)>FJD,T17>IJD,T17<FJD),T17-IJD,IF(AND(IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)>FJD,T17>FJD),16,IF(AND(IF(S17+AK17-AN17>24,(S17+AK17-AN17)-24,S17+AK17-AN17)<IJD,T17<IJD),16,0)))))))),0)","v":0},1,0,{"$f":"IF(AND(H17=\"N/A\",K17=\"N/A\"),IF(T17>Q17,IF(AND(Q17>=IJD,T17<=FJD),T17-Q17,IF(AND(Q17<IJD,T17>FJD),FJD-IJD,IF(AND(Q17>=IJD,Q17<FJD,T17<24),FJD-Q17,IF(AND(Q17<IJD,T17>IJD,T17<FJD),T17-IJD,0)))),IF(T17<Q17,IF(AND(Q17>IJD,Q17<FJD,T17>=IJD,T17<FJD),FJD-Q17+T17-IJD,IF(AND(Q17>=IJD,Q17<FJD,T17<IJD),FJD-Q17,IF(AND(Q17>FJD,T17>IJD,T17<FJD),T17-IJD,IF(AND(Q17>FJD,T17>FJD),16,IF(AND(Q17<IJD,T17<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H17=\"N/A\",K17=\"N/A\"),IF(AT17=0,0,IF(T17>IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17),IF(AND(IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)>=IJD,T17<=FJD),T17-IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17),IF(AND(IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)<IJD,T17>FJD),FJD-IJD,IF(AND(IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)>=IJD,IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)<FJD,T17<24),FJD-IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17),IF(AND(IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)<IJD,T17>IJD,T17<FJD),T17-IJD,0)))),IF(T17<IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17),IF(AND(IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)>IJD,IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)<FJD,T17>=IJD,T17<FJD),FJD-IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)+T17-IJD,IF(AND(IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)>=IJD,IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)<FJD,T17<IJD),FJD-IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17),IF(AND(IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)>FJD,T17>IJD,T17<FJD),T17-IJD,IF(AND(IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)>FJD,T17>FJD),16,IF(AND(IF(Q17+AQ17-AT17>24,(Q17+AQ17-AT17)-24,Q17+AQ17-AT17)<IJD,T17<IJD),16,0)))))))),0)","v":0},0,{"$f":"X17*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":8100},{"$f":"Z17*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":0},{"$f":"AA17*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":5250},13350,{"$f":"IF(Y17>2,\"Excedio el límite de horas Extras en \" & Y17-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.2963879E7,"Laura","Zapata",8.0,"08",":","00","12",":","00","15",":","00","23",":","00",8,12,15,23,12,8,{"$f":"ROUND(AC18-AF18+AL18-AO18+AR18-AU18,1)","v":8},0,4,{"$f":"ROUND(AF18+AO18+AU18,1)","v":2},2,4,{"$f":"IF(AND(H18<>\"N/A\",K18<>\"N/A\"),IF(R18>Q18,IF(AND(Q18>=IJD,R18<=FJD),R18-Q18,IF(AND(Q18<IJD,R18>FJD),FJD-IJD,IF(AND(Q18>=IJD,Q18<FJD,R18<24),FJD-Q18,IF(AND(Q18<IJD,R18>IJD,R18<FJD),R18-IJD,0)))),IF(R18<Q18,IF(AND(Q18>IJD,Q18<FJD,R18>=IJD,R18<FJD),FJD-Q18+R18-IJD,IF(AND(Q18>=IJD,Q18<FJD,R18<IJD),FJD-Q18,IF(AND(Q18>FJD,R18>IJD,R18<FJD),R18-IJD,IF(AND(Q18>FJD,R18>FJD),16,IF(AND(Q18<IJD,R18<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H18<>\"N/A\",K18<>\"N/A\"),IF(AE18=0,0,IF(R18>IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18),IF(AND(IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)>=IJD,R18<=FJD),R18-IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18),IF(AND(IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)<IJD,R18>FJD),FJD-IJD,IF(AND(IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)>=IJD,IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)<FJD,R18<24),FJD-IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18),IF(AND(IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)<IJD,R18>IJD,R18<FJD),R18-IJD,0)))),IF(R18<IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18),IF(AND(IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)>IJD,IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)<FJD,R18>=IJD,R18<FJD),FJD-IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)+R18-IJD,IF(AND(IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)>=IJD,IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)<FJD,R18<IJD),FJD-IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18),IF(AND(IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)>FJD,R18>IJD,R18<FJD),R18-IJD,IF(AND(IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)>FJD,R18>FJD),16,IF(AND(IF(Q18+AB18-AE18>24,(Q18+AB18-AE18)-24,Q18+AB18-AE18)<IJD,R18<IJD),16,0)))))))),0)","v":0},0,3,{"$f":"IF(AND(H18<>\"N/A\",K18<>\"N/A\"),IF(S18>R18,IF(AND(R18>=IJD,S18<FJD),S18-R18,IF(AND(R18>=IJD,S18>FJD),IF(R18>FJD,R18-FJD,FJD-R18),IF(AND(R18<IJD,S18>=IJD,S18>FJD),S18-IJD-(S18-FJD),IF(AND(R18<IJD,S18>=IJD),S18-IJD,IF(AND(R18<IJD,S18<IJD),0))))),IF(S18<R18,IF(AND(R18>=FJD,S18<=IJD),0,IF(AND(R18<FJD,S18<=IJD),FJD-R18,IF(AND(R18>FJD,S18>IJD),S18-IJD,IF(AND(R18<FJD,S18>IJD),FJD-R18+S18-IJD)))))),0)","v":3},0,8,{"$f":"IF(AND(H18<>\"N/A\",K18<>\"N/A\"),IF(T18>S18,IF(AND(S18>=IJD,T18<=FJD),T18-S18,IF(AND(S18<IJD,T18>FJD),FJD-IJD,IF(AND(S18>=IJD,S18<FJD,T18<24),FJD-S18,IF(AND(S18<IJD,T18>IJD,T18<FJD),T18-IJD,0)))),IF(T18<S18,IF(AND(S18>IJD,S18<FJD,T18>=IJD,T18<FJD),FJD-S18+T18-IJD,IF(AND(S18>=IJD,S18<FJD,T18<IJD),FJD-S18,IF(AND(S18>FJD,T18>IJD,T18<FJD),T18-IJD,IF(AND(S18>FJD,T18>FJD),16,IF(AND(S18<IJD,T18<IJD),16,0))))))),0)","v":5.983333333},2.016666667,4,{"$f":"IF(AND(H18<>\"N/A\",K18<>\"N/A\"),IF(AN18=0,0,IF(T18>IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18),IF(AND(IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)>=IJD,T18<=FJD),T18-IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18),IF(AND(IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)<IJD,T18>FJD),FJD-IJD,IF(AND(IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)>=IJD,IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)<FJD,T18<24),FJD-IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18),IF(AND(IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)<IJD,T18>IJD,T18<FJD),T18-IJD,0)))),IF(T18<IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18),IF(AND(IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)>IJD,IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)<FJD,T18>=IJD,T18<FJD),FJD-IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)+T18-IJD,IF(AND(IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)>=IJD,IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)<FJD,T18<IJD),FJD-IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18),IF(AND(IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)>FJD,T18>IJD,T18<FJD),T18-IJD,IF(AND(IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)>FJD,T18>FJD),16,IF(AND(IF(S18+AK18-AN18>24,(S18+AK18-AN18)-24,S18+AK18-AN18)<IJD,T18<IJD),16,0)))))))),0)","v":1.983333333},2.016666667,0,{"$f":"IF(AND(H18=\"N/A\",K18=\"N/A\"),IF(T18>Q18,IF(AND(Q18>=IJD,T18<=FJD),T18-Q18,IF(AND(Q18<IJD,T18>FJD),FJD-IJD,IF(AND(Q18>=IJD,Q18<FJD,T18<24),FJD-Q18,IF(AND(Q18<IJD,T18>IJD,T18<FJD),T18-IJD,0)))),IF(T18<Q18,IF(AND(Q18>IJD,Q18<FJD,T18>=IJD,T18<FJD),FJD-Q18+T18-IJD,IF(AND(Q18>=IJD,Q18<FJD,T18<IJD),FJD-Q18,IF(AND(Q18>FJD,T18>IJD,T18<FJD),T18-IJD,IF(AND(Q18>FJD,T18>FJD),16,IF(AND(Q18<IJD,T18<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H18=\"N/A\",K18=\"N/A\"),IF(AT18=0,0,IF(T18>IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18),IF(AND(IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)>=IJD,T18<=FJD),T18-IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18),IF(AND(IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)<IJD,T18>FJD),FJD-IJD,IF(AND(IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)>=IJD,IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)<FJD,T18<24),FJD-IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18),IF(AND(IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)<IJD,T18>IJD,T18<FJD),T18-IJD,0)))),IF(T18<IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18),IF(AND(IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)>IJD,IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)<FJD,T18>=IJD,T18<FJD),FJD-IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)+T18-IJD,IF(AND(IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)>=IJD,IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)<FJD,T18<IJD),FJD-IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18),IF(AND(IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)>FJD,T18>IJD,T18<FJD),T18-IJD,IF(AND(IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)>FJD,T18>FJD),16,IF(AND(IF(Q18+AQ18-AT18>24,(Q18+AQ18-AT18)-24,Q18+AQ18-AT18)<IJD,T18<IJD),16,0)))))))),0)","v":0},0,{"$f":"X18*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z18*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA18*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":10500},18000,{"$f":"IF(Y18>2,\"Excedio el límite de horas Extras en \" & Y18-LIMITEHORASEXTRAXDIA,\"\")","v":"Excedio el límite de horas Extras en 2"}]
[9.4180411E7,"Carlos","Muñoz",8.0,"18",":","00","N/A",":","N/A","N/A",":","N/A","02",":","00",18,"#VALUE!","#VALUE!",2,8,8,{"$f":"ROUND(AC19-AF19+AL19-AO19+AR19-AU19,1)","v":3},5,0,{"$f":"ROUND(AF19+AO19+AU19,1)","v":0},0,0,{"$f":"IF(AND(H19<>\"N/A\",K19<>\"N/A\"),IF(R19>Q19,IF(AND(Q19>=IJD,R19<=FJD),R19-Q19,IF(AND(Q19<IJD,R19>FJD),FJD-IJD,IF(AND(Q19>=IJD,Q19<FJD,R19<24),FJD-Q19,IF(AND(Q19<IJD,R19>IJD,R19<FJD),R19-IJD,0)))),IF(R19<Q19,IF(AND(Q19>IJD,Q19<FJD,R19>=IJD,R19<FJD),FJD-Q19+R19-IJD,IF(AND(Q19>=IJD,Q19<FJD,R19<IJD),FJD-Q19,IF(AND(Q19>FJD,R19>IJD,R19<FJD),R19-IJD,IF(AND(Q19>FJD,R19>FJD),16,IF(AND(Q19<IJD,R19<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H19<>\"N/A\",K19<>\"N/A\"),IF(AE19=0,0,IF(R19>IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19),IF(AND(IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)>=IJD,R19<=FJD),R19-IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19),IF(AND(IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)<IJD,R19>FJD),FJD-IJD,IF(AND(IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)>=IJD,IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)<FJD,R19<24),FJD-IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19),IF(AND(IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)<IJD,R19>IJD,R19<FJD),R19-IJD,0)))),IF(R19<IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19),IF(AND(IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)>IJD,IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)<FJD,R19>=IJD,R19<FJD),FJD-IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)+R19-IJD,IF(AND(IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)>=IJD,IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)<FJD,R19<IJD),FJD-IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19),IF(AND(IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)>FJD,R19>IJD,R19<FJD),R19-IJD,IF(AND(IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)>FJD,R19>FJD),16,IF(AND(IF(Q19+AB19-AE19>24,(Q19+AB19-AE19)-24,Q19+AB19-AE19)<IJD,R19<IJD),16,0)))))))),0)","v":0},0,0,{"$f":"IF(AND(H19<>\"N/A\",K19<>\"N/A\"),IF(S19>R19,IF(AND(R19>=IJD,S19<FJD),S19-R19,IF(AND(R19>=IJD,S19>FJD),IF(R19>FJD,R19-FJD,FJD-R19),IF(AND(R19<IJD,S19>=IJD,S19>FJD),S19-IJD-(S19-FJD),IF(AND(R19<IJD,S19>=IJD),S19-IJD,IF(AND(R19<IJD,S19<IJD),0))))),IF(S19<R19,IF(AND(R19>=FJD,S19<=IJD),0,IF(AND(R19<FJD,S19<=IJD),FJD-R19,IF(AND(R19>FJD,S19>IJD),S19-IJD,IF(AND(R19<FJD,S19>IJD),FJD-R19+S19-IJD)))))),0)","v":0},0,0,{"$f":"IF(AND(H19<>\"N/A\",K19<>\"N/A\"),IF(T19>S19,IF(AND(S19>=IJD,T19<=FJD),T19-S19,IF(AND(S19<IJD,T19>FJD),FJD-IJD,IF(AND(S19>=IJD,S19<FJD,T19<24),FJD-S19,IF(AND(S19<IJD,T19>IJD,T19<FJD),T19-IJD,0)))),IF(T19<S19,IF(AND(S19>IJD,S19<FJD,T19>=IJD,T19<FJD),FJD-S19+T19-IJD,IF(AND(S19>=IJD,S19<FJD,T19<IJD),FJD-S19,IF(AND(S19>FJD,T19>IJD,T19<FJD),T19-IJD,IF(AND(S19>FJD,T19>FJD),16,IF(AND(S19<IJD,T19<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H19<>\"N/A\",K19<>\"N/A\"),IF(AN19=0,0,IF(T19>IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19),IF(AND(IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)>=IJD,T19<=FJD),T19-IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19),IF(AND(IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)<IJD,T19>FJD),FJD-IJD,IF(AND(IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)>=IJD,IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)<FJD,T19<24),FJD-IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19),IF(AND(IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)<IJD,T19>IJD,T19<FJD),T19-IJD,0)))),IF(T19<IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19),IF(AND(IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)>IJD,IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)<FJD,T19>=IJD,T19<FJD),FJD-IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)+T19-IJD,IF(AND(IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)>=IJD,IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)<FJD,T19<IJD),FJD-IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19),IF(AND(IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)>FJD,T19>IJD,T19<FJD),T19-IJD,IF(AND(IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)>FJD,T19>FJD),16,IF(AND(IF(S19+AK19-AN19>24,(S19+AK19-AN19)-24,S19+AK19-AN19)<IJD,T19<IJD),16,0)))))))),0)","v":0},0,8,{"$f":"IF(AND(H19=\"N/A\",K19=\"N/A\"),IF(T19>Q19,IF(AND(Q19>=IJD,T19<=FJD),T19-Q19,IF(AND(Q19<IJD,T19>FJD),FJD-IJD,IF(AND(Q19>=IJD,Q19<FJD,T19<24),FJD-Q19,IF(AND(Q19<IJD,T19>IJD,T19<FJD),T19-IJD,0)))),IF(T19<Q19,IF(AND(Q19>IJD,Q19<FJD,T19>=IJD,T19<FJD),FJD-Q19+T19-IJD,IF(AND(Q19>=IJD,Q19<FJD,T19<IJD),FJD-Q19,IF(AND(Q19>FJD,T19>IJD,T19<FJD),T19-IJD,IF(AND(Q19>FJD,T19>FJD),16,IF(AND(Q19<IJD,T19<IJD),16,0))))))),0)","v":2.983333333},5.016666667,0,{"$f":"IF(AND(H19=\"N/A\",K19=\"N/A\"),IF(AT19=0,0,IF(T19>IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19),IF(AND(IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)>=IJD,T19<=FJD),T19-IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19),IF(AND(IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)<IJD,T19>FJD),FJD-IJD,IF(AND(IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)>=IJD,IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)<FJD,T19<24),FJD-IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19),IF(AND(IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)<IJD,T19>IJD,T19<FJD),T19-IJD,0)))),IF(T19<IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19),IF(AND(IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)>IJD,IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)<FJD,T19>=IJD,T19<FJD),FJD-IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)+T19-IJD,IF(AND(IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)>=IJD,IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)<FJD,T19<IJD),FJD-IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19),IF(AND(IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)>FJD,T19>IJD,T19<FJD),T19-IJD,IF(AND(IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)>FJD,T19>FJD),16,IF(AND(IF(Q19+AQ19-AT19>24,(Q19+AQ19-AT19)-24,Q19+AQ19-AT19)<IJD,T19<IJD),16,0)))))))),0)","v":0},0,{"$f":"X19*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":20250},{"$f":"Z19*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":0},{"$f":"AA19*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},20250,{"$f":"IF(Y19>2,\"Excedio el límite de horas Extras en \" & Y19-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.166605E7,"Gonzalo","Munera",8.0,"22",":","00","N/A",":","N/A","N/A",":","N/A","08",":","00",22,"#VALUE!","#VALUE!",8,10,8,{"$f":"ROUND(AC20-AF20+AL20-AO20+AR20-AU20,1)","v":0},8,2,{"$f":"ROUND(AF20+AO20+AU20,1)","v":2},0,0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),IF(R20>Q20,IF(AND(Q20>=IJD,R20<=FJD),R20-Q20,IF(AND(Q20<IJD,R20>FJD),FJD-IJD,IF(AND(Q20>=IJD,Q20<FJD,R20<24),FJD-Q20,IF(AND(Q20<IJD,R20>IJD,R20<FJD),R20-IJD,0)))),IF(R20<Q20,IF(AND(Q20>IJD,Q20<FJD,R20>=IJD,R20<FJD),FJD-Q20+R20-IJD,IF(AND(Q20>=IJD,Q20<FJD,R20<IJD),FJD-Q20,IF(AND(Q20>FJD,R20>IJD,R20<FJD),R20-IJD,IF(AND(Q20>FJD,R20>FJD),16,IF(AND(Q20<IJD,R20<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),IF(AE20=0,0,IF(R20>IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20),IF(AND(IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)>=IJD,R20<=FJD),R20-IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20),IF(AND(IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)<IJD,R20>FJD),FJD-IJD,IF(AND(IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)>=IJD,IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)<FJD,R20<24),FJD-IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20),IF(AND(IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)<IJD,R20>IJD,R20<FJD),R20-IJD,0)))),IF(R20<IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20),IF(AND(IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)>IJD,IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)<FJD,R20>=IJD,R20<FJD),FJD-IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)+R20-IJD,IF(AND(IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)>=IJD,IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)<FJD,R20<IJD),FJD-IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20),IF(AND(IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)>FJD,R20>IJD,R20<FJD),R20-IJD,IF(AND(IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)>FJD,R20>FJD),16,IF(AND(IF(Q20+AB20-AE20>24,(Q20+AB20-AE20)-24,Q20+AB20-AE20)<IJD,R20<IJD),16,0)))))))),0)","v":0},0,0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),IF(S20>R20,IF(AND(R20>=IJD,S20<FJD),S20-R20,IF(AND(R20>=IJD,S20>FJD),IF(R20>FJD,R20-FJD,FJD-R20),IF(AND(R20<IJD,S20>=IJD,S20>FJD),S20-IJD-(S20-FJD),IF(AND(R20<IJD,S20>=IJD),S20-IJD,IF(AND(R20<IJD,S20<IJD),0))))),IF(S20<R20,IF(AND(R20>=FJD,S20<=IJD),0,IF(AND(R20<FJD,S20<=IJD),FJD-R20,IF(AND(R20>FJD,S20>IJD),S20-IJD,IF(AND(R20<FJD,S20>IJD),FJD-R20+S20-IJD)))))),0)","v":0},0,0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),IF(T20>S20,IF(AND(S20>=IJD,T20<=FJD),T20-S20,IF(AND(S20<IJD,T20>FJD),FJD-IJD,IF(AND(S20>=IJD,S20<FJD,T20<24),FJD-S20,IF(AND(S20<IJD,T20>IJD,T20<FJD),T20-IJD,0)))),IF(T20<S20,IF(AND(S20>IJD,S20<FJD,T20>=IJD,T20<FJD),FJD-S20+T20-IJD,IF(AND(S20>=IJD,S20<FJD,T20<IJD),FJD-S20,IF(AND(S20>FJD,T20>IJD,T20<FJD),T20-IJD,IF(AND(S20>FJD,T20>FJD),16,IF(AND(S20<IJD,T20<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),IF(AN20=0,0,IF(T20>IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20),IF(AND(IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)>=IJD,T20<=FJD),T20-IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20),IF(AND(IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)<IJD,T20>FJD),FJD-IJD,IF(AND(IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)>=IJD,IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)<FJD,T20<24),FJD-IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20),IF(AND(IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)<IJD,T20>IJD,T20<FJD),T20-IJD,0)))),IF(T20<IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20),IF(AND(IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)>IJD,IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)<FJD,T20>=IJD,T20<FJD),FJD-IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)+T20-IJD,IF(AND(IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)>=IJD,IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)<FJD,T20<IJD),FJD-IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20),IF(AND(IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)>FJD,T20>IJD,T20<FJD),T20-IJD,IF(AND(IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)>FJD,T20>FJD),16,IF(AND(IF(S20+AK20-AN20>24,(S20+AK20-AN20)-24,S20+AK20-AN20)<IJD,T20<IJD),16,0)))))))),0)","v":0},0,10,{"$f":"IF(AND(H20=\"N/A\",K20=\"N/A\"),IF(T20>Q20,IF(AND(Q20>=IJD,T20<=FJD),T20-Q20,IF(AND(Q20<IJD,T20>FJD),FJD-IJD,IF(AND(Q20>=IJD,Q20<FJD,T20<24),FJD-Q20,IF(AND(Q20<IJD,T20>IJD,T20<FJD),T20-IJD,0)))),IF(T20<Q20,IF(AND(Q20>IJD,Q20<FJD,T20>=IJD,T20<FJD),FJD-Q20+T20-IJD,IF(AND(Q20>=IJD,Q20<FJD,T20<IJD),FJD-Q20,IF(AND(Q20>FJD,T20>IJD,T20<FJD),T20-IJD,IF(AND(Q20>FJD,T20>FJD),16,IF(AND(Q20<IJD,T20<IJD),16,0))))))),0)","v":2},8,2,{"$f":"IF(AND(H20=\"N/A\",K20=\"N/A\"),IF(AT20=0,0,IF(T20>IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20),IF(AND(IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)>=IJD,T20<=FJD),T20-IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20),IF(AND(IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)<IJD,T20>FJD),FJD-IJD,IF(AND(IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)>=IJD,IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)<FJD,T20<24),FJD-IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20),IF(AND(IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)<IJD,T20>IJD,T20<FJD),T20-IJD,0)))),IF(T20<IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20),IF(AND(IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)>IJD,IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)<FJD,T20>=IJD,T20<FJD),FJD-IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)+T20-IJD,IF(AND(IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)>=IJD,IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)<FJD,T20<IJD),FJD-IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20),IF(AND(IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)>FJD,T20>IJD,T20<FJD),T20-IJD,IF(AND(IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)>FJD,T20>FJD),16,IF(AND(IF(Q20+AQ20-AT20>24,(Q20+AQ20-AT20)-24,Q20+AQ20-AT20)<IJD,T20<IJD),16,0)))))))),0)","v":2},0,{"$f":"X20*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":32400},{"$f":"Z20*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA20*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},39900,{"$f":"IF(Y20>2,\"Excedio el límite de horas Extras en \" & Y20-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[9.9166507E7,"German","Lara",8.0,"22",":","00","N/A",":","N/A","N/A",":","N/A","08",":","00",22,"#VALUE!","#VALUE!",8,10,8,{"$f":"ROUND(AC21-AF21+AL21-AO21+AR21-AU21,1)","v":0},8,2,{"$f":"ROUND(AF21+AO21+AU21,1)","v":2},0,0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),IF(R21>Q21,IF(AND(Q21>=IJD,R21<=FJD),R21-Q21,IF(AND(Q21<IJD,R21>FJD),FJD-IJD,IF(AND(Q21>=IJD,Q21<FJD,R21<24),FJD-Q21,IF(AND(Q21<IJD,R21>IJD,R21<FJD),R21-IJD,0)))),IF(R21<Q21,IF(AND(Q21>IJD,Q21<FJD,R21>=IJD,R21<FJD),FJD-Q21+R21-IJD,IF(AND(Q21>=IJD,Q21<FJD,R21<IJD),FJD-Q21,IF(AND(Q21>FJD,R21>IJD,R21<FJD),R21-IJD,IF(AND(Q21>FJD,R21>FJD),16,IF(AND(Q21<IJD,R21<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),IF(AE21=0,0,IF(R21>IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21),IF(AND(IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)>=IJD,R21<=FJD),R21-IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21),IF(AND(IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)<IJD,R21>FJD),FJD-IJD,IF(AND(IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)>=IJD,IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)<FJD,R21<24),FJD-IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21),IF(AND(IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)<IJD,R21>IJD,R21<FJD),R21-IJD,0)))),IF(R21<IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21),IF(AND(IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)>IJD,IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)<FJD,R21>=IJD,R21<FJD),FJD-IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)+R21-IJD,IF(AND(IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)>=IJD,IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)<FJD,R21<IJD),FJD-IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21),IF(AND(IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)>FJD,R21>IJD,R21<FJD),R21-IJD,IF(AND(IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)>FJD,R21>FJD),16,IF(AND(IF(Q21+AB21-AE21>24,(Q21+AB21-AE21)-24,Q21+AB21-AE21)<IJD,R21<IJD),16,0)))))))),0)","v":0},0,0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),IF(S21>R21,IF(AND(R21>=IJD,S21<FJD),S21-R21,IF(AND(R21>=IJD,S21>FJD),IF(R21>FJD,R21-FJD,FJD-R21),IF(AND(R21<IJD,S21>=IJD,S21>FJD),S21-IJD-(S21-FJD),IF(AND(R21<IJD,S21>=IJD),S21-IJD,IF(AND(R21<IJD,S21<IJD),0))))),IF(S21<R21,IF(AND(R21>=FJD,S21<=IJD),0,IF(AND(R21<FJD,S21<=IJD),FJD-R21,IF(AND(R21>FJD,S21>IJD),S21-IJD,IF(AND(R21<FJD,S21>IJD),FJD-R21+S21-IJD)))))),0)","v":0},0,0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),IF(T21>S21,IF(AND(S21>=IJD,T21<=FJD),T21-S21,IF(AND(S21<IJD,T21>FJD),FJD-IJD,IF(AND(S21>=IJD,S21<FJD,T21<24),FJD-S21,IF(AND(S21<IJD,T21>IJD,T21<FJD),T21-IJD,0)))),IF(T21<S21,IF(AND(S21>IJD,S21<FJD,T21>=IJD,T21<FJD),FJD-S21+T21-IJD,IF(AND(S21>=IJD,S21<FJD,T21<IJD),FJD-S21,IF(AND(S21>FJD,T21>IJD,T21<FJD),T21-IJD,IF(AND(S21>FJD,T21>FJD),16,IF(AND(S21<IJD,T21<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),IF(AN21=0,0,IF(T21>IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21),IF(AND(IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)>=IJD,T21<=FJD),T21-IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21),IF(AND(IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)<IJD,T21>FJD),FJD-IJD,IF(AND(IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)>=IJD,IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)<FJD,T21<24),FJD-IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21),IF(AND(IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)<IJD,T21>IJD,T21<FJD),T21-IJD,0)))),IF(T21<IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21),IF(AND(IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)>IJD,IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)<FJD,T21>=IJD,T21<FJD),FJD-IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)+T21-IJD,IF(AND(IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)>=IJD,IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)<FJD,T21<IJD),FJD-IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21),IF(AND(IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)>FJD,T21>IJD,T21<FJD),T21-IJD,IF(AND(IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)>FJD,T21>FJD),16,IF(AND(IF(S21+AK21-AN21>24,(S21+AK21-AN21)-24,S21+AK21-AN21)<IJD,T21<IJD),16,0)))))))),0)","v":0},0,10,{"$f":"IF(AND(H21=\"N/A\",K21=\"N/A\"),IF(T21>Q21,IF(AND(Q21>=IJD,T21<=FJD),T21-Q21,IF(AND(Q21<IJD,T21>FJD),FJD-IJD,IF(AND(Q21>=IJD,Q21<FJD,T21<24),FJD-Q21,IF(AND(Q21<IJD,T21>IJD,T21<FJD),T21-IJD,0)))),IF(T21<Q21,IF(AND(Q21>IJD,Q21<FJD,T21>=IJD,T21<FJD),FJD-Q21+T21-IJD,IF(AND(Q21>=IJD,Q21<FJD,T21<IJD),FJD-Q21,IF(AND(Q21>FJD,T21>IJD,T21<FJD),T21-IJD,IF(AND(Q21>FJD,T21>FJD),16,IF(AND(Q21<IJD,T21<IJD),16,0))))))),0)","v":2},8,2,{"$f":"IF(AND(H21=\"N/A\",K21=\"N/A\"),IF(AT21=0,0,IF(T21>IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21),IF(AND(IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)>=IJD,T21<=FJD),T21-IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21),IF(AND(IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)<IJD,T21>FJD),FJD-IJD,IF(AND(IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)>=IJD,IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)<FJD,T21<24),FJD-IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21),IF(AND(IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)<IJD,T21>IJD,T21<FJD),T21-IJD,0)))),IF(T21<IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21),IF(AND(IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)>IJD,IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)<FJD,T21>=IJD,T21<FJD),FJD-IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)+T21-IJD,IF(AND(IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)>=IJD,IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)<FJD,T21<IJD),FJD-IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21),IF(AND(IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)>FJD,T21>IJD,T21<FJD),T21-IJD,IF(AND(IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)>FJD,T21>FJD),16,IF(AND(IF(Q21+AQ21-AT21>24,(Q21+AQ21-AT21)-24,Q21+AQ21-AT21)<IJD,T21<IJD),16,0)))))))),0)","v":2},0,{"$f":"X21*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":32400},{"$f":"Z21*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA21*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},39900,{"$f":"IF(Y21>2,\"Excedio el límite de horas Extras en \" & Y21-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[8.6987512E7,"Aminta","Perez",4.0,"08",":","00","12",":","00","14",":","00","16",":","00",8,12,14,16,6,4,{"$f":"ROUND(AC22-AF22+AL22-AO22+AR22-AU22,1)","v":4},0,2,{"$f":"ROUND(AF22+AO22+AU22,1)","v":2},0,4,{"$f":"IF(AND(H22<>\"N/A\",K22<>\"N/A\"),IF(R22>Q22,IF(AND(Q22>=IJD,R22<=FJD),R22-Q22,IF(AND(Q22<IJD,R22>FJD),FJD-IJD,IF(AND(Q22>=IJD,Q22<FJD,R22<24),FJD-Q22,IF(AND(Q22<IJD,R22>IJD,R22<FJD),R22-IJD,0)))),IF(R22<Q22,IF(AND(Q22>IJD,Q22<FJD,R22>=IJD,R22<FJD),FJD-Q22+R22-IJD,IF(AND(Q22>=IJD,Q22<FJD,R22<IJD),FJD-Q22,IF(AND(Q22>FJD,R22>IJD,R22<FJD),R22-IJD,IF(AND(Q22>FJD,R22>FJD),16,IF(AND(Q22<IJD,R22<IJD),16,0))))))),0)","v":4},0,0,{"$f":"IF(AND(H22<>\"N/A\",K22<>\"N/A\"),IF(AE22=0,0,IF(R22>IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22),IF(AND(IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)>=IJD,R22<=FJD),R22-IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22),IF(AND(IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)<IJD,R22>FJD),FJD-IJD,IF(AND(IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)>=IJD,IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)<FJD,R22<24),FJD-IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22),IF(AND(IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)<IJD,R22>IJD,R22<FJD),R22-IJD,0)))),IF(R22<IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22),IF(AND(IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)>IJD,IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)<FJD,R22>=IJD,R22<FJD),FJD-IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)+R22-IJD,IF(AND(IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)>=IJD,IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)<FJD,R22<IJD),FJD-IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22),IF(AND(IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)>FJD,R22>IJD,R22<FJD),R22-IJD,IF(AND(IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)>FJD,R22>FJD),16,IF(AND(IF(Q22+AB22-AE22>24,(Q22+AB22-AE22)-24,Q22+AB22-AE22)<IJD,R22<IJD),16,0)))))))),0)","v":0},0,2,{"$f":"IF(AND(H22<>\"N/A\",K22<>\"N/A\"),IF(S22>R22,IF(AND(R22>=IJD,S22<FJD),S22-R22,IF(AND(R22>=IJD,S22>FJD),IF(R22>FJD,R22-FJD,FJD-R22),IF(AND(R22<IJD,S22>=IJD,S22>FJD),S22-IJD-(S22-FJD),IF(AND(R22<IJD,S22>=IJD),S22-IJD,IF(AND(R22<IJD,S22<IJD),0))))),IF(S22<R22,IF(AND(R22>=FJD,S22<=IJD),0,IF(AND(R22<FJD,S22<=IJD),FJD-R22,IF(AND(R22>FJD,S22>IJD),S22-IJD,IF(AND(R22<FJD,S22>IJD),FJD-R22+S22-IJD)))))),0)","v":2},0,2,{"$f":"IF(AND(H22<>\"N/A\",K22<>\"N/A\"),IF(T22>S22,IF(AND(S22>=IJD,T22<=FJD),T22-S22,IF(AND(S22<IJD,T22>FJD),FJD-IJD,IF(AND(S22>=IJD,S22<FJD,T22<24),FJD-S22,IF(AND(S22<IJD,T22>IJD,T22<FJD),T22-IJD,0)))),IF(T22<S22,IF(AND(S22>IJD,S22<FJD,T22>=IJD,T22<FJD),FJD-S22+T22-IJD,IF(AND(S22>=IJD,S22<FJD,T22<IJD),FJD-S22,IF(AND(S22>FJD,T22>IJD,T22<FJD),T22-IJD,IF(AND(S22>FJD,T22>FJD),16,IF(AND(S22<IJD,T22<IJD),16,0))))))),0)","v":2},0,2,{"$f":"IF(AND(H22<>\"N/A\",K22<>\"N/A\"),IF(AN22=0,0,IF(T22>IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22),IF(AND(IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)>=IJD,T22<=FJD),T22-IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22),IF(AND(IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)<IJD,T22>FJD),FJD-IJD,IF(AND(IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)>=IJD,IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)<FJD,T22<24),FJD-IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22),IF(AND(IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)<IJD,T22>IJD,T22<FJD),T22-IJD,0)))),IF(T22<IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22),IF(AND(IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)>IJD,IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)<FJD,T22>=IJD,T22<FJD),FJD-IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)+T22-IJD,IF(AND(IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)>=IJD,IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)<FJD,T22<IJD),FJD-IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22),IF(AND(IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)>FJD,T22>IJD,T22<FJD),T22-IJD,IF(AND(IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)>FJD,T22>FJD),16,IF(AND(IF(S22+AK22-AN22>24,(S22+AK22-AN22)-24,S22+AK22-AN22)<IJD,T22<IJD),16,0)))))))),0)","v":2},0,0,{"$f":"IF(AND(H22=\"N/A\",K22=\"N/A\"),IF(T22>Q22,IF(AND(Q22>=IJD,T22<=FJD),T22-Q22,IF(AND(Q22<IJD,T22>FJD),FJD-IJD,IF(AND(Q22>=IJD,Q22<FJD,T22<24),FJD-Q22,IF(AND(Q22<IJD,T22>IJD,T22<FJD),T22-IJD,0)))),IF(T22<Q22,IF(AND(Q22>IJD,Q22<FJD,T22>=IJD,T22<FJD),FJD-Q22+T22-IJD,IF(AND(Q22>=IJD,Q22<FJD,T22<IJD),FJD-Q22,IF(AND(Q22>FJD,T22>IJD,T22<FJD),T22-IJD,IF(AND(Q22>FJD,T22>FJD),16,IF(AND(Q22<IJD,T22<IJD),16,0))))))),0)","v":0},0,0,{"$f":"IF(AND(H22=\"N/A\",K22=\"N/A\"),IF(AT22=0,0,IF(T22>IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22),IF(AND(IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)>=IJD,T22<=FJD),T22-IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22),IF(AND(IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)<IJD,T22>FJD),FJD-IJD,IF(AND(IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)>=IJD,IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)<FJD,T22<24),FJD-IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22),IF(AND(IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)<IJD,T22>IJD,T22<FJD),T22-IJD,0)))),IF(T22<IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22),IF(AND(IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)>IJD,IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)<FJD,T22>=IJD,T22<FJD),FJD-IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)+T22-IJD,IF(AND(IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)>=IJD,IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)<FJD,T22<IJD),FJD-IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22),IF(AND(IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)>FJD,T22>IJD,T22<FJD),T22-IJD,IF(AND(IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)>FJD,T22>FJD),16,IF(AND(IF(Q22+AQ22-AT22>24,(Q22+AQ22-AT22)-24,Q22+AQ22-AT22)<IJD,T22<IJD),16,0)))))))),0)","v":0},0,{"$f":"X22*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z22*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":7500},{"$f":"AA22*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},7500,{"$f":"IF(Y22>2,\"Excedio el límite de horas Extras en \" & Y22-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]

{"sheet":"Registro de Turnos","index":4,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":true,"merged":[[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,2,6],[2,7,2,9]]}
[]
[]
[null,"CEDULA","Fecha","Total Laboradas","Ordinarias Laboradas",null,null,"Extras Laboradas"]
[null,null,null,null,"Total","Diurnas","Nocturnas","Total","Diurnas","Nocturnas"]
[null,1.2345678E7,"2011-12-23",8.0,8.0,8.0,0.0,0.0,0.0,0.0]
[null,9.240825E7,"2011-12-23",10.0,8.0,8.0,0.0,2.0,2.0,0.0]
[null,9.0963745E7,"2011-12-23",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,9.6097193E7,"2011-12-23",12.0,8.0,8.0,0.0,4.0,2.9833333333333343,1.0166666666666657]
[null,9.3638537E7,"2011-12-23",8.0,8.0,3.9833333333333343,4.016666666666666,0.0,0.0,0.0]
[null,9.870252E7,"2011-12-23",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,9.5721889E7,"2011-12-23",8.0,8.0,8.0,0.0,0.0,0.0,0.0]
[null,9.2722045E7,"2011-12-23",10.0,8.0,8.0,0.0,2.0,2.0,0.0]
[null,9.7527365E7,"2011-12-23",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,9.707096E7,"2011-12-23",12.0,8.0,8.0,0.0,4.0,2.9833333333333343,1.0166666666666657]
[null,9.4144851E7,"2011-12-23",8.0,8.0,3.9833333333333343,4.016666666666666,0.0,0.0,0.0]
[null,9.2931162E7,"2011-12-23",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,9.6554557E7,"2011-12-23",8.0,8.0,8.0,0.0,0.0,0.0,0.0]
[null,9.2456336E7,"2011-12-23",10.0,8.0,8.0,0.0,2.0,2.0,0.0]
[null,9.5807147E7,"2011-12-23",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,9.2963879E7,"2011-12-23",12.0,8.0,8.0,0.0,4.0,2.9833333333333343,1.0166666666666657]
[null,9.4180411E7,"2011-12-23",8.0,8.0,3.9833333333333343,4.016666666666666,0.0,0.0,0.0]
[null,9.166605E7,"2011-12-23",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,9.9166507E7,"2011-12-23",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,1.2345678E7,"2011-12-26",8.0,8.0,8.0,0.0,0.0,0.0,0.0]
[null,9.240825E7,"2011-12-26",10.0,8.0,8.0,0.0,2.0,2.0,0.0]
[null,9.0963745E7,"2011-12-26",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,9.6097193E7,"2011-12-26",12.0,8.0,8.0,0.0,4.0,2.9833333333333343,1.0166666666666657]
[null,9.3638537E7,"2011-12-26",8.0,8.0,3.9833333333333343,4.016666666666666,0.0,0.0,0.0]
[null,9.870252E7,"2011-12-26",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,9.5721889E7,"2011-12-26",8.0,8.0,8.0,0.0,0.0,0.0,0.0]
[null,9.2722045E7,"2011-12-26",10.0,8.0,8.0,0.0,2.0,2.0,0.0]
[null,9.7527365E7,"2011-12-26",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,9.707096E7,"2011-12-26",12.0,8.0,8.0,0.0,4.0,2.9833333333333343,1.0166666666666657]
[null,9.4144851E7,"2011-12-26",8.0,8.0,3.9833333333333343,4.016666666666666,0.0,0.0,0.0]
[null,9.2931162E7,"2011-12-26",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,9.6554557E7,"2011-12-26",8.0,8.0,8.0,0.0,0.0,0.0,0.0]
[null,9.2456336E7,"2011-12-26",10.0,8.0,8.0,0.0,2.0,2.0,0.0]
[null,9.5807147E7,"2011-12-26",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,9.2963879E7,"2011-12-26",12.0,8.0,8.0,0.0,4.0,2.9833333333333343,1.0166666666666657]
[null,9.4180411E7,"2011-12-26",8.0,8.0,3.9833333333333343,4.016666666666666,0.0,0.0,0.0]
[null,9.166605E7,"2011-12-26",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,9.9166507E7,"2011-12-26",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,1.2345678E7,{"$f":"TODAY()","v":"2021-08-29"},8.0,8.0,8.0,0.0,0.0,0.0,0.0]
[null,9.240825E7,"2021-08-29",10.0,8.0,8.0,0.0,2.0,2.0,0.0]
[null,9.0963745E7,"2021-08-29",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,9.6097193E7,"2021-08-29",12.0,8.0,8.0,0.0,4.0,2.9833333333333343,1.0166666666666657]
[null,9.3638537E7,"2021-08-29",8.0,8.0,3.9833333333333343,4.016666666666666,0.0,0.0,0.0]
[null,9.870252E7,"2021-08-29",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,9.5721889E7,"2021-08-29",8.0,8.0,8.0,0.0,0.0,0.0,0.0]
[null,9.2722045E7,"2021-08-29",10.0,8.0,8.0,0.0,2.0,2.0,0.0]
[null,9.7527365E7,"2021-08-29",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,9.707096E7,"2021-08-29",12.0,8.0,8.0,0.0,4.0,2.9833333333333343,1.0166666666666657]
[null,9.4144851E7,"2021-08-29",8.0,8.0,3.9833333333333343,4.016666666666666,0.0,0.0,0.0]
[null,9.2931162E7,"2021-08-29",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,9.6554557E7,"2021-08-29",8.0,8.0,8.0,0.0,0.0,0.0,0.0]
[null,9.2456336E7,"2021-08-29",10.0,8.0,8.0,0.0,2.0,2.0,0.0]
[null,9.5807147E7,"2021-08-29",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,9.2963879E7,"2021-08-29",12.0,8.0,8.0,0.0,4.0,2.9833333333333343,1.0166666666666657]
[null,9.4180411E7,"2021-08-29",8.0,8.0,3.9833333333333343,4.016666666666666,0.0,0.0,0.0]
[null,9.166605E7,"2021-08-29",10.0,8.0,0.0,8.0,2.0,2.0,0.0]
[null,9.9166507E7,"2021-08-29",10.0,8.0,0.0,8.0,2.0,2.0,0.0]

{"sheet":"Consulta de Turnos por Cédula","index":5,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":true,"merged":[[3,1,4,1],[3,2,4,2],[3,3,3,5],[3,6,3,8]]}
[]
[null,"CEDULA",8.3234777E7]
[]
[null,"Fecha","Total Laboradas","Ordinarias Laboradas",null,null,"Extras Laboradas"]
[null,null,null,"Total","Diurnas","Nocturnas","Total","Diurnas","Nocturnas"]
[null,"2011-12-23",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,"2011-12-26",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]
[null,"2011-12-27",9.0,8.0,6.983333333333334,1.0166666666666657,1.0,0.0,1.0]