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

{"sheet":"Hoja de horas","index":0,"n_rows":18,"n_cols":8,"rows_kept":18}
[{"$nulls":7}," "]
[null,"Detalles del empleado",{"$nulls":4},"Total de horas de semana laboral"]
[null,"Escriba el nombre del empleado",{"$nulls":4},{"v":40,"d":"40.00"}]
[null,"Escriba teléfono del empleado",{"$nulls":4},"Total de horas trabajadas"]
[null,"Detalles del director",{"$nulls":4},{"$f":"SUM(Table_Timesheet[Horas trabajadas])","v":{"v":0,"d":"0.00"}}]
[null,"Escriba el nombre del director",{"$nulls":4},"Horas normales"]
[null,"Escriba teléfono del director",{"$nulls":4},{"$f":"IF(Total_de_horas_trabajadas<=WorkWeekHours,Total_de_horas_trabajadas,WorkWeekHours)","v":{"v":0,"d":"0.00"}}]
[null,"Período de horas trabajadas",{"$nulls":4},"Horas extra"]
[null,"Inicio del período","Escriba la fecha de inicio",{"$nulls":3},{"$f":"Total_de_horas_trabajadas-Horas_normales","v":{"v":0,"d":"0.00"}}]
[null,"Final del período","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"}}]