{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Aitor","Hoja4","Hoja1","Hoja2","Hoja3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":0,"comments":0,"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":"Aitor","index":0,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,5],[1,6,1,10],[2,3,2,5],[2,7,2,10],[41,1,41,10],[42,7,42,10],[40,0,40,10],[3,7,3,8],[3,9,3,10],[6,0,7,1],[6,2,7,2],[6,3,6,4],[6,5,6,6],[6,7,7,7],[6,9,7,9],[6,10,7,10],[4,3,4,5],[4,7,4,10]]}
["REGISTRO DIARIO DE JORNADA EN TRABAJADORES A TIEMPO COMPLETO"]
["EMPRESA",null,null,null,null,null,"TRABAJADOR/A"]
["Nombre o Razón Social:",null,null,null,null,null,"Nombre:"]
["CIF:",null,null,null,null,null,"NIF:"]
["C.C.C.:",null,null,null,null,null,"NAF:"]
["Período de liquidación:",null,null,{"$f":"_xlfn.NUMBERVALUE(1&H6&K6)","v":"2023-01-01"},"AL",{"$f":"EOMONTH(D6,0)","v":"2023-01-31"},"Fecha:",{"$f":"[1]Hoja1!$A$2","v":"ENERO"},"AÑO","AÑO",{"$f":"[1]Hoja1!$B$2","v":2023}]
["Día del mes",null,null,"Mañana",null,"Tarde",null,"Total Horas\nJornada",null,"Horas\nOrdinarias","Horas\nExtras"]
[null,null,null,"Entrada","Salida","Entrada","Salida"]
[{"$f":"D6","v":"2023-01-01"},{"$f":"TEXT(A9,\"ddd\")","v":"do"},null,"09:00:00","14:00:00","16:00:00","20:00:00",{"$f":"IF(D9=0,\" \",(E9-D9)+(G9-F9)+1)","v":1.375},null,{"$f":"IF(OR(ISBLANK(D9),ISBLANK(E9)),\" \",\"08:30\")","v":"08:30"},{"$f":"IF(D9=0,\"\",MAX(H9-J9,1))","v":1.0208333333333333}]
[{"$f":"IF(A9<$F$6,A9+1,\" \")","v":"2023-01-02"},"lu",null,"08:00:00","12:00:00",null,null,1.1666666666666667,null,{"$f":"IF(OR(ISBLANK(D10),ISBLANK(E10)),\" \",\"08:30\")","v":"08:30"},1]
["2023-01-03","ma",null,"23:50:00","05:00:00","16:00:00","21:00:00",{"$f":"IF(D11=0,\" \",(E11-D11)+(G11-F11)+1)","v":"10:10:00"},null,"08:30",1]
["2023-01-04","mi",null,"07:00:00","15:00:00","21:00:00","23:50:00",1.4513888888888888,null,"08:30",1.0972222222222221]
["2023-01-05","ju",null,"08:42:00","14:27:00",null,null,1.2395833333333333,null,"08:30",1]
["2023-01-06","vi","VACACIONES",null,null,null,null," ",null," ","","suma horas",{"$f":"H9+H10+H11","v":2.9652777777777781},{"$f":"SUM(H9:H12)","v":4.416666666666667}]
["2023-01-07","sá","VACACIONES",null,null,null,null," ",null," ",""]
["2023-01-08","do","VACACIONES",null,null,null,null," ",null," ","",null,"si sumo horas que no sobrepasan las 24 h la suma la hace bien , pero en el momento que sobrepasa las "]
["2023-01-09","lu",null,null,null,null,null," ",null," ","",null,"24 h, aunque le ponga el formato de [h] el resultado es erroneo, tendria que dar 39:45 h y da 106 o "]
["2023-01-10","ma",null,null,null,null,null," ",null," ","",null,"en el sumatorio de la columna H 135:45"]
["2023-01-11","mi",null,null,null,null,null," ",null," ",""]
["2023-01-12","ju",null,null,null,null,null," ",null," ",""]
["2023-01-13","vi",null,null,null,null,null," ",null," ","",null,"otra cosa que tengo que solucionar es con otros empleados conozco la hora de entrada y salida de mañana y la hora de "]
["2023-01-14","sá",null,null,null,null,null," ",null," ","",null,"entrada de tarde y las horas que tiene que hacer y necesitaria una formula que me diera automaticamente la hora de salida de la tarde"]
["2023-01-15","do",null,null,null,null,null," ",null," ",""]
["2023-01-16","lu",null,null,null,null,null," ",null," ",""]
["2023-01-17","ma",null,null,null,null,null," ",null," ",""]
["2023-01-18","mi",null,null,null,null,null," ",null," ",""]
["2023-01-19","ju",null,null,null,null,null," ",null," ",""]
["2023-01-20","vi",null,null,null,null,null," ",null," ",""]
["2023-01-21","sá",null,null,null,null,null," ",null," ",""]
["2023-01-22","do",null,null,null,null,null," ",null," ",""]
["2023-01-23","lu",null,null,null,null,null," ",null," ",""]
["2023-01-24","ma",null,null,null,null,null," ",null," ",""]
["2023-01-25","mi",null,null,null,null,null," ",null," ",""]
["2023-01-26","ju",null,null,null,null,null," ",null," ",""]
["2023-01-27","vi",null,null,null,null,null," ",null," ",""]
["2023-01-28","sá",null,null,null,null,null," "," "," ",""]
["2023-01-29","do",null,null,null,null,null," "," "," ",""]
["2023-01-30","lu",null,null,null,null,null," "," "," ",""]
["2023-01-31","ma",null,null,null,null,null," "," "," ",""]
["Total Mes",null,null,null,null,null,null,{"$f":"SUM(H9:H39)","v":5.65625},{"$f":"AVERAGE(I23:I35)*2","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J9:J39)","v":0},{"$f":"SUM(K9:K39)","v":5.1180555555555554}]
["En cumplimiento de la obligación establecida en el Art. 35.5  del Real Decreto Legislativo 2/2015 de 23 de Octubre, por el que se aprueba el texto refundido del la Ley del Estatuto de los Trabajadores"]
[null,"por el que se aprueba el texto refundido de la Ley del Estatuto de los Trabajadores"]
[null,null,null,null,"Firma de la Empresa",null,null,"Firma del Trabajador"]

{"sheet":"Hoja4","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["DIA LIBRE"]
["VACACIONES"]
["BAJA LAB"]
["FESTIVO"]

{"sheet":"Hoja1","index":2,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,10],[0,13,0,20],[1,0,1,5],[1,6,1,10],[1,13,1,16],[1,17,1,20],[2,3,2,5],[2,7,2,10],[2,15,2,16],[3,7,3,8],[3,9,3,10],[4,17,4,18],[4,19,4,20],[6,0,7,1],[6,2,7,2],[6,3,6,4],[6,5,6,6],[6,7,7,7],[6,9,7,9],[6,10,7,10],[6,13,7,13],[4,3,4,5],[4,7,4,10],[4,15,4,16],[41,1,41,10],[41,13,41,20],[42,7,42,10],[6,14,6,15],[6,16,6,17],[6,18,7,18],[6,19,7,19],[6,20,7,20],[40,0,40,10],[40,13,40,20]]}
["REGISTRO DIARIO DE JORNADA EN TRABAJADORES A TIEMPO COMPLETO",null,null,null,null,null,null,null,null,null,null,null,null,"REGISTRO DIARIO DE JORNADA EN TRABAJADORES A TIEMPO COMPLETO"]
["EMPRESA",null,null,null,null,null,"TRABAJADOR/A",null,null,null,null,null,null,"EMPRESA",null,null,null,"TRABAJADOR/A"]
["Nombre o Razón Social:",null,null,null,null,null,"Nombre:",null,null,null,null,null,null,"Nombre o Razón Social:",null,null,null,"Nombre:",{"$f":"H3","v":0}]
["CIF:",null,null,null,null,null,"NIF:",null,null,null,null,null,null,"CIF:",null,null,null,"NIF:",null,{"$f":"H4","v":0}]
["C.C.C.:",null,null,null,null,null,"NAF:",null,null,null,null,null,null,"C.C.C.:",null,null,null,"NAF:",null,{"$f":"H5","v":0}]
["Período de liquidación:",null,null,{"$f":"_xlfn.NUMBERVALUE(1&H6&K6)","v":"2023-01-01"},"AL",{"$f":"EOMONTH(D6,0)","v":"2023-01-31"},"Fecha:",{"$f":"[3]Hoja1!$A$2","v":"ENERO"},"AÑO","AÑO",{"$f":"[3]Hoja1!$B$2","v":2023},null,null,"Período de liquidación:",null,{"$f":"_xlfn.NUMBERVALUE(1&T6&U6)","v":"2023-01-01"},"AL",{"$f":"EOMONTH(P6,0)","v":"2023-01-31"},"Fecha:",{"$f":"H6","v":"ENERO"},{"$f":"K6","v":2023}]
["Día del mes",null,null,"Mañana",null,"Tarde",null,"Total Horas\nJornada",null,"Horas\nOrdinarias","Horas\nExtras",null,null,"Día del mes","Mañana",null,"Tarde",null,"Total Horas\nJornada","Horas\nOrdinarias","Horas\nExtras"]
[null,null,null,"Entrada","Salida","Entrada","Salida",null,null,null,null,null,null,null,"Entrada","Salida","Entrada","Salida"]
[{"$f":"D6","v":"2023-01-01"},{"$f":"TEXT(A9,\"ddd\")","v":"do"},null,"18:00:00","22:00:00",null,null,{"$f":"IF(D9=0,\" \",(E9-D9)+(G9-F9)+1)","v":1.1666666666666665},1.4583333333333333,{"$f":"IF(OR(ISBLANK(D9),ISBLANK(E9)),\" \",\"08:30\")","v":"08:30"},{"$f":"IF(D9=0,\"\",MAX(H9-J9,1))","v":1},null,null,1,{"$f":"IF(D9=0,\"\",D9)","v":"18:00:00"},"22:00:00","",null,{"$f":"IF(D9=0,\" \",\"8:30\")","v":"8:30"},{"$f":"J9","v":"08:30"},{"$f":"IF(D9=0,\" \",0)","v":0}]
[{"$f":"IF(A9<$F$6,A9+1,\" \")","v":"2023-01-02"},"lu",null,"18:00:00","22:00:00",null,null,1.1666666666666665,1.5833333333333333,"08:30",1,null,null,2,"18:00:00","22:00:00","",null,"8:30","08:30",{"$f":"IF(D10=0,\"\",0)","v":0}]
["2023-01-03","ma",null,"18:00:00","22:00:00",null,null,1.1666666666666665,"04:00:00","08:30",1,null,null,3,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-04","mi",null,"18:00:00","22:00:00",null,null,1.1666666666666665,"08:30:00","08:30",1,null,null,4,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-05","ju",null,"18:00:00","22:00:00",null,null,1.1666666666666665,1.4444444444444444,"08:30",1,null,null,5,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-06","vi",null,"18:00:00","22:00:00",null,null,1.1666666666666665," ","08:30",1,null,null,6,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-07","sá",null,"18:00:00","22:00:00",null,null,1.1666666666666665,1.0833333333333333,"08:30",1,null,null,7,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-08","do",null,"18:00:00","22:00:00",null,null,1.1666666666666665,1.0833333333333333,"08:30",1,null,null,8,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-09","lu",null,"18:00:00","22:00:00",null,null,1.1666666666666665,null,"08:30",1,null,null,9,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-10","ma",null,"18:00:00","22:00:00",null,null,1.1666666666666665,1.5347222222222223,"08:30",1,null,null,10,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-11","mi",null,"18:00:00","22:00:00",null,null,1.1666666666666665,1.5347222222222223,"08:30",1,null,null,11,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-12","ju",null,"18:00:00","22:00:00",null,null,1.1666666666666665,1.5347222222222223,"08:30",1,null,null,12,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-13","vi",null,"18:00:00","22:00:00",null,null,1.1666666666666665," ","08:30",1,null,null,13,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-14","sá",null,"18:00:00","22:00:00",null,null,1.1666666666666665," ","08:30",1,null,null,14,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-15","do",null,"18:00:00","22:00:00",null,null,1.1666666666666665,1.5347222222222223,"08:30",1,null,null,15,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-16","lu",null,"18:00:00","22:00:00",null,null,1.1666666666666665,1.5347222222222223,"08:30",1,null,null,16,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-17","ma",null,"18:00:00","22:00:00",null,null,1.1666666666666665,1.5347222222222223,"08:30",1,null,null,17,"18:00:00","22:00:00","",null,"8:30","08:30",0]
["2023-01-18","mi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,18,"","","",null," "," ",""]
["2023-01-19","ju",null,null,null,null,null," ",1.5347222222222223," ","",null,null,19,"","","",null," "," ",""]
["2023-01-20","vi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,20,"","","",null," "," ",""]
["2023-01-21","sá",null,null,null,null,null," ",1.5347222222222223," ","",null,null,21,"","","",null," "," ",""]
["2023-01-22","do",null,null,null,null,null," ",1.5347222222222223," ","",null,null,22,"","","",null," "," ",""]
["2023-01-23","lu",null,null,null,null,null," ",1.5347222222222223," ","",null,null,23,"","","",null," "," ",""]
["2023-01-24","ma",null,null,null,null,null," ",1.5347222222222223," ","",null,null,24,"","","",null," "," ",""]
["2023-01-25","mi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,25,"","","",null," "," ",""]
["2023-01-26","ju",null,null,null,null,null," ",1.5347222222222223," ","",null,null,26,"","","",null," "," ",""]
["2023-01-27","vi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,27,"","","",null," "," ",""]
["2023-01-28","sá",null,null,null,null,null," "," "," ","",null,null,28,"","","",null," "," ",""]
["2023-01-29","do",null,null,null,null,null," "," "," ","",null,null,29,"","","",null," "," ",""]
["2023-01-30","lu",null,null,null,null,null," "," "," ","",null,null,30,"","","",null," "," ",""]
["2023-01-31","ma",null,null,null,null,null," "," "," ","",null,null,31,"","","",null," "," ",""]
["Total Mes",null,null,null,null,null,null,{"$f":"SUM(H9:H39)","v":19.833333333333332},{"$f":"AVERAGE(I23:I35)*2","v":3.0694444444444438},{"$f":"SUM(J9:J39)","v":0},{"$f":"SUM(K9:K39)","v":17},null,null,"Total Mes",null,null,null,null,{"$f":"SUM(S9:S39)","v":0},{"$f":"SUM(T9:T39)","v":0},{"$f":"SUM(U9:U39)","v":0}]
["En cumplimiento de la obligación establecida en el Art. 35.5  del Real Decreto Legislativo 2/2015 de 23 de Octubre, por el que se aprueba el texto refundido del la Ley del Estatuto de los Trabajadores",null,null,null,null,null,null,null,null,null,null,null,null,"En cumplimiento de la obligación establecida en el Art. 35.5  del Real Decreto Legislativo 2/2015 de 23 de Octubre,"]
[null,"por el que se aprueba el texto refundido de la Ley del Estatuto de los Trabajadores",null,null,null,null,null,null,null,null,null,null,null,"por el que se aprueba el texto refundido de la Ley del Estatuto de los Trabajadores"]
[null,null,null,null,"Firma de la Empresa",null,null,"Firma del Trabajador",null,null,null,null,null,null,null,"Firma de la Empresa",null,null,"Firma del Trabajador"]

{"sheet":"Hoja2","index":3,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,10],[0,13,0,20],[1,0,1,5],[1,6,1,10],[1,13,1,16],[1,17,1,20],[2,3,2,5],[2,7,2,10],[2,15,2,16],[3,7,3,8],[3,9,3,10],[4,17,4,18],[4,19,4,20],[6,0,7,1],[6,2,7,2],[6,3,6,4],[6,5,6,6],[6,7,7,7],[6,9,7,9],[6,10,7,10],[6,13,7,13],[4,3,4,5],[4,7,4,10],[4,15,4,16],[41,1,41,10],[41,13,41,20],[42,7,42,10],[6,14,6,15],[6,16,6,17],[6,18,7,18],[6,19,7,19],[6,20,7,20],[40,0,40,10],[40,13,40,20]]}
["REGISTRO DIARIO DE JORNADA EN TRABAJADORES A TIEMPO COMPLETO",null,null,null,null,null,null,null,null,null,null,null,null,"REGISTRO DIARIO DE JORNADA EN TRABAJADORES A TIEMPO COMPLETO"]
["EMPRESA",null,null,null,null,null,"TRABAJADOR/A",null,null,null,null,null,null,"EMPRESA",null,null,null,"TRABAJADOR/A"]
["Nombre o Razón Social:",null,null,null,null,null,"Nombre:",null,null,null,null,null,null,"Nombre o Razón Social:",null,null,null,"Nombre:",{"$f":"H3","v":0}]
["CIF:",null,null,null,null,null,"NIF:",null,null,null,null,null,null,"CIF:",null,null,null,"NIF:",null,{"$f":"H4","v":0}]
["C.C.C.:",null,null,null,null,null,"NAF:",null,null,null,null,null,null,"C.C.C.:",null,null,null,"NAF:",null,{"$f":"H5","v":0}]
["Período de liquidación:",null,null,{"$f":"_xlfn.NUMBERVALUE(1&H6&K6)","v":"2023-01-01"},"AL",{"$f":"EOMONTH(D6,0)","v":"2023-01-31"},"Fecha:",{"$f":"[3]Hoja1!$A$2","v":"ENERO"},"AÑO","AÑO",{"$f":"[3]Hoja1!$B$2","v":2023},null,null,"Período de liquidación:",null,{"$f":"_xlfn.NUMBERVALUE(1&T6&U6)","v":"2023-01-01"},"AL",{"$f":"EOMONTH(P6,0)","v":"2023-01-31"},"Fecha:",{"$f":"H6","v":"ENERO"},{"$f":"K6","v":2023}]
["Día del mes",null,null,"Mañana",null,"Tarde",null,"Total Horas\nJornada",null,"Horas\nOrdinarias","Horas\nExtras",null,null,"Día del mes","Mañana",null,"Tarde",null,"Total Horas\nJornada","Horas\nOrdinarias","Horas\nExtras"]
[null,null,null,"Entrada","Salida","Entrada","Salida",null,null,null,null,null,null,null,"Entrada","Salida","Entrada","Salida"]
[{"$f":"D6","v":"2023-01-01"},{"$f":"TEXT(A9,\"ddd\")","v":"do"},null,"18:00:00","22:00:00",null,null,{"$f":"IF(D9=0,\" \",(E9-D9)+(G9-F9)+1)","v":1.1666666666666665},1.4583333333333333,{"$f":"IF(OR(ISBLANK(D9),ISBLANK(E9)),\" \",\"08:30\")","v":"08:30"},{"$f":"IF(D9=0,\"\",MAX(H9-J9,1))","v":1},null,null,1,{"$f":"IF(D9=0,\"\",D9)","v":"18:00:00"},"22:00:00","",null,{"$f":"IF(D9=0,\" \",\"8:30\")","v":"8:30"},{"$f":"J9","v":"08:30"},{"$f":"IF(D9=0,\" \",0)","v":0}]
[{"$f":"IF(A9<$F$6,A9+1,\" \")","v":"2023-01-02"},"lu",null,null,null,null,null," ",1.5833333333333333," ","",null,null,2,"","","",null," "," ",{"$f":"IF(D10=0,\"\",0)","v":""}]
["2023-01-03","ma",null,null,null,null,null," ","04:00:00"," ","",null,null,3,"","","",null," "," ",""]
["2023-01-04","mi",null,null,null,null,null," ","08:30:00"," ","",null,null,4,"","","",null," "," ",""]
["2023-01-05","ju",null,null,null,null,null," ",1.4444444444444444," ","",null,null,5,"","","",null," "," ",""]
["2023-01-06","vi",null,null,null,null,null," "," "," ","",null,null,6,"","","",null," "," ",""]
["2023-01-07","sá",null,null,null,null,null," ",1.0833333333333333," ","",null,null,7,"","","",null," "," ",""]
["2023-01-08","do",null,null,null,null,null," ",1.0833333333333333," ","",null,null,8,"","","",null," "," ",""]
["2023-01-09","lu",null,null,null,null,null," ",null," ","",null,null,9,"","","",null," "," ",""]
["2023-01-10","ma",null,null,null,null,null," ",1.5347222222222223," ","",null,null,10,"","","",null," "," ",""]
["2023-01-11","mi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,11,"","","",null," "," ",""]
["2023-01-12","ju",null,null,null,null,null," ",1.5347222222222223," ","",null,null,12,"","","",null," "," ",""]
["2023-01-13","vi",null,null,null,null,null," "," "," ","",null,null,13,"","","",null," "," ",""]
["2023-01-14","sá",null,null,null,null,null," "," "," ","",null,null,14,"","","",null," "," ",""]
["2023-01-15","do",null,null,null,null,null," ",1.5347222222222223," ","",null,null,15,"","","",null," "," ",""]
["2023-01-16","lu",null,null,null,null,null," ",1.5347222222222223," ","",null,null,16,"","","",null," "," ",""]
["2023-01-17","ma",null,null,null,null,null," ",1.5347222222222223," ","",null,null,17,"","","",null," "," ",""]
["2023-01-18","mi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,18,"","","",null," "," ",""]
["2023-01-19","ju",null,null,null,null,null," ",1.5347222222222223," ","",null,null,19,"","","",null," "," ",""]
["2023-01-20","vi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,20,"","","",null," "," ",""]
["2023-01-21","sá",null,null,null,null,null," ",1.5347222222222223," ","",null,null,21,"","","",null," "," ",""]
["2023-01-22","do",null,null,null,null,null," ",1.5347222222222223," ","",null,null,22,"","","",null," "," ",""]
["2023-01-23","lu",null,null,null,null,null," ",1.5347222222222223," ","",null,null,23,"","","",null," "," ",""]
["2023-01-24","ma",null,null,null,null,null," ",1.5347222222222223," ","",null,null,24,"","","",null," "," ",""]
["2023-01-25","mi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,25,"","","",null," "," ",""]
["2023-01-26","ju",null,null,null,null,null," ",1.5347222222222223," ","",null,null,26,"","","",null," "," ",""]
["2023-01-27","vi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,27,"","","",null," "," ",""]
["2023-01-28","sá",null,null,null,null,null," "," "," ","",null,null,28,"","","",null," "," ",""]
["2023-01-29","do",null,null,null,null,null," "," "," ","",null,null,29,"","","",null," "," ",""]
["2023-01-30","lu",null,null,null,null,null," "," "," ","",null,null,30,"","","",null," "," ",""]
["2023-01-31","ma",null,null,null,null,null," "," "," ","",null,null,31,"","","",null," "," ",""]
["Total Mes",null,null,null,null,null,null,{"$f":"SUM(H9:H39)","v":1.1666666666666665},{"$f":"AVERAGE(I23:I35)*2","v":3.0694444444444438},{"$f":"SUM(J9:J39)","v":0},{"$f":"SUM(K9:K39)","v":1},null,null,"Total Mes",null,null,null,null,{"$f":"SUM(S9:S39)","v":0},{"$f":"SUM(T9:T39)","v":0},{"$f":"SUM(U9:U39)","v":0}]
["En cumplimiento de la obligación establecida en el Art. 35.5  del Real Decreto Legislativo 2/2015 de 23 de Octubre, por el que se aprueba el texto refundido del la Ley del Estatuto de los Trabajadores",null,null,null,null,null,null,null,null,null,null,null,null,"En cumplimiento de la obligación establecida en el Art. 35.5  del Real Decreto Legislativo 2/2015 de 23 de Octubre,"]
[null,"por el que se aprueba el texto refundido de la Ley del Estatuto de los Trabajadores",null,null,null,null,null,null,null,null,null,null,null,"por el que se aprueba el texto refundido de la Ley del Estatuto de los Trabajadores"]
[null,null,null,null,"Firma de la Empresa",null,null,"Firma del Trabajador",null,null,null,null,null,null,null,"Firma de la Empresa",null,null,"Firma del Trabajador"]

{"sheet":"Hoja3","index":4,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,10],[0,13,0,20],[1,0,1,5],[1,6,1,10],[1,13,1,16],[1,17,1,20],[2,3,2,5],[2,7,2,10],[2,15,2,16],[3,7,3,8],[3,9,3,10],[4,17,4,18],[4,19,4,20],[6,0,7,1],[6,2,7,2],[6,3,6,4],[6,5,6,6],[6,7,7,7],[6,9,7,9],[6,10,7,10],[6,13,7,13],[4,3,4,5],[4,7,4,10],[4,15,4,16],[41,1,41,10],[41,13,41,20],[42,7,42,10],[6,14,6,15],[6,16,6,17],[6,18,7,18],[6,19,7,19],[6,20,7,20],[40,0,40,10],[40,13,40,20]]}
["REGISTRO DIARIO DE JORNADA EN TRABAJADORES A TIEMPO COMPLETO",null,null,null,null,null,null,null,null,null,null,null,null,"REGISTRO DIARIO DE JORNADA EN TRABAJADORES A TIEMPO COMPLETO"]
["EMPRESA",null,null,null,null,null,"TRABAJADOR/A",null,null,null,null,null,null,"EMPRESA",null,null,null,"TRABAJADOR/A"]
["Nombre o Razón Social:",null,null,null,null,null,"Nombre:",null,null,null,null,null,null,"Nombre o Razón Social:",null,null,null,"Nombre:",{"$f":"H3","v":0}]
["CIF:",null,null,null,null,null,"NIF:",null,null,null,null,null,null,"CIF:",null,null,null,"NIF:",null,{"$f":"H4","v":0}]
["C.C.C.:",null,null,null,null,null,"NAF:",null,null,null,null,null,null,"C.C.C.:",null,null,null,"NAF:",null,{"$f":"H5","v":0}]
["Período de liquidación:",null,null,{"$f":"_xlfn.NUMBERVALUE(1&H6&K6)","v":"2023-01-01"},"AL",{"$f":"EOMONTH(D6,0)","v":"2023-01-31"},"Fecha:",{"$f":"[3]Hoja1!$A$2","v":"ENERO"},"AÑO","AÑO",{"$f":"[3]Hoja1!$B$2","v":2023},null,null,"Período de liquidación:",null,{"$f":"_xlfn.NUMBERVALUE(1&T6&U6)","v":"2023-01-01"},"AL",{"$f":"EOMONTH(P6,0)","v":"2023-01-31"},"Fecha:",{"$f":"H6","v":"ENERO"},{"$f":"K6","v":2023}]
["Día del mes",null,null,"Mañana",null,"Tarde",null,"Total Horas\nJornada",null,"Horas\nOrdinarias","Horas\nExtras",null,null,"Día del mes","Mañana",null,"Tarde",null,"Total Horas\nJornada","Horas\nOrdinarias","Horas\nExtras"]
[null,null,null,"Entrada","Salida","Entrada","Salida",null,null,null,null,null,null,null,"Entrada","Salida","Entrada","Salida"]
[{"$f":"D6","v":"2023-01-01"},{"$f":"TEXT(A9,\"ddd\")","v":"do"},null,"18:00:00","22:00:00",null,null,{"$f":"IF(D9=0,\" \",(E9-D9)+(G9-F9)+1)","v":1.1666666666666665},1.4583333333333333,{"$f":"IF(OR(ISBLANK(D9),ISBLANK(E9)),\" \",\"08:30\")","v":"08:30"},{"$f":"IF(D9=0,\"\",MAX(H9-J9,1))","v":1},null,null,1,{"$f":"IF(D9=0,\"\",D9)","v":"18:00:00"},"22:00:00","",null,{"$f":"IF(D9=0,\" \",\"8:30\")","v":"8:30"},{"$f":"J9","v":"08:30"},{"$f":"IF(D9=0,\" \",0)","v":0}]
[{"$f":"IF(A9<$F$6,A9+1,\" \")","v":"2023-01-02"},"lu",null,null,null,null,null," ",1.5833333333333333," ","",null,null,2,"","","",null," "," ",{"$f":"IF(D10=0,\"\",0)","v":""}]
["2023-01-03","ma",null,null,null,null,null," ","04:00:00"," ","",null,null,3,"","","",null," "," ",""]
["2023-01-04","mi",null,null,null,null,null," ","08:30:00"," ","",null,null,4,"","","",null," "," ",""]
["2023-01-05","ju",null,null,null,null,null," ",1.4444444444444444," ","",null,null,5,"","","",null," "," ",""]
["2023-01-06","vi",null,null,null,null,null," "," "," ","",null,null,6,"","","",null," "," ",""]
["2023-01-07","sá",null,null,null,null,null," ",1.0833333333333333," ","",null,null,7,"","","",null," "," ",""]
["2023-01-08","do",null,null,null,null,null," ",1.0833333333333333," ","",null,null,8,"","","",null," "," ",""]
["2023-01-09","lu",null,null,null,null,null," ",null," ","",null,null,9,"","","",null," "," ",""]
["2023-01-10","ma",null,null,null,null,null," ",1.5347222222222223," ","",null,null,10,"","","",null," "," ",""]
["2023-01-11","mi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,11,"","","",null," "," ",""]
["2023-01-12","ju",null,null,null,null,null," ",1.5347222222222223," ","",null,null,12,"","","",null," "," ",""]
["2023-01-13","vi",null,null,null,null,null," "," "," ","",null,null,13,"","","",null," "," ",""]
["2023-01-14","sá",null,null,null,null,null," "," "," ","",null,null,14,"","","",null," "," ",""]
["2023-01-15","do",null,null,null,null,null," ",1.5347222222222223," ","",null,null,15,"","","",null," "," ",""]
["2023-01-16","lu",null,null,null,null,null," ",1.5347222222222223," ","",null,null,16,"","","",null," "," ",""]
["2023-01-17","ma",null,null,null,null,null," ",1.5347222222222223," ","",null,null,17,"","","",null," "," ",""]
["2023-01-18","mi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,18,"","","",null," "," ",""]
["2023-01-19","ju",null,null,null,null,null," ",1.5347222222222223," ","",null,null,19,"","","",null," "," ",""]
["2023-01-20","vi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,20,"","","",null," "," ",""]
["2023-01-21","sá",null,null,null,null,null," ",1.5347222222222223," ","",null,null,21,"","","",null," "," ",""]
["2023-01-22","do",null,null,null,null,null," ",1.5347222222222223," ","",null,null,22,"","","",null," "," ",""]
["2023-01-23","lu",null,null,null,null,null," ",1.5347222222222223," ","",null,null,23,"","","",null," "," ",""]
["2023-01-24","ma",null,null,null,null,null," ",1.5347222222222223," ","",null,null,24,"","","",null," "," ",""]
["2023-01-25","mi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,25,"","","",null," "," ",""]
["2023-01-26","ju",null,null,null,null,null," ",1.5347222222222223," ","",null,null,26,"","","",null," "," ",""]
["2023-01-27","vi",null,null,null,null,null," ",1.5347222222222223," ","",null,null,27,"","","",null," "," ",""]
["2023-01-28","sá",null,null,null,null,null," "," "," ","",null,null,28,"","","",null," "," ",""]
["2023-01-29","do",null,null,null,null,null," "," "," ","",null,null,29,"","","",null," "," ",""]
["2023-01-30","lu",null,null,null,null,null," "," "," ","",null,null,30,"","","",null," "," ",""]
["2023-01-31","ma",null,null,null,null,null," "," "," ","",null,null,31,"","","",null," "," ",""]
["Total Mes",null,null,null,null,null,null,{"$f":"SUM(H9:H39)","v":1.1666666666666665},{"$f":"AVERAGE(I23:I35)*2","v":3.0694444444444438},{"$f":"SUM(J9:J39)","v":0},{"$f":"SUM(K9:K39)","v":1},null,null,"Total Mes",null,null,null,null,{"$f":"SUM(S9:S39)","v":0},{"$f":"SUM(T9:T39)","v":0},{"$f":"SUM(U9:U39)","v":0}]
["En cumplimiento de la obligación establecida en el Art. 35.5  del Real Decreto Legislativo 2/2015 de 23 de Octubre, por el que se aprueba el texto refundido del la Ley del Estatuto de los Trabajadores",null,null,null,null,null,null,null,null,null,null,null,null,"En cumplimiento de la obligación establecida en el Art. 35.5  del Real Decreto Legislativo 2/2015 de 23 de Octubre,"]
[null,"por el que se aprueba el texto refundido de la Ley del Estatuto de los Trabajadores",null,null,null,null,null,null,null,null,null,null,null,"por el que se aprueba el texto refundido de la Ley del Estatuto de los Trabajadores"]
[null,null,null,null,"Firma de la Empresa",null,null,"Firma del Trabajador",null,null,null,null,null,null,null,"Firma de la Empresa",null,null,"Firma del Trabajador"]