{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Zeitberechnung","Kalkulation 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Zeitberechnung","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,3,10,3],[12,0,14,6],[4,4,7,5]]}
[]
[null,"Datum","Beginn","Ende","Pause","Zeitkonto"]
[null,"2021-09-16","18:30:00","23:30:00","00:30:00",{"$f":"IF(D3<C3,(B3+1+D3)-(B3+C3)-E3,D3-C3-E3)","v":"04:30:00"}]
[]
[null,null,{"$f":"B3+C3","v":"2021-09-16T18:30:00"},null,{"$f":"_xlfn.FORMULATEXT(F3)","v":"=WENN(D3<C3;(B3+1+D3)-(B3+C3)-E3;D3-C3-E3)"}]
[]
[]
[]
[]
[null,"2021-09-11","09:00:00",{"$f":"(INT((B11+C11)-(B10+C10))&IF(INT((B11+C11)-(B10+C10))=1,\" Tag und\",\" Tage und\"))&CHAR(10)&(TEXT((B11+C11)-(B10+C10)-INT((B11+C11)-(B10+C10)),\"hh:mm\")&\" Std.\")","v":"3 Tage und\n07:30 Std."}]
[null,"2021-09-14","16:30:00"]
[]
["=GANZZAHL((B11+C11)-(B10+C10))&WENN(GANZZAHL((B11+C11)-(B10+C10))=1;\" Tag und \";\" Tage und \")&ZEICHEN(10)&TEXT(((B11+C11)-(B10+C10))-GANZZAHL((B11+C11)-(B10+C10));\"hh:mm\")&\" Std.\""]
[]
[]
[]
[null,null,null,"Zähler:",4]
[null,17]

{"sheet":"Kalkulation 2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}