{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Stunden_DATA","Überstunden"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":2,"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":"Stunden_DATA","index":0,"n_rows":45,"n_cols":32,"rows_kept":45,"cut":false,"hidden":false,"merged":[[4,7,4,10],[33,15,33,16],[21,15,21,16],[31,15,31,16],[30,15,30,16],[29,15,29,16],[26,15,26,16],[27,15,27,16],[24,15,24,16],[25,15,25,16],[22,15,22,16],[23,15,23,16],[0,0,0,16],[35,15,35,16],[36,15,36,16],[37,15,37,16],[6,15,6,16],[3,1,3,5],[5,5,5,6],[5,7,5,10],[3,13,3,14],[3,15,3,16],[2,15,2,16],[1,0,1,14],[17,15,17,16],[18,15,18,16],[20,15,20,16],[32,15,32,16],[39,8,39,12],[44,0,47,0],[44,1,47,16],[34,15,34,16],[7,15,7,16],[8,15,8,16],[9,15,9,16],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[16,15,16,16],[19,15,19,16],[28,15,28,16]]}
["                                                                                                      "]
["                           ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version:","rev_H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wohnort / Stützpunkt:"]
["Name des Mitarbeiters:","hier auswählen ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"*\"&B4&\"*\",AB8:AD15,3,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(B4,\"Standard\")","v":"hier auswählen "}]
[null,null,null,null,null,null,null,"Nach spätestens 6h Arbeitszeit ist eine Pause von mindestens 0,5h zu machen!",null,null,null,null,null,"Anzahl der Rufbereitschafts Tage:"]
["2024-11-01",null,null,null,null,null,null,"Pause muß mindestens 0,75Std pro Werktag betragen",null,null,null,null,null,{"$f":"N40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(A6,\"MMMMJJJ\")","v":"November2024"},{"$f":"TODAY()","v":"2024-11-20"},{"$f":"WEEKNUM(AD6-7,21)","v":46}]
["Datum","Arbeitszeit gesamt     Start","Arbeitszeit gesamt     Ende","davon Arbeitszeit für PSÖ   Beginn","davon Arbeitszeit für PSÖ  Ende","Unter-    brechung Beginn","Unter-    brechung Ende","Pause  ERS     von","Pause   ERS      bis","Pause   PSÖ    von","Pause     PSÖ       bis","Ersatz-Ruhezeit Beginn","Ersatz-Ruhezeit Ende","Ruf-bereitschaft ERS","Einsatz außerhalb der Rufbereitschaft Sonderzahlung ","Postleitzahl(en) und Ort(e) und bei PSÖ die Baustelle eintragen",null,"Stunden Anzahl gesamt","Stunden Anzahl  ERS","Stunden Anzahl  PSÖ","WE-Dienst","Ü-Stunden SA","Ü-Stunden SO","KW","Summe Unterbrechung"]
[{"$f":"A6","v":"2024-11-01"},0.33333333333333331,0.91666666666666663,null,null,0.69791666666666663,0.875,null,null,null,null,null,null,null,{"$f":"IF(AA8,\"€ 50,-\",0)","v":0},null,null,{"$f":"S8+T8","v":9.7499999999999964},{"$f":"MOD((C8-B8)-(I8-H8)-(G8-F8)-(E8-D8),1)*24","v":9.7499999999999964},{"$f":"MOD((E8-D8)-(K8-J8),1)*24","v":0},null,null,null,{"$f":"WEEKNUM(A8,21)","v":44},{"$f":"(G8-F8)*24","v":4.2500000000000009},null,false,"hier auswählen ",0,0,null,false]
[{"$f":"A8+1","v":"2024-11-02"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA9,\"€ 50,-\",0)","v":0},null,null,{"$f":"S9+T9","v":0},{"$f":"MOD((C9-B9)-(I9-H9)-(G9-F9)-(E9-D9),1)*24","v":0},{"$f":"MOD((E9-D9)-(K9-J9),1)*24","v":0},null,null,null,{"$f":"WEEKNUM(A9,21)","v":44},0,null,false,null,240028,null,null,false]
["2024-11-03",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,44,0,null,false,null,240036,null,null,false]
["2024-11-04",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,45,0,null,false,null,240030,null,null,false]
["2024-11-05",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,45,0,null,false,null,240038,null,null,false]
["2024-11-06",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,45,0,null,false,null,240043,null,null,false]
["2024-11-07",null,null,null,null,null,null,null,null,null,null,null,null,null,0," ",null,0,0,0,null,null,null,45,0,null,false,null,71042,null,null,false]
["2024-11-08",null,null,null,null,null,null,null,null,null,null,null,null," ",0,null,null,0,0,0,null,null,null,45,0,null,false,null,240042,null,null,false]
["2024-11-09",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,45,0,null,false,null,null,null,null,false]
[{"$f":"A16+1","v":"2024-11-10"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,45,0,null,false,null,null,null,null,false]
["2024-11-11",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA18,\"€ 50,-\",0)","v":0},null,null,{"$f":"S18+T18","v":0},{"$f":"MOD((C18-B18)-(I18-H18)-(G18-F18)-(E18-D18),1)*24","v":0},{"$f":"MOD((E18-D18)-(K18-J18),1)*24","v":0},null,null,null,46,{"$f":"(G18-F18)*24","v":0},null,false,null,null,null,null,false]
["2024-11-12",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA19,\"€ 50,-\",0)","v":0},null,null,{"$f":"S19+T19","v":0},{"$f":"MOD((C19-B19)-(I19-H19)-(G19-F19)-(E19-D19),1)*24","v":0},{"$f":"MOD((E19-D19)-(K19-J19),1)*24","v":0},null,null,null,46,{"$f":"(G19-F19)*24","v":0},null,false,null,null,null,null,false]
["2024-11-13",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,46,0,null,false,null,null,null,null,false]
["2024-11-14",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA21,\"€ 50,-\",0)","v":0},null,null,{"$f":"S21+T21","v":0},{"$f":"MOD((C21-B21)-(I21-H21)-(G21-F21)-(E21-D21),1)*24","v":0},{"$f":"MOD((E21-D21)-(K21-J21),1)*24","v":0},null,null,null,46,{"$f":"(G21-F21)*24","v":0},null,false,null,null,null,null,false]
["2024-11-15",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA22,\"€ 50,-\",0)","v":0},null,null,{"$f":"S22+T22","v":0},{"$f":"MOD((C22-B22)-(I22-H22)-(G22-F22)-(E22-D22),1)*24","v":0},{"$f":"MOD((E22-D22)-(K22-J22),1)*24","v":0},null,null,null,46,{"$f":"(G22-F22)*24","v":0},null,false,null,null,null,null,false]
["2024-11-16",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA23,\"€ 50,-\",0)","v":0},null,null,{"$f":"S23+T23","v":0},{"$f":"MOD((C23-B23)-(I23-H23)-(G23-F23)-(E23-D23),1)*24","v":0},{"$f":"MOD((E23-D23)-(K23-J23),1)*24","v":0},null,null,null,46,{"$f":"(G23-F23)*24","v":0},null,false,null,null,null,null,false]
["2024-11-17",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA24,\"€ 50,-\",0)","v":0},null,null,{"$f":"S24+T24","v":0},{"$f":"MOD((C24-B24)-(I24-H24)-(G24-F24)-(E24-D24),1)*24","v":0},{"$f":"MOD((E24-D24)-(K24-J24),1)*24","v":0},null,null,null,46,{"$f":"(G24-F24)*24","v":0},null,false,null,null,null,null,false]
["2024-11-18",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA25,\"€ 50,-\",0)","v":0},null,null,{"$f":"S25+T25","v":0},{"$f":"MOD((C25-B25)-(I25-H25)-(G25-F25)-(E25-D25),1)*24","v":0},{"$f":"MOD((E25-D25)-(K25-J25),1)*24","v":0},null,null,null,47,{"$f":"(G25-F25)*24","v":0},null,false,null,null,null,null,false]
["2024-11-19",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA26,\"€ 50,-\",0)","v":0},null,null,{"$f":"S26+T26","v":0},{"$f":"MOD((C26-B26)-(I26-H26)-(G26-F26)-(E26-D26),1)*24","v":0},{"$f":"MOD((E26-D26)-(K26-J26),1)*24","v":0},null,null,null,47,{"$f":"(G26-F26)*24","v":0},null,false,null,null,null,null,false]
["2024-11-20",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA27,\"€ 50,-\",0)","v":0},null,null,{"$f":"S27+T27","v":0},{"$f":"MOD((C27-B27)-(I27-H27)-(G27-F27)-(E27-D27),1)*24","v":0},{"$f":"MOD((E27-D27)-(K27-J27),1)*24","v":0},null,null,null,47,{"$f":"(G27-F27)*24","v":0},null,false,null,null,null,null,false]
["2024-11-21",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA28,\"€ 50,-\",0)","v":0},null,null,{"$f":"S28+T28","v":0},{"$f":"MOD((C28-B28)-(I28-H28)-(G28-F28)-(E28-D28),1)*24","v":0},{"$f":"MOD((E28-D28)-(K28-J28),1)*24","v":0},null,null,null,47,{"$f":"(G28-F28)*24","v":0},null,false,null,null,null,null,false]
["2024-11-22",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA29,\"€ 50,-\",0)","v":0},null,null,{"$f":"S29+T29","v":0},{"$f":"MOD((C29-B29)-(I29-H29)-(G29-F29)-(E29-D29),1)*24","v":0},{"$f":"MOD((E29-D29)-(K29-J29),1)*24","v":0},null,null,null,47,{"$f":"(G29-F29)*24","v":0},null,false,null,null,null,null,false]
["2024-11-23",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA30,\"€ 50,-\",0)","v":0},null,null,{"$f":"S30+T30","v":0},{"$f":"MOD((C30-B30)-(I30-H30)-(G30-F30)-(E30-D30),1)*24","v":0},{"$f":"MOD((E30-D30)-(K30-J30),1)*24","v":0},null,null,null,47,{"$f":"(G30-F30)*24","v":0},null,false,null,null,null,null,false]
["2024-11-24",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA31,\"€ 50,-\",0)","v":0},null,null,{"$f":"S31+T31","v":0},{"$f":"MOD((C31-B31)-(I31-H31)-(G31-F31)-(E31-D31),1)*24","v":0},{"$f":"MOD((E31-D31)-(K31-J31),1)*24","v":0},null,null,null,47,{"$f":"(G31-F31)*24","v":0},null,false,null,null,null,null,false]
["2024-11-25",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA32,\"€ 50,-\",0)","v":0},null,null,{"$f":"S32+T32","v":0},{"$f":"MOD((C32-B32)-(I32-H32)-(G32-F32)-(E32-D32),1)*24","v":0},{"$f":"MOD((E32-D32)-(K32-J32),1)*24","v":0},null,null,null,48,{"$f":"(G32-F32)*24","v":0},null,false,null,null,null,null,false]
["2024-11-26",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA33,\"€ 50,-\",0)","v":0},null,null,{"$f":"S33+T33","v":0},{"$f":"MOD((C33-B33)-(I33-H33)-(G33-F33)-(E33-D33),1)*24","v":0},{"$f":"MOD((E33-D33)-(K33-J33),1)*24","v":0},null,null,null,48,{"$f":"(G33-F33)*24","v":0},null,false,null,null,null,null,false]
["2024-11-27",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA34,\"€ 50,-\",0)","v":0},null,null,{"$f":"S34+T34","v":0},{"$f":"MOD((C34-B34)-(I34-H34)-(G34-F34)-(E34-D34),1)*24","v":0},{"$f":"MOD((E34-D34)-(K34-J34),1)*24","v":0},null,null,null,48,{"$f":"(G34-F34)*24","v":0},null,false,null,null,null,null,false]
["2024-11-28",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,48,0,null,false,null,null,null,null,false]
["2024-11-29",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,48,0,null,false,null,null,null,null,false]
["2024-11-30",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,48,0,null,false,null,null,null,null,false]
[{"$f":"A37+1","v":"2024-12-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,null,null,null,48,0,null,false,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gesamt:",{"$f":"SUM(R8:R38)","v":9.7499999999999964},{"$f":"SUM(S8:S38)","v":9.7499999999999964},{"$f":"SUM(T8:T38)","v":0}]
[null,null,null,null,null,null,null,null,"Anzahl der Rufbereitschaftstage:",null,null,null,null,{"$f":"COUNTIF(AF8:AF38,TRUE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Gesamt","% ERS","% PSÖ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(R39/1.76)","v":5.5397727272727249},{"$f":"(S39/1.76)","v":5.5397727272727249},{"$f":"(T39/1.76)","v":0}]
[]
[]
["Bemerkungen:"]

{"sheet":"Überstunden","index":1,"n_rows":39,"n_cols":243,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,1,38,2],[3,227,3,232],[3,235,3,240],[3,243,3,248],[5,4,5,5],[3,179,3,184],[3,187,3,192],[3,195,3,200],[3,203,3,208],[3,211,3,216],[3,219,3,224],[3,131,3,136],[3,139,3,144],[3,147,3,152],[3,155,3,160],[3,163,3,168],[3,171,3,176],[3,123,3,128],[3,35,3,40],[3,43,3,48],[3,51,3,56],[3,59,3,64],[3,67,3,72],[3,75,3,80],[3,83,3,88],[3,91,3,96],[3,99,3,104],[3,107,3,112],[3,115,3,120],[3,27,3,32],[0,0,0,5],[3,1,3,3],[3,19,3,24],[1,0,1,3]]}
["                                "]
["Erfassung der Überstunden",null,null,null,{"$f":"Stunden_DATA!P2","v":"Version:"},{"$f":"Stunden_DATA!Q2","v":"rev_H"},null,null,"Hilfsspalte Grenzen",null,"Hilfsspalte SA 50",null,null,null,{"$f":"Stunden_DATA!Z2","v":0}]
[null,null,null,null,null,null,null,null,"(Fixwerte)",null,"(Berechnete Grenzwerte)"]
["Name des Mitarbeiters:",{"$f":"Stunden_DATA!B4","v":"hier auswählen "},null,null,null,null,null,null,"06:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:",null,null,null,null,null,null,null,"Name des Mitarbeiters:"]
[]
[{"$f":"Stunden_DATA!A6","v":"2024-11-01"},null,null,null,null,null,null,null,"08:00:00"]
["Datum","Arbeits- beginn","Arbeits-     ende","Zuschlag   50%","Zuschlag 100%","Überstunden gesamt",null,null,null,null,"Anfang","Ende",null,null,"KW"]
[{"$f":"A6","v":"2024-11-01"},{"$f":"IF(Stunden_DATA!B8=\"\",\"\",Stunden_DATA!B8)","v":0.33333333333333331},{"$f":"IF(Stunden_DATA!C8=\"\",\"\",Stunden_DATA!C8)","v":0.91666666666666663},{"$f":"IF(Stunden_DATA!V8>0,IF((L8-K8)*24<6.1,(L8-K8)*24,(L8-K8)*24-0.5-Stunden_DATA!Y8),IF(Stunden_DATA!W8>0,\"\",IF(OR(B8=\"\",C8=\"\"),\"\",(IF(B8<I$4,2,(I$6-B8)*24)+IF(C8>I$10,3.25-Stunden_DATA!Y8,(C8-I$8)*24-Stunden_DATA!Y8)))))","v":-1.0000000000000009},{"$f":"IF(Stunden_DATA!V8>0,IF(AND((C8-B8)*24>6.1),(C8-B8)*24-D8-0.5,(C8-B8)*24-D8-Stunden_DATA!Y8)-Stunden_DATA!Y8,IF(OR(B8=\"\",C8=\"\"),\"\",IF(Stunden_DATA!W8>0,(C8-B8)*24-Stunden_DATA!Y8,(C8-B8)*24-D8-(8.75+Stunden_DATA!Y8))))","v":2},{"$f":"IF(SUM(D8:E8)=0,\"\",SUM(D8:E8))","v":0.99999999999999911},null,null,"16:45:00",null,{"$f":"IF(B8<I$4,I$4,B8)","v":"08:00:00"},{"$f":"IF(C8>I$10,I$10,C8)","v":"20:00:00"},null,null,{"$f":"WEEKNUM(A8,21)","v":44}]
[{"$f":"A8+1","v":"2024-11-02"},{"$f":"IF(Stunden_DATA!B9=\"\",\"\",Stunden_DATA!B9)","v":""},{"$f":"IF(Stunden_DATA!C9=\"\",\"\",Stunden_DATA!C9)","v":""},{"$f":"IF(Stunden_DATA!V9>0,IF((L9-K9)*24<6.1,(L9-K9)*24,(L9-K9)*24-0.5-Stunden_DATA!Y9),IF(Stunden_DATA!W9>0,\"\",IF(OR(B9=\"\",C9=\"\"),\"\",(IF(B9<I$4,2,(I$6-B9)*24)+IF(C9>I$10,3.25-Stunden_DATA!Y9,(C9-I$8)*24-Stunden_DATA!Y9)))))","v":""},{"$f":"IF(Stunden_DATA!V9>0,IF(AND((C9-B9)*24>6.1),(C9-B9)*24-D9-0.5,(C9-B9)*24-D9-Stunden_DATA!Y9)-Stunden_DATA!Y9,IF(OR(B9=\"\",C9=\"\"),\"\",IF(Stunden_DATA!W9>0,(C9-B9)*24-Stunden_DATA!Y9,(C9-B9)*24-D9-(8.75+Stunden_DATA!Y9))))","v":""},"",null,null,null,null,"","20:00:00",null,null,{"$f":"WEEKNUM(A9,21)","v":44}]
["2024-11-03",{"$f":"IF(Stunden_DATA!B10=\"\",\"\",Stunden_DATA!B10)","v":""},{"$f":"IF(Stunden_DATA!C10=\"\",\"\",Stunden_DATA!C10)","v":""},{"$f":"IF(Stunden_DATA!V10>0,IF((L10-K10)*24<6.1,(L10-K10)*24,(L10-K10)*24-0.5-Stunden_DATA!Y10),IF(Stunden_DATA!W10>0,\"\",IF(OR(B10=\"\",C10=\"\"),\"\",(IF(B10<I$4,2,(I$6-B10)*24)+IF(C10>I$10,3.25-Stunden_DATA!Y10,(C10-I$8)*24-Stunden_DATA!Y10)))))","v":""},{"$f":"IF(Stunden_DATA!V10>0,IF(AND((C10-B10)*24>6.1),(C10-B10)*24-D10-0.5,(C10-B10)*24-D10-Stunden_DATA!Y10)-Stunden_DATA!Y10,IF(OR(B10=\"\",C10=\"\"),\"\",IF(Stunden_DATA!W10>0,(C10-B10)*24-Stunden_DATA!Y10,(C10-B10)*24-D10-(8.75+Stunden_DATA!Y10))))","v":""},"",null,null,"20:00:00",null,"","20:00:00",null,null,44]
["2024-11-04",{"$f":"IF(Stunden_DATA!B11=\"\",\"\",Stunden_DATA!B11)","v":""},{"$f":"IF(Stunden_DATA!C11=\"\",\"\",Stunden_DATA!C11)","v":""},{"$f":"IF(Stunden_DATA!V11>0,IF((L11-K11)*24<6.1,(L11-K11)*24,(L11-K11)*24-0.5-Stunden_DATA!Y11),IF(Stunden_DATA!W11>0,\"\",IF(OR(B11=\"\",C11=\"\"),\"\",(IF(B11<I$4,2,(I$6-B11)*24)+IF(C11>I$10,3.25-Stunden_DATA!Y11,(C11-I$8)*24-Stunden_DATA!Y11)))))","v":""},{"$f":"IF(Stunden_DATA!V11>0,IF(AND((C11-B11)*24>6.1),(C11-B11)*24-D11-0.5,(C11-B11)*24-D11-Stunden_DATA!Y11)-Stunden_DATA!Y11,IF(OR(B11=\"\",C11=\"\"),\"\",IF(Stunden_DATA!W11>0,(C11-B11)*24-Stunden_DATA!Y11,(C11-B11)*24-D11-(8.75+Stunden_DATA!Y11))))","v":""},"",null,null,null,null,"","20:00:00",null,null,45]
["2024-11-05",{"$f":"IF(Stunden_DATA!B12=\"\",\"\",Stunden_DATA!B12)","v":""},{"$f":"IF(Stunden_DATA!C12=\"\",\"\",Stunden_DATA!C12)","v":""},{"$f":"IF(Stunden_DATA!V12>0,IF((L12-K12)*24<6.1,(L12-K12)*24,(L12-K12)*24-0.5-Stunden_DATA!Y12),IF(Stunden_DATA!W12>0,\"\",IF(OR(B12=\"\",C12=\"\"),\"\",(IF(B12<I$4,2,(I$6-B12)*24)+IF(C12>I$10,3.25-Stunden_DATA!Y12,(C12-I$8)*24-Stunden_DATA!Y12)))))","v":""},{"$f":"IF(Stunden_DATA!V12>0,IF(AND((C12-B12)*24>6.1),(C12-B12)*24-D12-0.5,(C12-B12)*24-D12-Stunden_DATA!Y12)-Stunden_DATA!Y12,IF(OR(B12=\"\",C12=\"\"),\"\",IF(Stunden_DATA!W12>0,(C12-B12)*24-Stunden_DATA!Y12,(C12-B12)*24-D12-(8.75+Stunden_DATA!Y12))))","v":""},"",null,null,null,null,"","20:00:00",null,null,45]
["2024-11-06",{"$f":"IF(Stunden_DATA!B13=\"\",\"\",Stunden_DATA!B13)","v":""},{"$f":"IF(Stunden_DATA!C13=\"\",\"\",Stunden_DATA!C13)","v":""},{"$f":"IF(Stunden_DATA!V13>0,IF((L13-K13)*24<6.1,(L13-K13)*24,(L13-K13)*24-0.5-Stunden_DATA!Y13),IF(Stunden_DATA!W13>0,\"\",IF(OR(B13=\"\",C13=\"\"),\"\",(IF(B13<I$4,2,(I$6-B13)*24)+IF(C13>I$10,3.25-Stunden_DATA!Y13,(C13-I$8)*24-Stunden_DATA!Y13)))))","v":""},{"$f":"IF(Stunden_DATA!V13>0,IF(AND((C13-B13)*24>6.1),(C13-B13)*24-D13-0.5,(C13-B13)*24-D13-Stunden_DATA!Y13)-Stunden_DATA!Y13,IF(OR(B13=\"\",C13=\"\"),\"\",IF(Stunden_DATA!W13>0,(C13-B13)*24-Stunden_DATA!Y13,(C13-B13)*24-D13-(8.75+Stunden_DATA!Y13))))","v":""},"",null,null,null,null,"","20:00:00",null,null,45]
["2024-11-07",{"$f":"IF(Stunden_DATA!B14=\"\",\"\",Stunden_DATA!B14)","v":""},{"$f":"IF(Stunden_DATA!C14=\"\",\"\",Stunden_DATA!C14)","v":""},{"$f":"IF(Stunden_DATA!V14>0,IF((L14-K14)*24<6.1,(L14-K14)*24,(L14-K14)*24-0.5-Stunden_DATA!Y14),IF(Stunden_DATA!W14>0,\"\",IF(OR(B14=\"\",C14=\"\"),\"\",(IF(B14<I$4,2,(I$6-B14)*24)+IF(C14>I$10,3.25-Stunden_DATA!Y14,(C14-I$8)*24-Stunden_DATA!Y14)))))","v":""},{"$f":"IF(Stunden_DATA!V14>0,IF(AND((C14-B14)*24>6.1),(C14-B14)*24-D14-0.5,(C14-B14)*24-D14-Stunden_DATA!Y14)-Stunden_DATA!Y14,IF(OR(B14=\"\",C14=\"\"),\"\",IF(Stunden_DATA!W14>0,(C14-B14)*24-Stunden_DATA!Y14,(C14-B14)*24-D14-(8.75+Stunden_DATA!Y14))))","v":""},"",null,null,null,null,"","20:00:00",null,null,45]
["2024-11-08",{"$f":"IF(Stunden_DATA!B15=\"\",\"\",Stunden_DATA!B15)","v":""},{"$f":"IF(Stunden_DATA!C15=\"\",\"\",Stunden_DATA!C15)","v":""},{"$f":"IF(Stunden_DATA!V15>0,IF((L15-K15)*24<6.1,(L15-K15)*24,(L15-K15)*24-0.5-Stunden_DATA!Y15),IF(Stunden_DATA!W15>0,\"\",IF(OR(B15=\"\",C15=\"\"),\"\",(IF(B15<I$4,2,(I$6-B15)*24)+IF(C15>I$10,3.25-Stunden_DATA!Y15,(C15-I$8)*24-Stunden_DATA!Y15)))))","v":""},{"$f":"IF(Stunden_DATA!V15>0,IF(AND((C15-B15)*24>6.1),(C15-B15)*24-D15-0.5,(C15-B15)*24-D15-Stunden_DATA!Y15)-Stunden_DATA!Y15,IF(OR(B15=\"\",C15=\"\"),\"\",IF(Stunden_DATA!W15>0,(C15-B15)*24-Stunden_DATA!Y15,(C15-B15)*24-D15-(8.75+Stunden_DATA!Y15))))","v":""},"",null,null,null,null,"","20:00:00",null,null,45]
["2024-11-09",{"$f":"IF(Stunden_DATA!B16=\"\",\"\",Stunden_DATA!B16)","v":""},{"$f":"IF(Stunden_DATA!C16=\"\",\"\",Stunden_DATA!C16)","v":""},{"$f":"IF(Stunden_DATA!V16>0,IF((L16-K16)*24<6.1,(L16-K16)*24,(L16-K16)*24-0.5-Stunden_DATA!Y16),IF(Stunden_DATA!W16>0,\"\",IF(OR(B16=\"\",C16=\"\"),\"\",(IF(B16<I$4,2,(I$6-B16)*24)+IF(C16>I$10,3.25-Stunden_DATA!Y16,(C16-I$8)*24-Stunden_DATA!Y16)))))","v":""},{"$f":"IF(Stunden_DATA!V16>0,IF(AND((C16-B16)*24>6.1),(C16-B16)*24-D16-0.5,(C16-B16)*24-D16-Stunden_DATA!Y16)-Stunden_DATA!Y16,IF(OR(B16=\"\",C16=\"\"),\"\",IF(Stunden_DATA!W16>0,(C16-B16)*24-Stunden_DATA!Y16,(C16-B16)*24-D16-(8.75+Stunden_DATA!Y16))))","v":""},"",null,null,null,null,"","20:00:00",null,null,45]
["2024-11-10",{"$f":"IF(Stunden_DATA!B17=\"\",\"\",Stunden_DATA!B17)","v":""},{"$f":"IF(Stunden_DATA!C17=\"\",\"\",Stunden_DATA!C17)","v":""},{"$f":"IF(Stunden_DATA!V17>0,IF((L17-K17)*24<6.1,(L17-K17)*24,(L17-K17)*24-0.5-Stunden_DATA!Y17),IF(Stunden_DATA!W17>0,\"\",IF(OR(B17=\"\",C17=\"\"),\"\",(IF(B17<I$4,2,(I$6-B17)*24)+IF(C17>I$10,3.25-Stunden_DATA!Y17,(C17-I$8)*24-Stunden_DATA!Y17)))))","v":""},{"$f":"IF(Stunden_DATA!V17>0,IF(AND((C17-B17)*24>6.1),(C17-B17)*24-D17-0.5,(C17-B17)*24-D17-Stunden_DATA!Y17)-Stunden_DATA!Y17,IF(OR(B17=\"\",C17=\"\"),\"\",IF(Stunden_DATA!W17>0,(C17-B17)*24-Stunden_DATA!Y17,(C17-B17)*24-D17-(8.75+Stunden_DATA!Y17))))","v":""},"",null,null,null,null,"","20:00:00",null,null,45]
["2024-11-11",{"$f":"IF(Stunden_DATA!B18=\"\",\"\",Stunden_DATA!B18)","v":""},{"$f":"IF(Stunden_DATA!C18=\"\",\"\",Stunden_DATA!C18)","v":""},{"$f":"IF(Stunden_DATA!V18>0,IF((L18-K18)*24<6.1,(L18-K18)*24,(L18-K18)*24-0.5-Stunden_DATA!Y18),IF(Stunden_DATA!W18>0,\"\",IF(OR(B18=\"\",C18=\"\"),\"\",(IF(B18<I$4,2,(I$6-B18)*24)+IF(C18>I$10,3.25-Stunden_DATA!Y18,(C18-I$8)*24-Stunden_DATA!Y18)))))","v":""},{"$f":"IF(Stunden_DATA!V18>0,IF(AND((C18-B18)*24>6.1),(C18-B18)*24-D18-0.5,(C18-B18)*24-D18-Stunden_DATA!Y18)-Stunden_DATA!Y18,IF(OR(B18=\"\",C18=\"\"),\"\",IF(Stunden_DATA!W18>0,(C18-B18)*24-Stunden_DATA!Y18,(C18-B18)*24-D18-(8.75+Stunden_DATA!Y18))))","v":""},"",null,null,null,null,"","20:00:00",null,null,46]
["2024-11-12",{"$f":"IF(Stunden_DATA!B19=\"\",\"\",Stunden_DATA!B19)","v":""},{"$f":"IF(Stunden_DATA!C19=\"\",\"\",Stunden_DATA!C19)","v":""},{"$f":"IF(Stunden_DATA!V19>0,IF((L19-K19)*24<6.1,(L19-K19)*24,(L19-K19)*24-0.5-Stunden_DATA!Y19),IF(Stunden_DATA!W19>0,\"\",IF(OR(B19=\"\",C19=\"\"),\"\",(IF(B19<I$4,2,(I$6-B19)*24)+IF(C19>I$10,3.25-Stunden_DATA!Y19,(C19-I$8)*24-Stunden_DATA!Y19)))))","v":""},{"$f":"IF(Stunden_DATA!V19>0,IF(AND((C19-B19)*24>6.1),(C19-B19)*24-D19-0.5,(C19-B19)*24-D19-Stunden_DATA!Y19)-Stunden_DATA!Y19,IF(OR(B19=\"\",C19=\"\"),\"\",IF(Stunden_DATA!W19>0,(C19-B19)*24-Stunden_DATA!Y19,(C19-B19)*24-D19-(8.75+Stunden_DATA!Y19))))","v":""},"",null,null,null,null,"","20:00:00",null,null,46]
["2024-11-13",{"$f":"IF(Stunden_DATA!B20=\"\",\"\",Stunden_DATA!B20)","v":""},{"$f":"IF(Stunden_DATA!C20=\"\",\"\",Stunden_DATA!C20)","v":""},{"$f":"IF(Stunden_DATA!V20>0,IF((L20-K20)*24<6.1,(L20-K20)*24,(L20-K20)*24-0.5-Stunden_DATA!Y20),IF(Stunden_DATA!W20>0,\"\",IF(OR(B20=\"\",C20=\"\"),\"\",(IF(B20<I$4,2,(I$6-B20)*24)+IF(C20>I$10,3.25-Stunden_DATA!Y20,(C20-I$8)*24-Stunden_DATA!Y20)))))","v":""},{"$f":"IF(Stunden_DATA!V20>0,IF(AND((C20-B20)*24>6.1),(C20-B20)*24-D20-0.5,(C20-B20)*24-D20-Stunden_DATA!Y20)-Stunden_DATA!Y20,IF(OR(B20=\"\",C20=\"\"),\"\",IF(Stunden_DATA!W20>0,(C20-B20)*24-Stunden_DATA!Y20,(C20-B20)*24-D20-(8.75+Stunden_DATA!Y20))))","v":""},"",null,null,null,null,"","20:00:00",null,null,46]
["2024-11-14",{"$f":"IF(Stunden_DATA!B21=\"\",\"\",Stunden_DATA!B21)","v":""},{"$f":"IF(Stunden_DATA!C21=\"\",\"\",Stunden_DATA!C21)","v":""},{"$f":"IF(Stunden_DATA!V21>0,IF((L21-K21)*24<6.1,(L21-K21)*24,(L21-K21)*24-0.5-Stunden_DATA!Y21),IF(Stunden_DATA!W21>0,\"\",IF(OR(B21=\"\",C21=\"\"),\"\",(IF(B21<I$4,2,(I$6-B21)*24)+IF(C21>I$10,3.25-Stunden_DATA!Y21,(C21-I$8)*24-Stunden_DATA!Y21)))))","v":""},{"$f":"IF(Stunden_DATA!V21>0,IF(AND((C21-B21)*24>6.1),(C21-B21)*24-D21-0.5,(C21-B21)*24-D21-Stunden_DATA!Y21)-Stunden_DATA!Y21,IF(OR(B21=\"\",C21=\"\"),\"\",IF(Stunden_DATA!W21>0,(C21-B21)*24-Stunden_DATA!Y21,(C21-B21)*24-D21-(8.75+Stunden_DATA!Y21))))","v":""},"",null,null,null,null,"","20:00:00",null,null,46]
["2024-11-15",{"$f":"IF(Stunden_DATA!B22=\"\",\"\",Stunden_DATA!B22)","v":""},{"$f":"IF(Stunden_DATA!C22=\"\",\"\",Stunden_DATA!C22)","v":""},{"$f":"IF(Stunden_DATA!V22>0,IF((L22-K22)*24<6.1,(L22-K22)*24,(L22-K22)*24-0.5-Stunden_DATA!Y22),IF(Stunden_DATA!W22>0,\"\",IF(OR(B22=\"\",C22=\"\"),\"\",(IF(B22<I$4,2,(I$6-B22)*24)+IF(C22>I$10,3.25-Stunden_DATA!Y22,(C22-I$8)*24-Stunden_DATA!Y22)))))","v":""},{"$f":"IF(Stunden_DATA!V22>0,IF(AND((C22-B22)*24>6.1),(C22-B22)*24-D22-0.5,(C22-B22)*24-D22-Stunden_DATA!Y22)-Stunden_DATA!Y22,IF(OR(B22=\"\",C22=\"\"),\"\",IF(Stunden_DATA!W22>0,(C22-B22)*24-Stunden_DATA!Y22,(C22-B22)*24-D22-(8.75+Stunden_DATA!Y22))))","v":""},"",null,null,null,null,"","20:00:00",null,null,46]
["2024-11-16",{"$f":"IF(Stunden_DATA!B23=\"\",\"\",Stunden_DATA!B23)","v":""},{"$f":"IF(Stunden_DATA!C23=\"\",\"\",Stunden_DATA!C23)","v":""},{"$f":"IF(Stunden_DATA!V23>0,IF((L23-K23)*24<6.1,(L23-K23)*24,(L23-K23)*24-0.5-Stunden_DATA!Y23),IF(Stunden_DATA!W23>0,\"\",IF(OR(B23=\"\",C23=\"\"),\"\",(IF(B23<I$4,2,(I$6-B23)*24)+IF(C23>I$10,3.25-Stunden_DATA!Y23,(C23-I$8)*24-Stunden_DATA!Y23)))))","v":""},{"$f":"IF(Stunden_DATA!V23>0,IF(AND((C23-B23)*24>6.1),(C23-B23)*24-D23-0.5,(C23-B23)*24-D23-Stunden_DATA!Y23)-Stunden_DATA!Y23,IF(OR(B23=\"\",C23=\"\"),\"\",IF(Stunden_DATA!W23>0,(C23-B23)*24-Stunden_DATA!Y23,(C23-B23)*24-D23-(8.75+Stunden_DATA!Y23))))","v":""},"",null,null,null,null,"","20:00:00",null,null,46]
["2024-11-17",{"$f":"IF(Stunden_DATA!B24=\"\",\"\",Stunden_DATA!B24)","v":""},{"$f":"IF(Stunden_DATA!C24=\"\",\"\",Stunden_DATA!C24)","v":""},{"$f":"IF(Stunden_DATA!V24>0,IF((L24-K24)*24<6.1,(L24-K24)*24,(L24-K24)*24-0.5-Stunden_DATA!Y24),IF(Stunden_DATA!W24>0,\"\",IF(OR(B24=\"\",C24=\"\"),\"\",(IF(B24<I$4,2,(I$6-B24)*24)+IF(C24>I$10,3.25-Stunden_DATA!Y24,(C24-I$8)*24-Stunden_DATA!Y24)))))","v":""},{"$f":"IF(Stunden_DATA!V24>0,IF(AND((C24-B24)*24>6.1),(C24-B24)*24-D24-0.5,(C24-B24)*24-D24-Stunden_DATA!Y24)-Stunden_DATA!Y24,IF(OR(B24=\"\",C24=\"\"),\"\",IF(Stunden_DATA!W24>0,(C24-B24)*24-Stunden_DATA!Y24,(C24-B24)*24-D24-(8.75+Stunden_DATA!Y24))))","v":""},"",null,null,null,null,"","20:00:00",null,null,46]
["2024-11-18",{"$f":"IF(Stunden_DATA!B25=\"\",\"\",Stunden_DATA!B25)","v":""},{"$f":"IF(Stunden_DATA!C25=\"\",\"\",Stunden_DATA!C25)","v":""},{"$f":"IF(Stunden_DATA!V25>0,IF((L25-K25)*24<6.1,(L25-K25)*24,(L25-K25)*24-0.5-Stunden_DATA!Y25),IF(Stunden_DATA!W25>0,\"\",IF(OR(B25=\"\",C25=\"\"),\"\",(IF(B25<I$4,2,(I$6-B25)*24)+IF(C25>I$10,3.25-Stunden_DATA!Y25,(C25-I$8)*24-Stunden_DATA!Y25)))))","v":""},{"$f":"IF(Stunden_DATA!V25>0,IF(AND((C25-B25)*24>6.1),(C25-B25)*24-D25-0.5,(C25-B25)*24-D25-Stunden_DATA!Y25)-Stunden_DATA!Y25,IF(OR(B25=\"\",C25=\"\"),\"\",IF(Stunden_DATA!W25>0,(C25-B25)*24-Stunden_DATA!Y25,(C25-B25)*24-D25-(8.75+Stunden_DATA!Y25))))","v":""},"",null,null,null,null,"","20:00:00",null,null,47]
["2024-11-19",{"$f":"IF(Stunden_DATA!B26=\"\",\"\",Stunden_DATA!B26)","v":""},{"$f":"IF(Stunden_DATA!C26=\"\",\"\",Stunden_DATA!C26)","v":""},{"$f":"IF(Stunden_DATA!V26>0,IF((L26-K26)*24<6.1,(L26-K26)*24,(L26-K26)*24-0.5-Stunden_DATA!Y26),IF(Stunden_DATA!W26>0,\"\",IF(OR(B26=\"\",C26=\"\"),\"\",(IF(B26<I$4,2,(I$6-B26)*24)+IF(C26>I$10,3.25-Stunden_DATA!Y26,(C26-I$8)*24-Stunden_DATA!Y26)))))","v":""},{"$f":"IF(Stunden_DATA!V26>0,IF(AND((C26-B26)*24>6.1),(C26-B26)*24-D26-0.5,(C26-B26)*24-D26-Stunden_DATA!Y26)-Stunden_DATA!Y26,IF(OR(B26=\"\",C26=\"\"),\"\",IF(Stunden_DATA!W26>0,(C26-B26)*24-Stunden_DATA!Y26,(C26-B26)*24-D26-(8.75+Stunden_DATA!Y26))))","v":""},"",null,null,null,null,"","20:00:00",null,null,47]
["2024-11-20",{"$f":"IF(Stunden_DATA!B27=\"\",\"\",Stunden_DATA!B27)","v":""},{"$f":"IF(Stunden_DATA!C27=\"\",\"\",Stunden_DATA!C27)","v":""},{"$f":"IF(Stunden_DATA!V27>0,IF((L27-K27)*24<6.1,(L27-K27)*24,(L27-K27)*24-0.5-Stunden_DATA!Y27),IF(Stunden_DATA!W27>0,\"\",IF(OR(B27=\"\",C27=\"\"),\"\",(IF(B27<I$4,2,(I$6-B27)*24)+IF(C27>I$10,3.25-Stunden_DATA!Y27,(C27-I$8)*24-Stunden_DATA!Y27)))))","v":""},{"$f":"IF(Stunden_DATA!V27>0,IF(AND((C27-B27)*24>6.1),(C27-B27)*24-D27-0.5,(C27-B27)*24-D27-Stunden_DATA!Y27)-Stunden_DATA!Y27,IF(OR(B27=\"\",C27=\"\"),\"\",IF(Stunden_DATA!W27>0,(C27-B27)*24-Stunden_DATA!Y27,(C27-B27)*24-D27-(8.75+Stunden_DATA!Y27))))","v":""},"",null,null,null,null,"","20:00:00",null,null,47]
["2024-11-21",{"$f":"IF(Stunden_DATA!B28=\"\",\"\",Stunden_DATA!B28)","v":""},{"$f":"IF(Stunden_DATA!C28=\"\",\"\",Stunden_DATA!C28)","v":""},{"$f":"IF(Stunden_DATA!V28>0,IF((L28-K28)*24<6.1,(L28-K28)*24,(L28-K28)*24-0.5-Stunden_DATA!Y28),IF(Stunden_DATA!W28>0,\"\",IF(OR(B28=\"\",C28=\"\"),\"\",(IF(B28<I$4,2,(I$6-B28)*24)+IF(C28>I$10,3.25-Stunden_DATA!Y28,(C28-I$8)*24-Stunden_DATA!Y28)))))","v":""},{"$f":"IF(Stunden_DATA!V28>0,IF(AND((C28-B28)*24>6.1),(C28-B28)*24-D28-0.5,(C28-B28)*24-D28-Stunden_DATA!Y28)-Stunden_DATA!Y28,IF(OR(B28=\"\",C28=\"\"),\"\",IF(Stunden_DATA!W28>0,(C28-B28)*24-Stunden_DATA!Y28,(C28-B28)*24-D28-(8.75+Stunden_DATA!Y28))))","v":""},"",null,null,null,null,"","20:00:00",null,null,47]
["2024-11-22",{"$f":"IF(Stunden_DATA!B29=\"\",\"\",Stunden_DATA!B29)","v":""},{"$f":"IF(Stunden_DATA!C29=\"\",\"\",Stunden_DATA!C29)","v":""},{"$f":"IF(Stunden_DATA!V29>0,IF((L29-K29)*24<6.1,(L29-K29)*24,(L29-K29)*24-0.5-Stunden_DATA!Y29),IF(Stunden_DATA!W29>0,\"\",IF(OR(B29=\"\",C29=\"\"),\"\",(IF(B29<I$4,2,(I$6-B29)*24)+IF(C29>I$10,3.25-Stunden_DATA!Y29,(C29-I$8)*24-Stunden_DATA!Y29)))))","v":""},{"$f":"IF(Stunden_DATA!V29>0,IF(AND((C29-B29)*24>6.1),(C29-B29)*24-D29-0.5,(C29-B29)*24-D29-Stunden_DATA!Y29)-Stunden_DATA!Y29,IF(OR(B29=\"\",C29=\"\"),\"\",IF(Stunden_DATA!W29>0,(C29-B29)*24-Stunden_DATA!Y29,(C29-B29)*24-D29-(8.75+Stunden_DATA!Y29))))","v":""},"",null,null,null,null,"","20:00:00",null,null,47]
["2024-11-23",{"$f":"IF(Stunden_DATA!B30=\"\",\"\",Stunden_DATA!B30)","v":""},{"$f":"IF(Stunden_DATA!C30=\"\",\"\",Stunden_DATA!C30)","v":""},{"$f":"IF(Stunden_DATA!V30>0,IF((L30-K30)*24<6.1,(L30-K30)*24,(L30-K30)*24-0.5-Stunden_DATA!Y30),IF(Stunden_DATA!W30>0,\"\",IF(OR(B30=\"\",C30=\"\"),\"\",(IF(B30<I$4,2,(I$6-B30)*24)+IF(C30>I$10,3.25-Stunden_DATA!Y30,(C30-I$8)*24-Stunden_DATA!Y30)))))","v":""},{"$f":"IF(Stunden_DATA!V30>0,IF(AND((C30-B30)*24>6.1),(C30-B30)*24-D30-0.5,(C30-B30)*24-D30-Stunden_DATA!Y30)-Stunden_DATA!Y30,IF(OR(B30=\"\",C30=\"\"),\"\",IF(Stunden_DATA!W30>0,(C30-B30)*24-Stunden_DATA!Y30,(C30-B30)*24-D30-(8.75+Stunden_DATA!Y30))))","v":""},"",null,null,null,null,"","20:00:00",null,null,47]
["2024-11-24",{"$f":"IF(Stunden_DATA!B31=\"\",\"\",Stunden_DATA!B31)","v":""},{"$f":"IF(Stunden_DATA!C31=\"\",\"\",Stunden_DATA!C31)","v":""},{"$f":"IF(Stunden_DATA!V31>0,IF((L31-K31)*24<6.1,(L31-K31)*24,(L31-K31)*24-0.5-Stunden_DATA!Y31),IF(Stunden_DATA!W31>0,\"\",IF(OR(B31=\"\",C31=\"\"),\"\",(IF(B31<I$4,2,(I$6-B31)*24)+IF(C31>I$10,3.25-Stunden_DATA!Y31,(C31-I$8)*24-Stunden_DATA!Y31)))))","v":""},{"$f":"IF(Stunden_DATA!V31>0,IF(AND((C31-B31)*24>6.1),(C31-B31)*24-D31-0.5,(C31-B31)*24-D31-Stunden_DATA!Y31)-Stunden_DATA!Y31,IF(OR(B31=\"\",C31=\"\"),\"\",IF(Stunden_DATA!W31>0,(C31-B31)*24-Stunden_DATA!Y31,(C31-B31)*24-D31-(8.75+Stunden_DATA!Y31))))","v":""},"",null,null,null,null,"","20:00:00",null,null,47]
["2024-11-25",{"$f":"IF(Stunden_DATA!B32=\"\",\"\",Stunden_DATA!B32)","v":""},{"$f":"IF(Stunden_DATA!C32=\"\",\"\",Stunden_DATA!C32)","v":""},{"$f":"IF(Stunden_DATA!V32>0,IF((L32-K32)*24<6.1,(L32-K32)*24,(L32-K32)*24-0.5-Stunden_DATA!Y32),IF(Stunden_DATA!W32>0,\"\",IF(OR(B32=\"\",C32=\"\"),\"\",(IF(B32<I$4,2,(I$6-B32)*24)+IF(C32>I$10,3.25-Stunden_DATA!Y32,(C32-I$8)*24-Stunden_DATA!Y32)))))","v":""},{"$f":"IF(Stunden_DATA!V32>0,IF(AND((C32-B32)*24>6.1),(C32-B32)*24-D32-0.5,(C32-B32)*24-D32-Stunden_DATA!Y32)-Stunden_DATA!Y32,IF(OR(B32=\"\",C32=\"\"),\"\",IF(Stunden_DATA!W32>0,(C32-B32)*24-Stunden_DATA!Y32,(C32-B32)*24-D32-(8.75+Stunden_DATA!Y32))))","v":""},"",null,null,null,null,"","20:00:00",null,null,48]
["2024-11-26",{"$f":"IF(Stunden_DATA!B33=\"\",\"\",Stunden_DATA!B33)","v":""},{"$f":"IF(Stunden_DATA!C33=\"\",\"\",Stunden_DATA!C33)","v":""},{"$f":"IF(Stunden_DATA!V33>0,IF((L33-K33)*24<6.1,(L33-K33)*24,(L33-K33)*24-0.5-Stunden_DATA!Y33),IF(Stunden_DATA!W33>0,\"\",IF(OR(B33=\"\",C33=\"\"),\"\",(IF(B33<I$4,2,(I$6-B33)*24)+IF(C33>I$10,3.25-Stunden_DATA!Y33,(C33-I$8)*24-Stunden_DATA!Y33)))))","v":""},{"$f":"IF(Stunden_DATA!V33>0,IF(AND((C33-B33)*24>6.1),(C33-B33)*24-D33-0.5,(C33-B33)*24-D33-Stunden_DATA!Y33)-Stunden_DATA!Y33,IF(OR(B33=\"\",C33=\"\"),\"\",IF(Stunden_DATA!W33>0,(C33-B33)*24-Stunden_DATA!Y33,(C33-B33)*24-D33-(8.75+Stunden_DATA!Y33))))","v":""},"",null,null,null,null,"","20:00:00",null,null,48]
["2024-11-27",{"$f":"IF(Stunden_DATA!B34=\"\",\"\",Stunden_DATA!B34)","v":""},{"$f":"IF(Stunden_DATA!C34=\"\",\"\",Stunden_DATA!C34)","v":""},{"$f":"IF(Stunden_DATA!V34>0,IF((L34-K34)*24<6.1,(L34-K34)*24,(L34-K34)*24-0.5-Stunden_DATA!Y34),IF(Stunden_DATA!W34>0,\"\",IF(OR(B34=\"\",C34=\"\"),\"\",(IF(B34<I$4,2,(I$6-B34)*24)+IF(C34>I$10,3.25-Stunden_DATA!Y34,(C34-I$8)*24-Stunden_DATA!Y34)))))","v":""},{"$f":"IF(Stunden_DATA!V34>0,IF(AND((C34-B34)*24>6.1),(C34-B34)*24-D34-0.5,(C34-B34)*24-D34-Stunden_DATA!Y34)-Stunden_DATA!Y34,IF(OR(B34=\"\",C34=\"\"),\"\",IF(Stunden_DATA!W34>0,(C34-B34)*24-Stunden_DATA!Y34,(C34-B34)*24-D34-(8.75+Stunden_DATA!Y34))))","v":""},"",null,null,null,null,"","20:00:00",null,null,48]
["2024-11-28",{"$f":"IF(Stunden_DATA!B35=\"\",\"\",Stunden_DATA!B35)","v":""},{"$f":"IF(Stunden_DATA!C35=\"\",\"\",Stunden_DATA!C35)","v":""},{"$f":"IF(Stunden_DATA!V35>0,IF((L35-K35)*24<6.1,(L35-K35)*24,(L35-K35)*24-0.5-Stunden_DATA!Y35),IF(Stunden_DATA!W35>0,\"\",IF(OR(B35=\"\",C35=\"\"),\"\",(IF(B35<I$4,2,(I$6-B35)*24)+IF(C35>I$10,3.25-Stunden_DATA!Y35,(C35-I$8)*24-Stunden_DATA!Y35)))))","v":""},{"$f":"IF(Stunden_DATA!V35>0,IF(AND((C35-B35)*24>6.1),(C35-B35)*24-D35-0.5,(C35-B35)*24-D35-Stunden_DATA!Y35)-Stunden_DATA!Y35,IF(OR(B35=\"\",C35=\"\"),\"\",IF(Stunden_DATA!W35>0,(C35-B35)*24-Stunden_DATA!Y35,(C35-B35)*24-D35-(8.75+Stunden_DATA!Y35))))","v":""},"",null,null,null,null,"","20:00:00",null,null,48]
["2024-11-29",{"$f":"IF(Stunden_DATA!B36=\"\",\"\",Stunden_DATA!B36)","v":""},{"$f":"IF(Stunden_DATA!C36=\"\",\"\",Stunden_DATA!C36)","v":""},{"$f":"IF(Stunden_DATA!V36>0,IF((L36-K36)*24<6.1,(L36-K36)*24,(L36-K36)*24-0.5-Stunden_DATA!Y36),IF(Stunden_DATA!W36>0,\"\",IF(OR(B36=\"\",C36=\"\"),\"\",(IF(B36<I$4,2,(I$6-B36)*24)+IF(C36>I$10,3.25-Stunden_DATA!Y36,(C36-I$8)*24-Stunden_DATA!Y36)))))","v":""},{"$f":"IF(Stunden_DATA!V36>0,IF(AND((C36-B36)*24>6.1),(C36-B36)*24-D36-0.5,(C36-B36)*24-D36-Stunden_DATA!Y36)-Stunden_DATA!Y36,IF(OR(B36=\"\",C36=\"\"),\"\",IF(Stunden_DATA!W36>0,(C36-B36)*24-Stunden_DATA!Y36,(C36-B36)*24-D36-(8.75+Stunden_DATA!Y36))))","v":""},"",null,null,null,null,"","20:00:00",null,null,48]
["2024-11-30",{"$f":"IF(Stunden_DATA!B37=\"\",\"\",Stunden_DATA!B37)","v":""},{"$f":"IF(Stunden_DATA!C37=\"\",\"\",Stunden_DATA!C37)","v":""},{"$f":"IF(Stunden_DATA!V37>0,IF((L37-K37)*24<6.1,(L37-K37)*24,(L37-K37)*24-0.5-Stunden_DATA!Y37),IF(Stunden_DATA!W37>0,\"\",IF(OR(B37=\"\",C37=\"\"),\"\",(IF(B37<I$4,2,(I$6-B37)*24)+IF(C37>I$10,3.25-Stunden_DATA!Y37,(C37-I$8)*24-Stunden_DATA!Y37)))))","v":""},{"$f":"IF(Stunden_DATA!V37>0,IF(AND((C37-B37)*24>6.1),(C37-B37)*24-D37-0.5,(C37-B37)*24-D37-Stunden_DATA!Y37)-Stunden_DATA!Y37,IF(OR(B37=\"\",C37=\"\"),\"\",IF(Stunden_DATA!W37>0,(C37-B37)*24-Stunden_DATA!Y37,(C37-B37)*24-D37-(8.75+Stunden_DATA!Y37))))","v":""},"",null,null,null,null,"","20:00:00",null,null,48]
["2024-12-01",{"$f":"IF(Stunden_DATA!B38=\"\",\"\",Stunden_DATA!B38)","v":""},{"$f":"IF(Stunden_DATA!C38=\"\",\"\",Stunden_DATA!C38)","v":""},{"$f":"IF(Stunden_DATA!V38>0,IF((L38-K38)*24<6.1,(L38-K38)*24,(L38-K38)*24-0.5-Stunden_DATA!Y38),IF(Stunden_DATA!W38>0,\"\",IF(OR(B38=\"\",C38=\"\"),\"\",(IF(B38<I$4,2,(I$6-B38)*24)+IF(C38>I$10,3.25-Stunden_DATA!Y38,(C38-I$8)*24-Stunden_DATA!Y38)))))","v":""},{"$f":"IF(Stunden_DATA!V38>0,IF(AND((C38-B38)*24>6.1),(C38-B38)*24-D38-0.5,(C38-B38)*24-D38-Stunden_DATA!Y38)-Stunden_DATA!Y38,IF(OR(B38=\"\",C38=\"\"),\"\",IF(Stunden_DATA!W38>0,(C38-B38)*24-Stunden_DATA!Y38,(C38-B38)*24-D38-(8.75+Stunden_DATA!Y38))))","v":""},"",null,null,null,null,"","20:00:00",null,null,48]
[null,"Summen:",null,{"$f":"SUM(D8:D38)","v":-1.0000000000000009},{"$f":"SUM(E8:E38)","v":2},{"$f":"SUM(F8:F38)","v":0.99999999999999911}]