{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Лист1","index":0,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,12,2,13],[3,8,4,8],[7,8,9,8],[11,8,12,8],[2,8,2,10]]}
[]
[]
[null,"Дата","Устройство","ЗАПУСК","Время\nОСТАНОВКИ","Время\nв работе",{"$f":"SUM(G4:G13)","v":"22:30:00"},null,"промежутки времени\nдля нагляднеости",null,null,null,"Время работы",null,"Общее время работы"]
[null,"2024-09-21",1111,"07:00:00","11:00:00",{"$f":"E4-D4+1","v":1.1666666666666665},{"$f":"E4-MAX(D4,E3)+(D4>E4)","v":"04:00:00"},null,"с 7:00 до 12:00  = 6:00 часов работы",null,"06:00:00",null,"USL689","12:20:00",{"$f":"SUM(K4:K13)","v":"23:30:00"}]
[null,"2024-09-21",2222,"09:00:00","12:00:00",1.125,{"$f":"E5-MAX(D5,E4)+(D5>E5)","v":"01:00:00"},null,null,null,null,null,575,"11:25:00"]
[null,"2024-09-21",3333,"12:00:00","12:25:00",1.0173611111111112,"00:25:00",null,"0:25 часов работы",null,"00:25:00",null,568,"00:25:00"]
[null,"2024-09-21",2222,"12:45:00","12:55:00",1.0069444444444444,"00:10:00",null,"0:10 часов работы",null,"00:10:00",null,"USL610","01:35:00"]
[null,"2024-09-21",2222,"13:05:00","13:20:00",1.0104166666666665,"00:15:00",null,"с 13:05 до 1:10  = 12:05 часов работы",null,"12:05:00"]
[null,"2024-09-21",2222,"13:20:00","18:05:00",1.1979166666666665,"04:45:00"]
[null,"2024-09-21",1111,"18:00:00","01:10:00","07:10:00","07:05:00"]
[null,"2024-09-21",222,"02:05:00","05:20:00",1.1354166666666665,"03:15:00",null,"3:15 часов работы",null,"03:15:00"]
[null,"2024-09-21",4444,"05:25:00","07:00:00",1.0659722222222223,"01:35:00",null,"с 5:25 до 7:00  = 1:35 часов работы",null,"01:35:00"]
[null,"2024-09-21",1111,"05:50:00","07:00:00",1.0486111111111112,"00:00:00"]
[]
[]
[null,null,null,null,"одной формулой",{"$f":"SUM(E4:E13-(TEXT(D4:D13+IFERROR(-E3:E12,0),\"чч:мм;\\0\")-IFERROR(-E3:E12,0))+(D4:D13>E4:E13))","v":"22:30:00"}]