{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Aufzeichnung"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":1,"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":"Aufzeichnung","index":0,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,2,4,4],[3,2,3,4],[28,6,28,8],[29,6,29,8],[8,2,8,4],[6,2,6,4],[5,2,5,4],[26,6,26,8],[10,2,10,4],[25,6,25,8],[57,1,57,3],[41,6,41,8],[42,6,42,8],[43,6,43,8],[44,6,44,8],[45,6,45,8],[46,6,46,8],[57,4,57,5],[14,0,15,0],[14,6,15,8],[27,6,27,8],[16,6,16,8],[17,6,17,8],[18,6,18,8],[19,6,19,8],[20,6,20,8],[21,6,21,8],[22,6,22,8],[23,6,23,8],[24,6,24,8],[30,6,30,8],[40,6,40,8],[31,6,31,8],[32,6,32,8],[34,6,34,8],[35,6,35,8],[36,6,36,8],[37,6,37,8],[38,6,38,8],[39,6,39,8],[33,6,33,8]]}
["Aufzeichnung der täglichen Arbeitszeit"]
[]
[]
[]
["Arbeitgeber"]
["ggfs. Stempel"]
[]
[]
["Mitarbeiter"]
[]
["Monat/Jahr  "]
[]
["Stundenlohn"]
[]
["Datum","Beginn","Pause","Ende","Arbeitszeit","Beson-","Bemerkungen / Info zu Zuschlägen"]
[null,"(Uhrzeit)","(Dauer)","(Uhrzeit)","(Dauer)","derheit 1)"]
[{"$f":"$C$11","v":"00:00:00"},null,null,null,{"$f":"IF(OR(VALUE(TEXT(B17,\"00\"\":\"\"00\"))>1,VALUE(TEXT(C17,\"00\"\":\"\"00\"))>1,VALUE(TEXT(D17,\"00\"\":\"\"00\"))>1),\"Eingabe?\",IF(VALUE(TEXT(D17,\"00\"\":\"\"00\"))<VALUE(TEXT(B17,\"00\"\":\"\"00\")),\"Ende<Beginn\",IF(ROUNDDOWN(VALUE(TEXT(D17,\"00\"\":\"\"00\")),10)-ROUNDDOWN(VALUE(TEXT(B17,\"00\"\":\"\"00\")),10)<ROUNDDOWN(VALUE(TEXT(C17,\"00\"\":\"\"00\")),10),\"Pause > AZ\",MOD(VALUE(TEXT(D17,\"00\"\":\"\"00\"))-VALUE(TEXT(C17,\"00\"\":\"\"00\"))-VALUE(TEXT(B17,\"00\"\":\"\"00\")),1))))","v":"00:00:00"}]
[{"$f":"$C$11+1","v":"1900-01-01"},null,null,null,{"$f":"IF(OR(VALUE(TEXT(B18,\"00\"\":\"\"00\"))>1,VALUE(TEXT(C18,\"00\"\":\"\"00\"))>1,VALUE(TEXT(D18,\"00\"\":\"\"00\"))>1),\"Eingabe?\",IF(VALUE(TEXT(D18,\"00\"\":\"\"00\"))<VALUE(TEXT(B18,\"00\"\":\"\"00\")),\"Ende<Beginn\",IF(ROUNDDOWN(VALUE(TEXT(D18,\"00\"\":\"\"00\")),10)-ROUNDDOWN(VALUE(TEXT(B18,\"00\"\":\"\"00\")),10)<ROUNDDOWN(VALUE(TEXT(C18,\"00\"\":\"\"00\")),10),\"Pause > AZ\",MOD(VALUE(TEXT(D18,\"00\"\":\"\"00\"))-VALUE(TEXT(C18,\"00\"\":\"\"00\"))-VALUE(TEXT(B18,\"00\"\":\"\"00\")),1))))","v":"00:00:00"}]
[{"$f":"$C$11+2","v":"1900-01-02"},null,null,null,"00:00:00"]
[{"$f":"$C$11+3","v":"1900-01-03"},null,null,null,"00:00:00"]
[{"$f":"$C$11+4","v":"1900-01-04"},null,null,null,"00:00:00"]
[{"$f":"$C$11+5","v":"1900-01-05"},null,null,null,"00:00:00"]
[{"$f":"$C$11+6","v":"1900-01-06"},null,null,null,"00:00:00"]
[{"$f":"$C$11+7","v":"1900-01-07"},null,null,null,"00:00:00"]
[{"$f":"$C$11+8","v":"1900-01-08"},null,null,null,"00:00:00"]
[{"$f":"$C$11+9","v":"1900-01-09"},null,null,null,"00:00:00"]
[{"$f":"$C$11+10","v":"1900-01-10"},null,null,null,"00:00:00"]
[{"$f":"$C$11+11","v":"1900-01-11"},null,null,null,"00:00:00"]
[{"$f":"$C$11+12","v":"1900-01-12"},null,null,null,"00:00:00"]
[{"$f":"$C$11+13","v":"1900-01-13"},null,null,null,"00:00:00"]
[{"$f":"$C$11+14","v":"1900-01-14"},null,null,null,"00:00:00"]
[{"$f":"$C$11+15","v":"1900-01-15"},null,null,null,"00:00:00"]
[{"$f":"$C$11+16","v":"1900-01-16"},null,null,null,"00:00:00"]
[{"$f":"$C$11+17","v":"1900-01-17"},null,null,null,"00:00:00"]
[{"$f":"$C$11+18","v":"1900-01-18"},null,null,null,"00:00:00"]
[{"$f":"$C$11+19","v":"1900-01-19"},null,null,null,"00:00:00"]
[{"$f":"$C$11+20","v":"1900-01-20"},null,null,null,"00:00:00"]
[{"$f":"$C$11+21","v":"1900-01-21"},null,null,null,"00:00:00"]
[{"$f":"$C$11+22","v":"1900-01-22"},null,null,null,"00:00:00"]
[{"$f":"$C$11+23","v":"1900-01-23"},null,null,null,"00:00:00"]
[{"$f":"$C$11+24","v":"1900-01-24"},null,null,null,"00:00:00"]
[{"$f":"$C$11+25","v":"1900-01-25"},null,null,null,"00:00:00"]
[{"$f":"$C$11+26","v":"1900-01-26"},null,null,null,"00:00:00"]
[{"$f":"$C$11+27","v":"1900-01-27"},null,null,null,"00:00:00"]
[{"$f":"IF(($C$11+28)*(MONTH(A44+1)=MONTH($C$11))=0,\"\",($C$11+28)*(MONTH(A44+1)=MONTH($C$11)))","v":"1900-01-28"},null,null,null,{"$f":"IF(A45=\"\",\"\",IF(OR(VALUE(TEXT(B45,\"00\"\":\"\"00\"))>1,VALUE(TEXT(C45,\"00\"\":\"\"00\"))>1,VALUE(TEXT(D45,\"00\"\":\"\"00\"))>1),\"Eingabe?\",IF(VALUE(TEXT(D45,\"00\"\":\"\"00\"))<VALUE(TEXT(B45,\"00\"\":\"\"00\")),\"Ende<Beginn\",IF(ROUNDDOWN(VALUE(TEXT(D45,\"00\"\":\"\"00\")),10)-ROUNDDOWN(VALUE(TEXT(B45,\"00\"\":\"\"00\")),10)<ROUNDDOWN(VALUE(TEXT(C45,\"00\"\":\"\"00\")),10),\"Pause > AZ\",MOD(VALUE(TEXT(D45,\"00\"\":\"\"00\"))-VALUE(TEXT(C45,\"00\"\":\"\"00\"))-VALUE(TEXT(B45,\"00\"\":\"\"00\")),1)))))","v":"00:00:00"}]
[{"$f":"IF(($C$11+28)*(MONTH(A44+2)=MONTH($C$11))=0,\"\",($C$11+29)*(MONTH(A44+2)=MONTH($C$11)))","v":"1900-01-29"},null,null,null,{"$f":"IF(A46=\"\",\"\",IF(OR(VALUE(TEXT(B46,\"00\"\":\"\"00\"))>1,VALUE(TEXT(C46,\"00\"\":\"\"00\"))>1,VALUE(TEXT(D46,\"00\"\":\"\"00\"))>1),\"Eingabe?\",IF(VALUE(TEXT(D46,\"00\"\":\"\"00\"))<VALUE(TEXT(B46,\"00\"\":\"\"00\")),\"Ende<Beginn\",IF(ROUNDDOWN(VALUE(TEXT(D46,\"00\"\":\"\"00\")),10)-ROUNDDOWN(VALUE(TEXT(B46,\"00\"\":\"\"00\")),10)<ROUNDDOWN(VALUE(TEXT(C46,\"00\"\":\"\"00\")),10),\"Pause > AZ\",MOD(VALUE(TEXT(D46,\"00\"\":\"\"00\"))-VALUE(TEXT(C46,\"00\"\":\"\"00\"))-VALUE(TEXT(B46,\"00\"\":\"\"00\")),1)))))","v":"00:00:00"}]
[{"$f":"IF(($C$11+28)*(MONTH(A44+3)=MONTH($C$11))=0,\"\",($C$11+30)*(MONTH(A44+3)=MONTH($C$11)))","v":"1900-01-30"},null,null,null,{"$f":"IF(A47=\"\",\"\",IF(OR(VALUE(TEXT(B47,\"00\"\":\"\"00\"))>1,VALUE(TEXT(C47,\"00\"\":\"\"00\"))>1,VALUE(TEXT(D47,\"00\"\":\"\"00\"))>1),\"Eingabe?\",IF(VALUE(TEXT(D47,\"00\"\":\"\"00\"))<VALUE(TEXT(B47,\"00\"\":\"\"00\")),\"Ende<Beginn\",IF(ROUNDDOWN(VALUE(TEXT(D47,\"00\"\":\"\"00\")),10)-ROUNDDOWN(VALUE(TEXT(B47,\"00\"\":\"\"00\")),10)<ROUNDDOWN(VALUE(TEXT(C47,\"00\"\":\"\"00\")),10),\"Pause > AZ\",MOD(VALUE(TEXT(D47,\"00\"\":\"\"00\"))-VALUE(TEXT(C47,\"00\"\":\"\"00\"))-VALUE(TEXT(B47,\"00\"\":\"\"00\")),1)))))","v":"00:00:00"}]
[]
["Summe Arbeitszeit",null,null,null,{"$f":"SUM(E17:E47)","v":0}]
[]
[{"$f":"IF(C11=\"\",\"Lohn\",\"Lohn \"&TEXT(C11,\"MMMM\")&\" \"&YEAR(C11))","v":"Lohn"},null,null,null,{"$f":"C13*24*E49","v":0}]
[]
["Wir versichern, die oben gemachten Aufzeichnungen zeitnah (maximal 7 Tage nach dem jeweiligen Arbeitstag) gemacht zu haben."]
[]
[null,null,null,null,null,null,null,"1) Besonderheiten"]
[null,null,null,null,null,null,null,"K = Krankheit"]
[null,null,null,null,null,null,null,"U = Urlaub"]
["Datum","Unterschrift Arbeitnehmer",null,null,"Unterschrift Arbeitgeber",null,null,"F = Feiertag"]