{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["GENERAL"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"GENERAL","index":0,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["DÍA SEMANA","FECHA","PUESTO","H ENTRADA","H SALIDA","H TRABAJADAS","H NOCHE","H FESTIVO"]
[{"$f":"PROPER(TEXT(B2,\"DDD\"))","v":"Mié"},"2020-01-01","LIBRE",null,null,{"$f":"IF(C2=\"Libre\",\"\",IF(E2<D2,E2-D2+24,E2-D2))","v":""},{"$f":"IF(D2=\"\",\"\",IF(OR(E2=\"\",D2=\"\"),0,HoraN(D2,E2)))","v":""},{"$f":"IF(A3=\"sáb\",F3,IF(A3=\"dom\",F3,\"\"))","v":""},null,"Tramo festivo desde las 22:00 horas del viernes, hasta las 00:00 horas del lunes."]
[{"$f":"PROPER(TEXT(B3,\"DDD\"))","v":"Jue"},"2020-01-02","EJEMPLO TARDE","15:00:00","22:30:00",{"$f":"IF(C3=\"Libre\",\"\",IF(E3<D3,E3-D3+24,E3-D3))","v":"07:30:00"},{"$f":"IF(D3=\"\",\"\",IF(OR(E3=\"\",D3=\"\"),0,HoraN(D3,E3)))","v":"00:30"},{"$f":"IF(A4=\"sáb\",F4,IF(A4=\"dom\",F4,\"\"))","v":""}]
["Vie","2020-01-03","EJEMPLO TARDE","15:00:00","22:30:00",{"$f":"IF(C4=\"Libre\",\"\",IF(E4<D4,E4-D4+24,E4-D4))","v":"07:30:00"},{"$f":"IF(D4=\"\",\"\",IF(OR(E4=\"\",D4=\"\"),0,HoraN(D4,E4)))","v":"00:30"},"00:30:00",null,"En este caso, solo trabajo 00:30 horas en tramo festivo.",null,null,null,null,"22:00 a 22:30"]
["Sáb","2020-01-04","EJEMPLO NOCHE","20:00:00","05:00:00",{"$f":"IF(C5=\"Libre\",\"\",IF(E5<D5,E5-D5+24,E5-D5))","v":23.375},{"$f":"IF(D5=\"\",\"\",IF(OR(E5=\"\",D5=\"\"),0,HoraN(D5,E5)))","v":"07:00"},"09:00:00",null,"Aquí, todo el turno esta comprendido en el tramo festivo.",null,null,null,null,"20:00 a 5:00"]
["Dom","2020-01-05","EJEMPLO TARDE","19:00:00","02:00:00",{"$f":"IF(C6=\"Libre\",\"\",IF(E6<D6,E6-D6+24,E6-D6))","v":23.291666666666668},{"$f":"IF(D6=\"\",\"\",IF(OR(E6=\"\",D6=\"\"),0,HoraN(D6,E6)))","v":"04:00"},"05:00:00",null,"En esta ocasión, solo 5:00 horas estan dentro del tramo festivo.",null,null,null,null,"19:00 a 00:00"]
["Lun","2020-01-06","EJEMPLO TARDE","14:00:00","22:00:00",{"$f":"IF(C7=\"Libre\",\"\",IF(E7<D7,E7-D7+24,E7-D7))","v":"08:00:00"},{"$f":"IF(D7=\"\",\"\",IF(OR(E7=\"\",D7=\"\"),0,HoraN(D7,E7)))","v":"00:00"}]
["Mar","2020-01-07","LIBRE",null,null,{"$f":"IF(C8=\"Libre\",\"\",IF(E8<D8,E8-D8+24,E8-D8))","v":""},{"$f":"IF(D8=\"\",\"\",IF(OR(E8=\"\",D8=\"\"),0,HoraN(D8,E8)))","v":""}]