{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Arbeitszeitdokumentation","Hintergrund","Anleitung"],"not_rendered":{"charts":0,"images":2,"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":"Arbeitszeitdokumentation","index":0,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[24,8,24,10],[35,8,35,10],[22,8,22,10],[25,8,25,10],[26,8,26,10],[33,8,33,10],[28,8,28,10],[30,8,30,10],[31,8,31,10],[29,8,29,10],[27,8,27,10],[8,1,9,1],[20,8,20,10],[18,8,18,10],[19,8,19,10],[8,8,9,10],[48,4,53,5],[34,8,34,10],[36,8,36,10],[32,8,32,10],[44,8,44,9],[21,8,21,10],[23,8,23,10],[10,8,10,10],[14,8,14,10],[15,8,15,10],[12,8,12,10],[11,8,11,10],[16,8,16,10],[17,8,17,10],[13,8,13,10],[2,4,2,8],[4,4,4,8],[6,5,6,6],[6,7,6,8],[54,1,65535,10],[37,8,37,10],[38,8,38,10],[39,8,39,10],[40,8,40,10],[44,3,44,5]]}
[null,"Vorlage zur Dokumentation der täglichen Arbeitszeit "]
[null,null,null,null,null,null,null,null,null,null,null,"   \n"]
[null,"Firma:"]
[]
[null,"Name des Mitarbeiters:"]
[]
[null,"Pers.-Nr.:",null,null,null,"Monat/Jahr:  "]
[]
[null,"Kalen-dertag","Beginn","Pause","Ende","Dauer","*","aufgezeichnet","Bemerkungen"]
[null,null,"(Uhrzeit)","(Dauer)","(Uhrzeit)","(Summe)",null,"am:"]
[null,{"$f":"($H$7+ROW(B1)-1)*(MONTH(H7+1)=MONTH($H$7))","v":"00:00:00"},null,null,null,{"$f":"MOD(VALUE(TEXT(E11,\"00\"\":\"\"00\"))-VALUE(TEXT(D11,\"00\"\":\"\"00\"))-VALUE(TEXT(C11,\"00\"\":\"\"00\")),1)","v":"00:00:00"}]
[null,{"$f":"($H$7+ROW(B2)-1)*(MONTH(B11+1)=MONTH($H$7))","v":"1900-01-01"},null,null,null,{"$f":"MOD(VALUE(TEXT(E12,\"00\"\":\"\"00\"))-VALUE(TEXT(D12,\"00\"\":\"\"00\"))-VALUE(TEXT(C12,\"00\"\":\"\"00\")),1)","v":"00:00:00"}]
[null,{"$f":"($H$7+ROW(B3)-1)*(MONTH(B12+1)=MONTH($H$7))","v":"1900-01-02"},null,null,null,"00:00:00"]
[null,"1900-01-03",null,null,null,"00:00:00"]
[null,"1900-01-04",null,null,null,"00:00:00"]
[null,"1900-01-05",null,null,null,"00:00:00"]
[null,"1900-01-06",null,null,null,"00:00:00"]
[null,"1900-01-07",null,null,null,"00:00:00"]
[null,"1900-01-08",null,null,null,"00:00:00"]
[null,"1900-01-09",null,null,null,"00:00:00"]
[null,"1900-01-10",null,null,null,"00:00:00"]
[null,"1900-01-11",null,null,null,"00:00:00"]
[null,"1900-01-12",null,null,null,"00:00:00"]
[null,"1900-01-13",null,null,null,"00:00:00"]
[null,"1900-01-14",null,null,null,"00:00:00"]
[null,"1900-01-15",null,null,null,"00:00:00"]
[null,"1900-01-16",null,null,null,"00:00:00"]
[null,"1900-01-17",null,null,null,"00:00:00"]
[null,"1900-01-18",null,null,null,"00:00:00"]
[null,"1900-01-19",null,null,null,"00:00:00"]
[null,"1900-01-20",null,null,null,"00:00:00"]
[null,"1900-01-21",null,null,null,"00:00:00"]
[null,"1900-01-22",null,null,null,"00:00:00"]
[null,"1900-01-23",null,null,null,"00:00:00"]
[null,"1900-01-24",null,null,null,"00:00:00"]
[null,"1900-01-25",null,null,null,"00:00:00"]
[null,"1900-01-26",null,null,null,"00:00:00"]
[null,"1900-01-27",null,null,null,"00:00:00"]
[null,"1900-01-28",null,null,null,"00:00:00"]
[null,"1900-01-29",null,null,null,"00:00:00"]
[null,"1900-01-30",null,null,null,"00:00:00"]
[null,null,null,null,"Summe:",{"$f":"SUM(F11:F41)","v":0}]
[]
[]
[null,null,"Datum","Unterschrift des Arbeitnehmers",null,null,null,"Datum","Unterschrift des Arbeitgebers"]
[]
[null,"* Tragen Sie in diese Spalte eines der folgenden Kürzel ein, wenn es für diesen Kalendertag zutrifft:"]
[]
[null,null,null,null,"Schlüssel",null,"K","Krank"]
[null,null,null,null,null,null,"U ","Urlaub"]
[null,null,null,null,null,null,"UU","unbezahlter Urlaub"]
[null,null,null,null,null,null,"F","Feiertag"]
[null,null,null,null,null,null,"SA","Stundenweise abwesend"]
[null,null,null,null,null,null,"SU","Stundenweise Urlaub"]
[null,"Informationen finden Sie in der Info-Datenbank im Dok.-Nr.: 1070992 "]

{"sheet":"Hintergrund","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,11,9],[1,1,1,9],[3,1,3,9],[4,2,4,9],[6,2,6,9],[8,2,8,9],[9,2,9,9]]}
[]
["1.","Hintergrund"]
[]
[null,"Ab dem 01.01.2015 gilt flächendeckend der gesetzliche Mindeststundenlohn. Für folgende Personengruppen müssen Sie ab 01.01.2015 Beginn, Ende und Dauer der täglichen Arbeitszeit aufzeichnen und mindestens zwei Jahre lang aufbewahren:"]
[null,"n","Minijobber (Ausnahme: Privathaushalte)"]
[]
[null,"n","kurzfristig Beschäftigte gem. § 8 Abs. 1 SGB IV"]
[]
[null,"n","Arbeitnehmer in den in § 2a des Schwarzarbeitsbekämpfungsgesetzes genannten "]
[null,null,"Wirtschaftszweigen."]
[]
[null,"Diese Aufzeichnungen müssen spätestens bis zum Ablauf des siebten auf den Tag der Arbeitsleistung folgenden Kalendertags erfolgen. "]

{"sheet":"Anleitung","index":2,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,2,29,9],[30,2,30,9],[13,2,13,255],[15,4,20,5],[9,6,9,7],[8,1,8,3],[9,1,9,3],[9,4,9,5],[8,4,8,5],[1,1,1,9],[11,2,11,8],[4,2,4,9],[5,2,5,9],[6,2,6,9],[7,4,7,5],[7,1,7,3],[7,6,7,7],[8,6,8,7]]}
[]
["2.","Anleitung"]
[]
[]
[null,"1.","Vergewissern Sie sich, dass die Arbeitsmappenberechnung auf automatisch gesetzt ist. Gehen Sie dazu auf die Registerkarte Datei | Optionen | Formeln | Berechnungsoptionen | Arbeitsmappenberechnung | Automatisch"]
[null,"2.","Füllen Sie den Dokumentenkopf aus (nutzen Sie die Tabulatortaste             , um zwischen den einzelnen Zeilen/Spalten zu springen). Geben Sie im Feld Monat/Jahr den aktuellen Monat sowie das aktuelle Jahr an (MM/JJ). Daraufhin werden die zugehörigen Kalendertage in der Tabelle (linke Spalte) automatisch an den angegebenen Monat angepasst."]
[null,"3.","Geben Sie in den Spalten Beginn sowie Ende jeweils Uhrzeiten ohne Trennzeichen ein, in der Spalte Pause die Dauer der Pause in Minuten (ohne Trennzeichen)."]
[null,null,null,null,"Beginn",null,"Pause",null,"Ende"]
[null,"Sie setzen ein:",null,null,800,null,30,null,1645]
[null,"Excel wandelt automatisch um:",null,null,"08:00:00",null,":30",null,"16:45:00"]
[]
[null,null,"Mit diesen Eingaben berechnet Excel die Dauer der Arbeitszeit automatisch."]
[]
[null,"4.","In der Tabellenspalte mit dem * haben Sie die Möglichkeit, falls zutreffend, Kürzel einzutragen, um Abwesenheiten zu schlüsseln:"]
[]
[null,null,null,null,"Schlüssel",null,"K","Krank"]
[null,null,null,null,null,null,"U","Urlaub"]
[null,null,null,null,null,null,"UU","unbezahlter Urlaub"]
[null,null,null,null,null,null,"F","Feiertag"]
[null,null,null,null,null,null,"SA","Stundenweise abwesend"]
[null,null,null,null,null,null,"SU","Stundenweise Urlaub"]
[]
[null,"Kalen-dertag","Beginn (Uhrzeit)","Pause (Dauer)","Ende (Uhrzeit)","Dauer (Summe)","*","aufgezeichnet am:","Bemerkungen"]
[null,"Do, 01",null,null,null,"00:00:00","F","2015-01-02"]
[null,"Fr, 02","08:00:00",":45","16:45:00","08:00:00",null,"2015-01-03"]
[null,"Sa, 03","08:00:00",":","12:00:00","04:00:00","SA","2015-01-07","Entnahme Zeitkonto"]
[null,"So, 04",null,null,null,"00:00:00"]
[null,"Mo, 05",null,null,null,"00:00:00","K","2015-01-07"]
[]
[null,"5.","Drucken Sie die Arbeitsmappe aus, nachdem Sie vollständig und korrekt ausgefüllt wurde. Die Liste sollte sowohl vom Arbeitnehmer als auch vom Arbeitgeber unterschrieben werden."]
[null,"6.","Archivieren Sie die Listen mindestens zwei Jahre lang."]