{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Daten","Hinweise"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Daten","index":0,"n_rows":51,"n_cols":44,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,42,1,43],[2,42,2,43],[38,42,38,43],[39,42,39,43],[43,26,43,27],[1,40,1,41],[2,40,2,41],[38,40,38,41],[39,40,39,41],[40,18,40,29],[39,24,39,27],[1,31,1,38],[38,22,38,23],[38,24,38,25],[2,22,2,23],[1,28,1,29],[49,6,49,8],[49,10,49,12],[49,15,49,21],[44,12,44,13],[42,12,42,13],[43,12,43,13],[46,0,47,29],[49,23,49,28],[43,1,43,2],[44,28,44,29],[43,28,43,29],[42,24,42,27],[43,24,43,25],[49,0,49,4],[38,1,38,5],[40,1,40,2],[40,3,40,5],[44,19,44,20],[44,21,44,22],[42,19,43,22],[41,12,41,13],[40,12,40,13],[39,12,39,13],[39,18,39,19],[39,20,39,21],[0,3,0,8],[1,18,1,19],[2,18,2,19],[0,15,0,17],[0,18,0,29],[2,9,2,11],[2,17,3,17],[1,9,1,11],[2,26,2,27],[0,9,0,11],[38,26,38,27],[2,28,2,29],[38,28,38,29],[1,22,1,23],[39,28,39,29],[0,0,34,0],[36,0,44,0],[1,24,1,27],[2,24,2,25],[39,22,39,23],[37,12,37,13],[38,18,38,19],[38,20,38,21],[2,13,3,13],[38,12,38,13],[36,12,36,13],[0,14,3,14],[1,20,1,21],[2,20,2,21],[36,1,36,3],[36,5,36,6]]}
["Stundennachweis  für geringfügig Beschäftigte\n(Aushilfen und stud./wiss. Hilfskräfte)","Datum",null,"Erfassung der Arbeitszeit einschließlich der Pausen",null,null,null,null,null,"Zeitanrechn. für Urlaub",null,null,"Erläuterungen, Hinweise,",null," F mit FZA","Relevante Arbeitszeit",null,null,"Basiszeiten für die Berechnung von Zeitzuschlägen (NICHT für HiWis)"]
[null,null,null,"an gearbeiteten Tagen",null,null,null,null,null,"Feiertag, Krank, Arbeits-",null,null,"Vermerke",null,null,"ohne Pausen",null,null,"Nacht",null,"Samstag",null,"Sonntag",null,"Feiertag 0 - 24 Uhr",null,null,null,"24./31.12.",null,null,"NICHT LÖSCHEN",null,null,null,null,null,null,null,null,"Samstag",null,"Samstag"]
[null,"Tag","Wo-","Beginn","Pause 1",null,"Pause 2",null,"Ende","und Freizeitausgleich",null,null,null,"F\nVF",null,null,null,"Indust- riezeit","21 - 6 Uhr",null,"13 - 21 Uhr",null,"0 - 24 Uhr",null,"mit FZA",null,"ohne FZA",null,"6 - 24 Uhr",null,null,null,null,"U",{"$f":"IF(AND(TEXT(AJ3,\"MMMM\")=$B$37,TEXT(AJ3,\"JJJJ\")=TEXT($F$37,\"0000\")),VALUE(TEXT(AJ3,\"T\")),\"\")","v":""},{"$f":"DATE($F$37,1,1)","v":"1900-01-01"},{"$f":"\" Neujahr\"","v":" Neujahr"},"F","X",null,"13 - 20 Uhr",null,"20 - 21 Uhr"]
[null,null,"tag","um","von","bis","von","bis","um","Std.","Min.","Grund",null,null,null,"Std.","Min.",null,"Std.","Min.","Std.","Min.","Std.","Min.","Std.","Min.","Std.","Min.","Std.","Min.",null,"Januar",{"$f":"AG5-1","v":2023},"K",{"$f":"IF(AND(TEXT(AJ4,\"MMMM\")=$B$37,TEXT(AJ4,\"JJJJ\")=TEXT($F$37,\"0000\")),VALUE(TEXT(AJ4,\"T\")),\"\")","v":""},{"$f":"DATE($F$37,1,6)","v":"1900-01-06"},{"$f":"\" Heilige drei Könige\"","v":" Heilige drei Könige"},"F",null,null,"Std.","Min.","Std.","Min."]
[null,1,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B5),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B5),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISERROR(VLOOKUP($B5,$AI$3:$AL$19,4,FALSE)),\"\",VLOOKUP($B5,$AI$3:$AL$19,4,FALSE))","v":""},null,{"$f":"IF(OR(L5=\"AZA\",L5=\"FZA\"),0,IF(OR(L5=\"U\",L5=\"K\",L5=\"SON\"),J5,HOUR(IF(AND(D5<>\"\",I5<>\"\"),IF(I5>=D5,I5-D5,)-IF(AND(E5>=D5,F5>=E5),F5-E5,)-IF(AND(G5>=F5,H5>=G5),H5-G5,),))))","v":0},{"$f":"IF(OR(L5=\"AZA\",L5=\"FZA\"),0,IF(OR(L5=\"U\",L5=\"K\",L5=\"SON\"),K5,MINUTE(IF(AND(D5<>\"\",I5<>\"\"),IF(I5>=D5,I5-D5,)-IF(AND(E5>=D5,F5>=E5),F5-E5,)-IF(AND(G5>=F5,H5>=G5),H5-G5,),))))","v":0},{"$f":"P5+Q5/60","v":0},{"$f":"HOUR(IF(AND($L5=\"\",$I5>21/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(24/24,$I5)-MAX(21/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,21/24),24/24)-MAX(MIN($E5,24/24),21/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,21/24),24/24)-MAX(MIN($G5,24/24),21/24),0),)+IF(AND($L5=\"\",$D5<6/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(6/24,$I5)-MAX(0/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,0/24),6/24)-MAX(MIN($E5,6/24),0/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,0/24),6/24)-MAX(MIN($G5,6/24),0/24),0),0))","v":0},{"$f":"MINUTE(IF(AND($L5=\"\",$I5>21/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(24/24,$I5)-MAX(21/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,21/24),24/24)-MAX(MIN($E5,24/24),21/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,21/24),24/24)-MAX(MIN($G5,24/24),21/24),0),)+IF(AND($L5=\"\",$D5<6/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(6/24,$I5)-MAX(0/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,0/24),6/24)-MAX(MIN($E5,6/24),0/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,0/24),6/24)-MAX(MIN($G5,6/24),0/24),0),0))","v":0},{"$f":"HOUR(IF(AND($C5=\"Sa\",$L5=\"\",$N5=\"\",$I5>13/24,$D5<21/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(21/24,$I5)-MAX(13/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,13/24),21/24)-MAX(MIN($E5,21/24),13/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,13/24),21/24)-MAX(MIN($G5,21/24),13/24),0),0))","v":0},{"$f":"MINUTE(IF(AND($C5=\"Sa\",$L5=\"\",$N5=\"\",$I5>13/24,$D5<21/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(21/24,$I5)-MAX(13/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,13/24),21/24)-MAX(MIN($E5,21/24),13/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,13/24),21/24)-MAX(MIN($G5,21/24),13/24),0),0))","v":0},{"$f":"IF(AND($L5=\"\",$N5=\"\",$C5=\"So\"),P5,0)+HOUR(IF(AND($L5=\"\",$N5=\"VF\",$C5=\"So\",$D5<6/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(6/24,$I5)-MAX(0/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,0/24),6/24)-MAX(MIN($E5,6/24),0/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,0/24),6/24)-MAX(MIN($G5,6/24),0/24),0),0))","v":0},{"$f":"IF(AND($L5=\"\",$N5=\"\",$C5=\"So\"),Q5,0)+MINUTE(IF(AND($L5=\"\",$N5=\"VF\",$C5=\"So\",$D5<6/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(6/24,$I5)-MAX(0/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,0/24),6/24)-MAX(MIN($E5,6/24),0/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,0/24),6/24)-MAX(MIN($G5,6/24),0/24),0),0))","v":0},{"$f":"IF(AND($L5=\"\",$N5=\"F\",$O5<>\"\"),P5,0)","v":0},{"$f":"IF(AND($L5=\"\",$N5=\"F\",$O5<>\"\"),Q5,0)","v":0},{"$f":"IF(AND($L5=\"\",$N5=\"F\",$O5=\"\"),P5,0)","v":0},{"$f":"IF(AND($L5=\"\",$N5=\"F\",$O5=\"\"),Q5,0)","v":0},{"$f":"HOUR(IF(AND($L5=\"\",$N5=\"VF\",$I5>6/24,$D5<24/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(24/24,$I5)-MAX(6/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,6/24),24/24)-MAX(MIN($E5,24/24),6/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,6/24),24/24)-MAX(MIN($G5,24/24),6/24),0),0))","v":0},{"$f":"MINUTE(IF(AND($L5=\"\",$N5=\"VF\",$I5>6/24,$D5<24/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(24/24,$I5)-MAX(6/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,6/24),24/24)-MAX(MIN($E5,24/24),6/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,6/24),24/24)-MAX(MIN($G5,24/24),6/24),0),0))","v":0},null,"Februar",{"$f":"YEAR(TODAY())","v":2024},"AZA","",{"$f":"AJ6-2","v":"1900-02-24"},{"$f":"\" Karfreitag\"","v":" Karfreitag"},"F",null,null,{"$f":"HOUR(IF(AND($C5=\"Sa\",$L5=\"\",$N5=\"\",$I5>13/24,$D5<20/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(20/24,$I5)-MAX(13/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,13/24),20/24)-MAX(MIN($E5,20/24),13/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,13/24),20/24)-MAX(MIN($G5,20/24),13/24),0),0))","v":0},{"$f":"MINUTE(IF(AND($C5=\"Sa\",$L5=\"\",$N5=\"\",$I5>13/24,$D5<20/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(20/24,$I5)-MAX(13/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,13/24),20/24)-MAX(MIN($E5,20/24),13/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,13/24),20/24)-MAX(MIN($G5,20/24),13/24),0),0))","v":0},{"$f":"HOUR(IF(AND($C5=\"Sa\",$L5=\"\",$N5=\"\",$I5>20/24,$D5<21/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(21/24,$I5)-MAX(20/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,20/24),21/24)-MAX(MIN($E5,21/24),20/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,20/24),21/24)-MAX(MIN($G5,21/24),20/24),0),0))","v":0},{"$f":"MINUTE(IF(AND($C5=\"Sa\",$L5=\"\",$N5=\"\",$I5>20/24,$D5<21/24),IF(AND($D5<>\"\",$I5<>\"\"),MIN(21/24,$I5)-MAX(20/24,$D5),0)-IF(AND($E5<>\"\",$F5<>\"\"),MIN(MAX($F5,20/24),21/24)-MAX(MIN($E5,21/24),20/24),0)-IF(AND($G5<>\"\",$H5<>\"\"),MIN(MAX($H5,20/24),21/24)-MAX(MIN($G5,21/24),20/24),0),0))","v":0}]
[null,2,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B6),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B6),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISERROR(VLOOKUP($B6,$AI$3:$AL$19,4,FALSE)),\"\",VLOOKUP($B6,$AI$3:$AL$19,4,FALSE))","v":""},null,{"$f":"IF(OR(L6=\"AZA\",L6=\"FZA\"),0,IF(OR(L6=\"U\",L6=\"K\",L6=\"SON\"),J6,HOUR(IF(AND(D6<>\"\",I6<>\"\"),IF(I6>=D6,I6-D6,)-IF(AND(E6>=D6,F6>=E6),F6-E6,)-IF(AND(G6>=F6,H6>=G6),H6-G6,),))))","v":0},{"$f":"IF(OR(L6=\"AZA\",L6=\"FZA\"),0,IF(OR(L6=\"U\",L6=\"K\",L6=\"SON\"),K6,MINUTE(IF(AND(D6<>\"\",I6<>\"\"),IF(I6>=D6,I6-D6,)-IF(AND(E6>=D6,F6>=E6),F6-E6,)-IF(AND(G6>=F6,H6>=G6),H6-G6,),))))","v":0},{"$f":"P6+Q6/60","v":0},{"$f":"HOUR(IF(AND($L6=\"\",$I6>21/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(24/24,$I6)-MAX(21/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,21/24),24/24)-MAX(MIN($E6,24/24),21/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,21/24),24/24)-MAX(MIN($G6,24/24),21/24),0),)+IF(AND($L6=\"\",$D6<6/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(6/24,$I6)-MAX(0/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,0/24),6/24)-MAX(MIN($E6,6/24),0/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,0/24),6/24)-MAX(MIN($G6,6/24),0/24),0),0))","v":0},{"$f":"MINUTE(IF(AND($L6=\"\",$I6>21/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(24/24,$I6)-MAX(21/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,21/24),24/24)-MAX(MIN($E6,24/24),21/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,21/24),24/24)-MAX(MIN($G6,24/24),21/24),0),)+IF(AND($L6=\"\",$D6<6/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(6/24,$I6)-MAX(0/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,0/24),6/24)-MAX(MIN($E6,6/24),0/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,0/24),6/24)-MAX(MIN($G6,6/24),0/24),0),0))","v":0},{"$f":"HOUR(IF(AND($C6=\"Sa\",$L6=\"\",$N6=\"\",$I6>13/24,$D6<21/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(21/24,$I6)-MAX(13/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,13/24),21/24)-MAX(MIN($E6,21/24),13/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,13/24),21/24)-MAX(MIN($G6,21/24),13/24),0),0))","v":0},{"$f":"MINUTE(IF(AND($C6=\"Sa\",$L6=\"\",$N6=\"\",$I6>13/24,$D6<21/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(21/24,$I6)-MAX(13/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,13/24),21/24)-MAX(MIN($E6,21/24),13/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,13/24),21/24)-MAX(MIN($G6,21/24),13/24),0),0))","v":0},{"$f":"IF(AND($L6=\"\",$N6=\"\",$C6=\"So\"),P6,0)+HOUR(IF(AND($L6=\"\",$N6=\"VF\",$C6=\"So\",$D6<6/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(6/24,$I6)-MAX(0/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,0/24),6/24)-MAX(MIN($E6,6/24),0/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,0/24),6/24)-MAX(MIN($G6,6/24),0/24),0),0))","v":0},{"$f":"IF(AND($L6=\"\",$N6=\"\",$C6=\"So\"),Q6,0)+MINUTE(IF(AND($L6=\"\",$N6=\"VF\",$C6=\"So\",$D6<6/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(6/24,$I6)-MAX(0/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,0/24),6/24)-MAX(MIN($E6,6/24),0/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,0/24),6/24)-MAX(MIN($G6,6/24),0/24),0),0))","v":0},{"$f":"IF(AND($L6=\"\",$N6=\"F\",$O6<>\"\"),P6,0)","v":0},{"$f":"IF(AND($L6=\"\",$N6=\"F\",$O6<>\"\"),Q6,0)","v":0},{"$f":"IF(AND($L6=\"\",$N6=\"F\",$O6=\"\"),P6,0)","v":0},{"$f":"IF(AND($L6=\"\",$N6=\"F\",$O6=\"\"),Q6,0)","v":0},{"$f":"HOUR(IF(AND($L6=\"\",$N6=\"VF\",$I6>6/24,$D6<24/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(24/24,$I6)-MAX(6/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,6/24),24/24)-MAX(MIN($E6,24/24),6/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,6/24),24/24)-MAX(MIN($G6,24/24),6/24),0),0))","v":0},{"$f":"MINUTE(IF(AND($L6=\"\",$N6=\"VF\",$I6>6/24,$D6<24/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(24/24,$I6)-MAX(6/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,6/24),24/24)-MAX(MIN($E6,24/24),6/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,6/24),24/24)-MAX(MIN($G6,24/24),6/24),0),0))","v":0},null,"März",{"$f":"AG5+1","v":2025},"FZA","",{"$f":"7*ROUND((4&-$F$37)/7+MOD(19*MOD($F$37,19)-7,30)*0.14,)-6","v":"1900-02-26"},{"$f":"\" Ostersonntag\"","v":" Ostersonntag"},{"$f":"\"\"","v":""},null,null,{"$f":"HOUR(IF(AND($C6=\"Sa\",$L6=\"\",$N6=\"\",$I6>13/24,$D6<20/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(20/24,$I6)-MAX(13/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,13/24),20/24)-MAX(MIN($E6,20/24),13/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,13/24),20/24)-MAX(MIN($G6,20/24),13/24),0),0))","v":0},{"$f":"MINUTE(IF(AND($C6=\"Sa\",$L6=\"\",$N6=\"\",$I6>13/24,$D6<20/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(20/24,$I6)-MAX(13/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,13/24),20/24)-MAX(MIN($E6,20/24),13/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,13/24),20/24)-MAX(MIN($G6,20/24),13/24),0),0))","v":0},{"$f":"HOUR(IF(AND($C6=\"Sa\",$L6=\"\",$N6=\"\",$I6>20/24,$D6<21/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(21/24,$I6)-MAX(20/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,20/24),21/24)-MAX(MIN($E6,21/24),20/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,20/24),21/24)-MAX(MIN($G6,21/24),20/24),0),0))","v":0},{"$f":"MINUTE(IF(AND($C6=\"Sa\",$L6=\"\",$N6=\"\",$I6>20/24,$D6<21/24),IF(AND($D6<>\"\",$I6<>\"\"),MIN(21/24,$I6)-MAX(20/24,$D6),0)-IF(AND($E6<>\"\",$F6<>\"\"),MIN(MAX($F6,20/24),21/24)-MAX(MIN($E6,21/24),20/24),0)-IF(AND($G6<>\"\",$H6<>\"\"),MIN(MAX($H6,20/24),21/24)-MAX(MIN($G6,21/24),20/24),0),0))","v":0}]
[null,3,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B7),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B7),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"April",null,"SON","",{"$f":"AJ6+1","v":"1900-02-27"},{"$f":"\" Ostermontag\"","v":" Ostermontag"},"F",null,null,0,0,0,0]
[null,4,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B8),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B8),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Mai",null,null,"",{"$f":"DATE($F$37,5,1)","v":"1900-05-01"},{"$f":"\" Tag der Arbeit\"","v":" Tag der Arbeit"},"F",null,null,0,0,0,0]
[null,5,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B9),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B9),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Juni",null,null,"",{"$f":"AJ6+39","v":"1900-04-05"},{"$f":"\" Himmelfahrt\"","v":" Himmelfahrt"},"F",null,null,0,0,0,0]
[null,6,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B10),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B10),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Juli",null,null,"",{"$f":"AJ6+49","v":"1900-04-15"},{"$f":"\" Pfingstsonntag\"","v":" Pfingstsonntag"},{"$f":"\"\"","v":""},null,null,0,0,0,0]
[null,7,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B11),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B11),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"August",null,null,"",{"$f":"AJ6+50","v":"1900-04-16"},{"$f":"\" Pfingstmontag\"","v":" Pfingstmontag"},"F",null,null,0,0,0,0]
[null,8,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B12),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B12),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"September",null,null,"",{"$f":"AJ6+60","v":"1900-04-26"},{"$f":"\" Fronleichnam\"","v":" Fronleichnam"},"F",null,null,0,0,0,0]
[null,9,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B13),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B13),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Oktober",null,null,"",{"$f":"DATE($F$37,10,3)","v":"1900-10-03"},{"$f":"\" Tag der Dt. Einheit\"","v":" Tag der Dt. Einheit"},"F",null,null,0,0,0,0]
[null,10,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B14),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B14),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"November",null,null,"",{"$f":"DATE($F$37,11,1)","v":"1900-11-01"},{"$f":"\" Allerheiligen\"","v":" Allerheiligen"},"F",null,null,0,0,0,0]
[null,11,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B15),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B15),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Dezember",null,null,"",{"$f":"DATE($F$37,12,24)","v":"1900-12-24"},{"$f":"\" Heiligabend\"","v":" Heiligabend"},"VF",null,null,0,0,0,0]
[null,12,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B16),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B16),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,"",{"$f":"DATE($F$37,12,25)","v":"1900-12-25"},{"$f":"\" 1. Weihnachtstag\"","v":" 1. Weihnachtstag"},"F",null,null,0,0,0,0]
[null,13,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B17),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B17),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,"",{"$f":"DATE($F$37,12,26)","v":"1900-12-26"},{"$f":"\" 2. Weihnachtstag\"","v":" 2. Weihnachtstag"},"F",null,null,0,0,0,0]
[null,14,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B18),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B18),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,"",{"$f":"DATE($F$37,12,31)","v":"1900-12-31"},{"$f":"\" Silvester\"","v":" Silvester"},"VF",null,null,0,0,0,0]
[null,15,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B19),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B19),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,"","2017-10-31",{"$f":"\" Reformationstag\"","v":" Reformationstag"},"F",null,null,0,0,0,0]
[null,16,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B20),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B20),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,17,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B21),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B21),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,18,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B22),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B22),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,19,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B23),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B23),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,20,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B24),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B24),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,21,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B25),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B25),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,22,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B26),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B26),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,23,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B27),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B27),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,24,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B28),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B28),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,25,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B29),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B29),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,26,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B30),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B30),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,27,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B31),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B31),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,28,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B32),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B32),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,29,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B33),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B33),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,30,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B34),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B34),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,31,{"$f":"IF(AND($B$37<>\"\",$F$37<>\"\"),IF(TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B35),\"MMMM\")=$B$37,TEXT(DATE($F$37,VLOOKUP($B$37,{\"Januar\",1;\"Februar\",2;\"März\",3;\"April\",4;\"Mai\",5;\"Juni\",6;\"Juli\",7;\"August\",8;\"September\",9;\"Oktober\",10;\"November\",11;\"Dezember\",12},2,0),B35),\"TTT\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,"","",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[]
["Ich bestätige, dass die Angaben im Einklang mit den geltenden Arbeitszeitregelungen stehen.",null,null,null,null,null,null,null,null,null,null,null,"Monatsarbeitszeit IST",null,null,{"$f":"INT(((SUM(P5:P35)*100)+(SUM(Q5:Q35)/60*100))/100)","v":0},{"$f":"(((SUM(P5:P35)*100)+(SUM(Q5:Q35)/60*100))/100-INT(((SUM(P5:P35)*100)+(SUM(Q5:Q35)/60*100))/100))*60","v":0},{"$f":"P37+Q37/60","v":0},{"$f":"INT(((SUM(S5:S35)*100)+(SUM(T5:T35)/60*100))/100)","v":0},{"$f":"(((SUM(S5:S35)*100)+(SUM(T5:T35)/60*100))/100-INT(((SUM(S5:S35)*100)+(SUM(T5:T35)/60*100))/100))*60","v":0},{"$f":"INT(((SUM(U5:U35)*100)+(SUM(V5:V35)/60*100))/100)","v":0},{"$f":"(((SUM(U5:U35)*100)+(SUM(V5:V35)/60*100))/100-INT(((SUM(U5:U35)*100)+(SUM(V5:V35)/60*100))/100))*60","v":0},{"$f":"INT(((SUM(W5:W35)*100)+(SUM(X5:X35)/60*100))/100)","v":0},{"$f":"(((SUM(W5:W35)*100)+(SUM(X5:X35)/60*100))/100-INT(((SUM(W5:W35)*100)+(SUM(X5:X35)/60*100))/100))*60","v":0},{"$f":"INT(((SUM(Y5:Y35)*100)+(SUM(Z5:Z35)/60*100))/100)","v":0},{"$f":"(((SUM(Y5:Y35)*100)+(SUM(Z5:Z35)/60*100))/100-INT(((SUM(Y5:Y35)*100)+(SUM(Z5:Z35)/60*100))/100))*60","v":0},{"$f":"INT(((SUM(AA5:AA35)*100)+(SUM(AB5:AB35)/60*100))/100)","v":0},{"$f":"(((SUM(AA5:AA35)*100)+(SUM(AB5:AB35)/60*100))/100-INT(((SUM(AA5:AA35)*100)+(SUM(AB5:AB35)/60*100))/100))*60","v":0},{"$f":"INT(((SUM(AC5:AC35)*100)+(SUM(AD5:AD35)/60*100))/100)","v":0},{"$f":"(((SUM(AC5:AC35)*100)+(SUM(AD5:AD35)/60*100))/100-INT(((SUM(AC5:AC35)*100)+(SUM(AD5:AD35)/60*100))/100))*60","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"INT(((SUM(AO5:AO35)*100)+(SUM(AP5:AP35)/60*100))/100)","v":0},{"$f":"(((SUM(AO5:AO35)*100)+(SUM(AP5:AP35)/60*100))/100-INT(((SUM(AO5:AO35)*100)+(SUM(AP5:AP35)/60*100))/100))*60","v":0},{"$f":"INT(((SUM(AQ5:AQ35)*100)+(SUM(AR5:AR35)/60*100))/100)","v":0},{"$f":"(((SUM(AQ5:AQ35)*100)+(SUM(AR5:AR35)/60*100))/100-INT(((SUM(AQ5:AQ35)*100)+(SUM(AR5:AR35)/60*100))/100))*60","v":0}]
[null,"Abrechnungsmonat",null,null,null,null,"Abrechnungsjahr",null,false,false,null,null,"Übertrag aus Vormonat (+/-)",null,{"$f":"IF(P38*Q38<0,\"!\",\"\")","v":""},null,null,0,"Std.","Min.","Std.","Min.","Std.","Min.","Std.","Min.","Std.","Min.","Std.","Min.",null,null,null,null,null,null,null,null,null,null,"Std.","Min.","Std.","Min."]
[null,null,null,null,null,null,null,null,null,null,null,null,"zzgl. neuer Freizeitausgleich",null,null,{"$f":"Y37","v":0},{"$f":"Z37","v":0},0,"21 - 6 Uhr",null,"13 - 21 Uhr",null,"0 - 24 Uhr",null,"mit FZA",null,"ohne FZA",null,"6 - 24 Uhr",null,null,null,null,null,null,null,null,null,null,null,"13 - 20 Uhr",null,"20 - 21 Uhr"]
[null,"Name, Vorname",null,null,null,null,null,null,null,null,null,null,"Summe",null,null,{"$f":"IF(R40>=0,_xlfn.NUMBERVALUE(TEXT(R40/24,\"[h]\")),-_xlfn.NUMBERVALUE(TEXT(-R40/24,\"[h]\")))","v":0},{"$f":"IF(R40>=0,_xlfn.NUMBERVALUE(TEXT(R40/24,\"m\")),-_xlfn.NUMBERVALUE(TEXT(-R40/24,\"m\")))","v":0},{"$f":"R37+R38","v":0},"Nacht",null,"Samstag",null,"Sonntag",null,"Feiertag 0 - 24 Uhr",null,null,null,"24./31.12.",null,null,null,null,null,null,null,null,null,null,null,"Samstag",null,"Samstag"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Monatsarbeitszeit SOLL",null,{"$f":"IF(P41*Q41<0,\"!\",\"\")","v":""},null,null,0,"Basiszeiten für die Berechnung von Zeitzuschlägen (NICHT für HiWis)"]
[null,"Einr.-Nr.",null,"Abt. / FG",null,null,null,"Datum",null,null,null,null,"Korrektur Feiertage/Vorfesttage",null,null,{"$f":"-(INT(((SUMIFS(J5:J35,L5:L35,\"\",N5:N35,\"*F\")*100)+(SUMIFS(K5:K35,L5:L35,\"\",N5:N35,\"*F\")/60*100))/100))","v":0},{"$f":"-((((SUMIFS(J5:J35,L5:L35,\"\",N5:N35,\"*F\")*100)+(SUMIFS(K5:K35,L5:L35,\"\",N5:N35,\"*F\")/60*100))/100-INT(((SUMIFS(J5:J35,L5:L35,\"\",N5:N35,\"*F\")*100)+(SUMIFS(K5:K35,L5:L35,\"\",N5:N35,\"*F\")/60*100))/100))*60)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,"abzgl. ausbezahlte Mehrarbeitszeit",null,{"$f":"IF(P43*Q43<0,\"!\",\"\")","v":""},null,null,{"$f":"P43+Q43/60","v":0},null,"Information für geringfügig Beschäftigte",null,null,null,null,"Samstagszuschlag"]
[null,{"$f":"TODAY()","v":"2024-03-13"},null,null,null,null,null,null,null,null,null,null,"Zeitübertrag auf Folgemonat",null,null,{"$f":"IF(R44>=0,_xlfn.NUMBERVALUE(TEXT(R44/24,\"[h]\")),-_xlfn.NUMBERVALUE(TEXT(-R44/24,\"[h]\")))","v":0},{"$f":"IF(R44>=0,_xlfn.NUMBERVALUE(TEXT(R44/24,\"m\")),-_xlfn.NUMBERVALUE(TEXT(-R44/24,\"m\")))","v":0},{"$f":"R40-SUM(R41:R43)","v":0},null,null,null,null,null,null,"13 - 20 Uhr",null,"20 - 21 Uhr",null,"Stand:"]
[null,"Datum",null,"Unterschrift Mitarbeiter/in",null,null,null,"Unterschrift Leiter/in",null,null,null,null,"Kontrollwert Wochenarbeitszeit SOLL",null,null,{"$f":"IF(R45>=0,_xlfn.NUMBERVALUE(TEXT(R45/24,\"[h]\")),-_xlfn.NUMBERVALUE(TEXT(-R45/24,\"[h]\")))","v":0},{"$f":"IF(R45>=0,_xlfn.NUMBERVALUE(TEXT(R45/24,\"m\")),-_xlfn.NUMBERVALUE(TEXT(-R45/24,\"m\")))","v":0},{"$f":"R41/4.348","v":0},null,39.5,null,{"$f":"IF(T45>0,R45/T45,\"---\")","v":0},null,null,{"$f":"AO37","v":0},{"$f":"AP37","v":0},{"$f":"AQ37","v":0},{"$f":"AR37","v":0},"2024-03-13"]
[]
["Dieses Formular dient als Arbeitszeitaufschrieb der Erfassung und Dokumentation der Arbeitszeit sowie damit zusammenhängender Informationen. Die Universität verarbeitet diese Daten aufgrund von § 17 Mindestlohngesetz. Nach der Dienstvereinbarung über die Arbeitszeit der Beschäftigten der Universität Hohenheim erfolgt die Arbeitszeiterfassung durch Arbeitszeitaufschriebe. Sie sind im Rahmen einer arbeitsvertraglichen Nebenpflicht verpflichtet, dieses Formular zur Dokumentation Ihrer Arbeitszeit für die Universität zu verwenden. Hinsichtlich Ihrer bei der Universität gespeicherten personenbezogenen Daten haben Sie ein Auskunfts- und Berichtigungsrecht, das Sie gegenüber Ihrem Fachgebiet, Institut oder Ihrer Einrichtung geltend machen können."]
[]
[]
["Buchungsinformationen"]
["(Ggf. von der Dienststelle auszufüllen)",null,null,null,null,null,"Fond",null,null,null,"Kostenstelle",null,null,null,null,"PSP-Element",null,null,null,null,null,null,null,"Sachkonto"]

{"sheet":"Hinweise","index":1,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Implementierte Regeln im Excel-Sheet „Stundennachweis“"]
["●","Eine umfassende Berechnung ist nur möglich, wenn der Abrechnungsmonat und das Abrechnungsjahr eingetragen werden. Aufgrund dieser Auswahl, werden die Wochentage, Feiertage und der 24./31.12. als Vorfesttag eingetragen."]
["●","Die Arbeitszeit liegt immer zwischen 0:00 und 24:00 Uhr. Arbeiten über die Datumsgrenze sind am nächsten Tag einzutragen."]
["●","Pausen werden nicht als Arbeitszeit berücksichtigt. Bei einer Arbeitszeit von mehr als 6 Stunden pro Tag ist eine mindestens 30-minütige unbezahlte Pause einzuplanen. Bei 9 und mehr Stunden, ist eine weitere Pause von 15 Minuten Pflicht."]
["●","Zuschläge werden für tatsächlich geleistete Arbeit berücksichtigt, also nicht an Urlaubstagen und nicht bei Krankheit."]
["●","Eintragungen bei der Zeitanrechnung haben gegenüber den Eintragungen bei der tatsächlichen geleisteten Arbeitszeit Vorrang. Beides ist nicht kombinierbar."]
["●","Der Nachtzuschlag (21:00 - 6:00 Uhr) wird immer zusätzlich berechnet."]
["●","Der Samstag-Zuschlag wird in der Zeit zwischen 13:00 -21:00 Uhr berücksichtigt, sofern dieser kein Feiertag oder der 24./31.12. ist."]
["●","Der Sonntags-Zuschlag wird ganztägig berücksichtigt, sofern dieser kein Feiertag ist. Fallen der 24./31.12. auf einen Sonntag, dann wird in der Zeit bis 6:00 Uhr der Sonntags-Zuschlag berechnet."]
["●","Zuschläge für einen Samstag, Sonntag und Feiertag sind nicht kombinierbar. Es gilt automatisch der höchste Zuschlag."]
["●","Den Feiertags-Zuschlag gibt es an gesetzlichen Feiertagen. Am Oster- und Pfingstsonntag wird nur der Zuschlag für den Sonntag gewährt."]
["●","Der Zuschlag für den 24./31.12. wird in der Zeit zwischen 6:00 und 24:00 Uhr gewährt."]
["●","An Feiertagen steht dem Beschäftigten für die Arbeitszeit ein Zuschlag zu. Wenn dieser in Form von Freizeitausgleich (FZA) gewährt werden soll, ist in der Spalte „F mit FZA“ ein „X“ einzutragen. Ansonsten erfolgt der um 100% erhöhte Zuschlag auf die geleistete Arbeitszeit."]
["●","Bei Urlaub und Krankheit wird nur die geplante Arbeitszeit (laut Dienstplan) berücksichtigt. Dies ist in die entsprechenden Spalten (Zeitanrechnung) einzutragen. Bei Arbeits- bzw. Freizeitausgleich bedarf es keiner Eintragung, da diese Zeit bereits durch die eingetragen Sollarbeitszeit berücksichtigt wird."]
[null,{"$f":"Daten!AC44","v":"Stand:"}]
[null,{"$f":"Daten!AC45","v":"2024-03-13"}]