{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Hoja de horas"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Hoja de horas","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[1,1,1,4],[2,1,2,4]]}
[]
[null,"HOJA DE HORAS"]
[null,"Nombre de la empresa",{"$nulls":5}," "]
[]
[null,"Detalles del empleado",null,null,"Detalles del director"]
[null,"Escriba el nombre del empleado",null,null,"Escriba el nombre del director"]
[null,"Escriba teléfono del empleado",null,null,"Escriba teléfono del director"]
[null,"Total de horas de semana laboral",null,null,"Total de horas trabajadas"]
[null,40,null,null,{"$f":"SUM(Table_Timesheet[Horas trabajadas])","v":{"v":0,"d":"0.00"}}]
[null,"Horas extra",null,null,"Horas normales"]
[null,{"$f":"Total_de_horas_trabajadas-Horas_normales","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(Total_de_horas_trabajadas<=WorkWeekHours,Total_de_horas_trabajadas,WorkWeekHours)","v":{"v":0,"d":"0.00"}}]
[null,"Período de horas trabajadas"]
[null,"Inicio del período",null,null,"Final del período"]
[null,"Escriba la fecha de inicio",null,null,"Escriba la fecha de finalización"]
[null,"Fecha","Hora de entrada","Inicio del almuerzo","Fin del almuerzo","Hora de salida","Horas trabajadas"]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Hora de entrada]:[Hora de salida]])=4,(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Fin del almuerzo]]+Table_Timesheet[[#This Row],[Inicio del almuerzo]]-Table_Timesheet[[#This Row],[Hora de entrada]],IF(AND(LEN(Table_Timesheet[[#This Row],[Hora de entrada]])<>0,LEN(Table_Timesheet[[#This Row],[Hora de salida]])<>0),(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Hora de entrada]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Hora de entrada]:[Hora de salida]])=4,(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Fin del almuerzo]]+Table_Timesheet[[#This Row],[Inicio del almuerzo]]-Table_Timesheet[[#This Row],[Hora de entrada]],IF(AND(LEN(Table_Timesheet[[#This Row],[Hora de entrada]])<>0,LEN(Table_Timesheet[[#This Row],[Hora de salida]])<>0),(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Hora de entrada]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Hora de entrada]:[Hora de salida]])=4,(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Fin del almuerzo]]+Table_Timesheet[[#This Row],[Inicio del almuerzo]]-Table_Timesheet[[#This Row],[Hora de entrada]],IF(AND(LEN(Table_Timesheet[[#This Row],[Hora de entrada]])<>0,LEN(Table_Timesheet[[#This Row],[Hora de salida]])<>0),(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Hora de entrada]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Hora de entrada]:[Hora de salida]])=4,(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Fin del almuerzo]]+Table_Timesheet[[#This Row],[Inicio del almuerzo]]-Table_Timesheet[[#This Row],[Hora de entrada]],IF(AND(LEN(Table_Timesheet[[#This Row],[Hora de entrada]])<>0,LEN(Table_Timesheet[[#This Row],[Hora de salida]])<>0),(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Hora de entrada]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Hora de entrada]:[Hora de salida]])=4,(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Fin del almuerzo]]+Table_Timesheet[[#This Row],[Inicio del almuerzo]]-Table_Timesheet[[#This Row],[Hora de entrada]],IF(AND(LEN(Table_Timesheet[[#This Row],[Hora de entrada]])<>0,LEN(Table_Timesheet[[#This Row],[Hora de salida]])<>0),(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Hora de entrada]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Hora de entrada]:[Hora de salida]])=4,(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Fin del almuerzo]]+Table_Timesheet[[#This Row],[Inicio del almuerzo]]-Table_Timesheet[[#This Row],[Hora de entrada]],IF(AND(LEN(Table_Timesheet[[#This Row],[Hora de entrada]])<>0,LEN(Table_Timesheet[[#This Row],[Hora de salida]])<>0),(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Hora de entrada]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Hora de entrada]:[Hora de salida]])=4,(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Fin del almuerzo]]+Table_Timesheet[[#This Row],[Inicio del almuerzo]]-Table_Timesheet[[#This Row],[Hora de entrada]],IF(AND(LEN(Table_Timesheet[[#This Row],[Hora de entrada]])<>0,LEN(Table_Timesheet[[#This Row],[Hora de salida]])<>0),(IF(Table_Timesheet[[#This Row],[Hora de salida]]<Table_Timesheet[[#This Row],[Hora de entrada]],1,0)+Table_Timesheet[[#This Row],[Hora de salida]])-Table_Timesheet[[#This Row],[Hora de entrada]],0))*24,0)","v":{"v":0,"d":"0.00"}}]