{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Zeiterfassung"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"1904"}

{"sheet":"Zeiterfassung","index":0,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,1,6,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[3,1,3,2],[4,1,4,2],[5,1,5,2],[39,6,43,6],[42,2,42,4],[43,2,43,4],[40,2,40,4],[41,2,41,4],[39,2,39,4]]}
[]
[null,"Zeiterfassung"]
[]
[null,"Name Firma:"]
[null,"Name Arbeitnehmer:"]
[null,"Monat/Jahr:",null,"2024-01-01"]
[]
[null,"Tag","Kommt","Geht","Pausen","Arbeitsstunden","Bemerkung"]
[null,{"$f":"(MonatJahr+ROW(B1)-1)*(MONTH(MonatJahr+1)=MONTH(MonatJahr))","v":"2024-01-01"},null,null,null,{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",MOD(D9-C9-E9,1))","v":""}]
[null,{"$f":"IF(B9<>\"\",IF(MONTH(ErsterTag)=MONTH(B9+1),B9+1,\"\"),\"\")","v":"2024-01-02"},null,null,null,{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",MOD(D10-C10-E10,1))","v":""}]
[null,"2024-01-03",null,null,null,""]
[null,"2024-01-04",null,null,null,""]
[null,"2024-01-05",null,null,null,""]
[null,"2024-01-06",null,null,null,""]
[null,"2024-01-07",null,null,null,""]
[null,"2024-01-08",null,null,null,""]
[null,"2024-01-09",null,null,null,""]
[null,"2024-01-10",null,null,null,""]
[null,"2024-01-11",null,null,null,""]
[null,"2024-01-12",null,null,null,""]
[null,"2024-01-13",null,null,null,""]
[null,"2024-01-14",null,null,null,""]
[null,"2024-01-15",null,null,null,""]
[null,"2024-01-16",null,null,null,""]
[null,"2024-01-17",null,null,null,""]
[null,"2024-01-18",null,null,null,""]
[null,"2024-01-19",null,null,null,""]
[null,"2024-01-20",null,null,null,""]
[null,"2024-01-21",null,null,null,""]
[null,"2024-01-22",null,null,null,""]
[null,"2024-01-23",null,null,null,""]
[null,"2024-01-24",null,null,null,""]
[null,"2024-01-25",null,null,null,""]
[null,"2024-01-26",null,null,null,""]
[null,"2024-01-27",null,null,null,""]
[null,"2024-01-28",null,null,null,""]
[null,"2024-01-29",null,null,null,""]
[null,"2024-01-30",null,null,null,""]
[null,"2024-01-31",null,null,null,""]
[null,null,"Summe der Arbeitsstunden:",null,null,{"$f":"IF(SUM(F9:F39)=0,\"\",SUM(F9:F39))","v":""},"Unterschrift:"]
[null,null,"abgerechnete Arbeitsstunden:"]
[null,null,"+/- Stunden Arbeitszeitkonto:",null,null,{"$f":"IF(AND(F40=\"\",F41=\"\"),\"\",IF(F40=\"\",-F41,F40-F41))","v":""}]
[null,null,"Arbeitszeitkonto Vormonat:"]
[null,null,"Saldo Arbeitszeitkonto:",null,null,{"$f":"IF(AND(F42=\"\",F43=\"\"),\"\",IF(F42=\"\",F43,F42+F43))","v":""}]