{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","T"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Sheet1","index":0,"n_rows":27,"n_cols":27,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,21,2,22],[1,9,1,11],[1,12,1,13],[1,14,1,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:45:00","09:45:00","11:45:00"]
[null,null,null,null,null,null,null,null,null,"Overtid",null,null,"Lørdag",null,"Søndag"]
[null,null,null,null,null,null,null,null,null,"1-2 time","3-4 time","5- time","06-18","18-06","06-18","18-06",null,null,null,null,null,"TEST"]
[null,"Dag","Dato","Start","Slut","Start","Slut",1501,2301,2201,2203,2205,2213,2215,2223,2225,2312,7000,7010,null,null,null,null,null,null,"1-2 time","02:00:00"]
[null,{"$f":"TEXT(C5,\"ddd\")","v":"sø"},"2018-07-01","07:30:00","15:25:00","17:15:00","01:15:00",{"$f":"IF(OR(D5=\"\",E5=\"\"),\"\",((E5-D5)+(E5<D5))+((G5-F5)+(G5<F5)))","v":"15:55:00"},{"$f":"H5","v":"15:55:00"},{"$f":"IF(H5=\"\",0,IF(H5>$Y$1,IF(AND(H5>$Y$1,H5<$Z$1),H5-$Y$1,IF(H5>=$Z$1,$AA$4)),0))","v":"02:00:00"},{"$f":"IF(OR(D5=\"\",E5=\"\"),\"\",IF(H5>=$AA$1,$AA$5,IF(AND(H5>$Z$1,H5<$AA$1),H5-$Z$1,0)))","v":"02:00:00"},{"$f":"IF(OR(D5=\"\",E5=\"\"),\"\",IF(H5>$AA$1,H5-$AA$1,0))","v":"04:10:00"},{"$f":"IF(WEEKDAY(C5,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D5,Sheet1!E5)+ColTime(T!$A$1,T!$B$1,F5,G5),\"\")","v":""},{"$f":"IF(WEEKDAY(C5,2)=6,ColTime(T!$B$1,T!$A$1,D5,E5)+ColTime(T!$B$1,T!$A$1,F5,G5),\"\")","v":""},{"$f":"IF(WEEKDAY(C5,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D5,Sheet1!E5)+ColTime(T!$A$1,T!$B$1,F5,G5),\"\")","v":"08:40:00"},{"$f":"IF(WEEKDAY(C5,2)=7,ColTime(T!$B$1,T!$A$1,D5,E5)+ColTime(T!$B$1,T!$A$1,F5,G5),\"\")","v":"07:15:00"},null,null,null,null,{"$f":"WEEKDAY(C5,2)","v":7},{"$f":"J5+K5+L5","v":"08:10:00"},{"$f":"IF(H5=\"\",\"\",V5+$Y$1)","v":"15:55:00"},null,null,"3-4 time ","02:00:00"]
[null,{"$f":"TEXT(C6,\"ddd\")","v":"ma"},{"$f":"C5+1","v":"2018-07-02"},"07:00:00","14:45:00",null,null,"07:45:00",{"$f":"H6","v":"07:45:00"},{"$f":"IF(H6=\"\",0,IF(H6>$Y$1,IF(AND(H6>$Y$1,H6<$Z$1),H6-$Y$1,IF(H6>=$Z$1,$AA$4)),0))","v":"00:00:00"},{"$f":"IF(OR(D6=\"\",E6=\"\"),\"\",IF(H6>=$AA$1,$AA$5,IF(AND(H6>$Z$1,H6<$AA$1),H6-$Z$1,0)))","v":"00:00:00"},"00:00:00",{"$f":"IF(WEEKDAY(C6,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D6,Sheet1!E6)+ColTime(T!$A$1,T!$B$1,F6,G6),\"\")","v":""},{"$f":"IF(WEEKDAY(C6,2)=6,ColTime(T!$B$1,T!$A$1,D6,E6)+ColTime(T!$B$1,T!$A$1,F6,G6),\"\")","v":""},{"$f":"IF(WEEKDAY(C6,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D6,Sheet1!E6)+ColTime(T!$A$1,T!$B$1,F6,G6),\"\")","v":""},{"$f":"IF(WEEKDAY(C6,2)=7,ColTime(T!$B$1,T!$A$1,D6,E6)+ColTime(T!$B$1,T!$A$1,F6,G6),\"\")","v":""},null,null,null,null,{"$f":"WEEKDAY(C6,2)","v":1},{"$f":"J6+K6+L6","v":"00:00:00"},"07:45:00",null,null,"5-  time"]
[null,{"$f":"TEXT(C7,\"ddd\")","v":"ti"},{"$f":"C6+1","v":"2018-07-03"},"07:00:00","15:45:00",null,null,"08:45:00",{"$f":"H7","v":"08:45:00"},{"$f":"IF(H7=\"\",0,IF(H7>$Y$1,IF(AND(H7>$Y$1,H7<$Z$1),H7-$Y$1,IF(H7>=$Z$1,$AA$4)),0))","v":"01:00:00"},{"$f":"IF(OR(D7=\"\",E7=\"\"),\"\",IF(H7>=$AA$1,$AA$5,IF(AND(H7>$Z$1,H7<$AA$1),H7-$Z$1,0)))","v":"00:00:00"},"00:00:00",{"$f":"IF(WEEKDAY(C7,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D7,Sheet1!E7)+ColTime(T!$A$1,T!$B$1,F7,G7),\"\")","v":""},{"$f":"IF(WEEKDAY(C7,2)=6,ColTime(T!$B$1,T!$A$1,D7,E7)+ColTime(T!$B$1,T!$A$1,F7,G7),\"\")","v":""},{"$f":"IF(WEEKDAY(C7,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D7,Sheet1!E7)+ColTime(T!$A$1,T!$B$1,F7,G7),\"\")","v":""},{"$f":"IF(WEEKDAY(C7,2)=7,ColTime(T!$B$1,T!$A$1,D7,E7)+ColTime(T!$B$1,T!$A$1,F7,G7),\"\")","v":""},null,null,null,null,{"$f":"WEEKDAY(C7,2)","v":2},"01:00:00","08:45:00"]
[null,"on",{"$f":"C7+1","v":"2018-07-04"},"07:00:00","16:45:00",null,null,"09:45:00",{"$f":"H8","v":"09:45:00"},{"$f":"IF(H8=\"\",0,IF(H8>$Y$1,IF(AND(H8>$Y$1,H8<$Z$1),H8-$Y$1,IF(H8>=$Z$1,$AA$4)),0))","v":"02:00:00"},{"$f":"IF(OR(D8=\"\",E8=\"\"),\"\",IF(H8>=$AA$1,$AA$5,IF(AND(H8>$Z$1,H8<$AA$1),H8-$Z$1,0)))","v":"00:00:00"},{"$f":"IF(OR(D8=\"\",E8=\"\"),\"\",IF(H8>$AA$1,H8-$AA$1,0))","v":"00:00:00"},{"$f":"IF(WEEKDAY(C8,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D8,Sheet1!E8)+ColTime(T!$A$1,T!$B$1,F8,G8),\"\")","v":""},{"$f":"IF(WEEKDAY(C8,2)=6,ColTime(T!$B$1,T!$A$1,D8,E8)+ColTime(T!$B$1,T!$A$1,F8,G8),\"\")","v":""},{"$f":"IF(WEEKDAY(C8,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D8,Sheet1!E8)+ColTime(T!$A$1,T!$B$1,F8,G8),\"\")","v":""},{"$f":"IF(WEEKDAY(C8,2)=7,ColTime(T!$B$1,T!$A$1,D8,E8)+ColTime(T!$B$1,T!$A$1,F8,G8),\"\")","v":""},null,null,null,null,{"$f":"WEEKDAY(C8,2)","v":3},"02:00:00","09:45:00"]
[null,"to",{"$f":"C8+1","v":"2018-07-05"},"07:00:00","17:45:00",null,null,"10:45:00",{"$f":"H9","v":"10:45:00"},{"$f":"IF(H9=\"\",0,IF(H9>$Y$1,IF(AND(H9>$Y$1,H9<$Z$1),H9-$Y$1,IF(H9>=$Z$1,$AA$4)),0))","v":"02:00:00"},{"$f":"IF(OR(D9=\"\",E9=\"\"),\"\",IF(H9>=$AA$1,$AA$5,IF(AND(H9>$Z$1,H9<$AA$1),H9-$Z$1,0)))","v":"01:00:00"},{"$f":"IF(OR(D9=\"\",E9=\"\"),\"\",IF(H9>$AA$1,H9-$AA$1,0))","v":"00:00:00"},{"$f":"IF(WEEKDAY(C9,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D9,Sheet1!E9)+ColTime(T!$A$1,T!$B$1,F9,G9),\"\")","v":""},{"$f":"IF(WEEKDAY(C9,2)=6,ColTime(T!$B$1,T!$A$1,D9,E9)+ColTime(T!$B$1,T!$A$1,F9,G9),\"\")","v":""},{"$f":"IF(WEEKDAY(C9,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D9,Sheet1!E9)+ColTime(T!$A$1,T!$B$1,F9,G9),\"\")","v":""},{"$f":"IF(WEEKDAY(C9,2)=7,ColTime(T!$B$1,T!$A$1,D9,E9)+ColTime(T!$B$1,T!$A$1,F9,G9),\"\")","v":""},null,null,null,null,4,"03:00:00","10:45:00"]
[null,"fr","2018-07-06","07:00:00","18:45:00",null,null,{"$f":"IF(OR(D10=\"\",E10=\"\"),\"\",((E10-D10)+(E10<D10))+((G10-F10)+(G10<F10)))","v":"11:45:00"},{"$f":"H10","v":"11:45:00"},"02:00:00",{"$f":"IF(OR(D10=\"\",E10=\"\"),\"\",IF(H10>=$AA$1,$AA$5,IF(AND(H10>$Z$1,H10<$AA$1),H10-$Z$1,0)))","v":"02:00:00"},{"$f":"IF(OR(D10=\"\",E10=\"\"),\"\",IF(H10>$AA$1,H10-$AA$1,0))","v":"00:00:00"},{"$f":"IF(WEEKDAY(C10,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D10,Sheet1!E10)+ColTime(T!$A$1,T!$B$1,F10,G10),\"\")","v":""},{"$f":"IF(WEEKDAY(C10,2)=6,ColTime(T!$B$1,T!$A$1,D10,E10)+ColTime(T!$B$1,T!$A$1,F10,G10),\"\")","v":""},{"$f":"IF(WEEKDAY(C10,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D10,Sheet1!E10)+ColTime(T!$A$1,T!$B$1,F10,G10),\"\")","v":""},{"$f":"IF(WEEKDAY(C10,2)=7,ColTime(T!$B$1,T!$A$1,D10,E10)+ColTime(T!$B$1,T!$A$1,F10,G10),\"\")","v":""},null,null,null,null,5,"04:00:00","11:45:00"]
[null,"lø","2018-07-07","07:00:00","19:45:00",null,null,"12:45:00","12:45:00","02:00:00","02:00:00","01:00:00",{"$f":"IF(WEEKDAY(C11,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D11,Sheet1!E11)+ColTime(T!$A$1,T!$B$1,F11,G11),\"\")","v":"11:00:00"},{"$f":"IF(WEEKDAY(C11,2)=6,ColTime(T!$B$1,T!$A$1,D11,E11)+ColTime(T!$B$1,T!$A$1,F11,G11),\"\")","v":"01:45:00"},{"$f":"IF(WEEKDAY(C11,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D11,Sheet1!E11)+ColTime(T!$A$1,T!$B$1,F11,G11),\"\")","v":""},{"$f":"IF(WEEKDAY(C11,2)=7,ColTime(T!$B$1,T!$A$1,D11,E11)+ColTime(T!$B$1,T!$A$1,F11,G11),\"\")","v":""},null,null,null,null,6,{"$f":"J11+K11+L11","v":"05:00:00"},"12:45:00"]
[null,"sø","2018-07-08","07:00:00","20:45:00",null,null,"13:45:00","13:45:00","02:00:00","02:00:00","02:00:00",{"$f":"IF(WEEKDAY(C12,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D12,Sheet1!E12)+ColTime(T!$A$1,T!$B$1,F12,G12),\"\")","v":""},{"$f":"IF(WEEKDAY(C12,2)=6,ColTime(T!$B$1,T!$A$1,D12,E12)+ColTime(T!$B$1,T!$A$1,F12,G12),\"\")","v":""},{"$f":"IF(WEEKDAY(C12,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D12,Sheet1!E12)+ColTime(T!$A$1,T!$B$1,F12,G12),\"\")","v":"11:00:00"},{"$f":"IF(WEEKDAY(C12,2)=7,ColTime(T!$B$1,T!$A$1,D12,E12)+ColTime(T!$B$1,T!$A$1,F12,G12),\"\")","v":"02:45:00"},null,null,null,null,7,"06:00:00","13:45:00"]
[null,"ma","2018-07-09","07:00:00","21:45:00",null,null,"14:45:00","14:45:00","02:00:00","02:00:00","03:00:00",{"$f":"IF(WEEKDAY(C13,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D13,Sheet1!E13)+ColTime(T!$A$1,T!$B$1,F13,G13),\"\")","v":""},{"$f":"IF(WEEKDAY(C13,2)=6,ColTime(T!$B$1,T!$A$1,D13,E13)+ColTime(T!$B$1,T!$A$1,F13,G13),\"\")","v":""},{"$f":"IF(WEEKDAY(C13,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D13,Sheet1!E13)+ColTime(T!$A$1,T!$B$1,F13,G13),\"\")","v":""},{"$f":"IF(WEEKDAY(C13,2)=7,ColTime(T!$B$1,T!$A$1,D13,E13)+ColTime(T!$B$1,T!$A$1,F13,G13),\"\")","v":""},null,null,null,null,1,"07:00:00","14:45:00"]
[null,"ti","2018-07-10","07:00:00","14:45:00","18:00:00","23:15:00","13:00:00","13:00:00","02:00:00","02:00:00","01:15:00",{"$f":"IF(WEEKDAY(C14,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D14,Sheet1!E14)+ColTime(T!$A$1,T!$B$1,F14,G14),\"\")","v":""},{"$f":"IF(WEEKDAY(C14,2)=6,ColTime(T!$B$1,T!$A$1,D14,E14)+ColTime(T!$B$1,T!$A$1,F14,G14),\"\")","v":""},{"$f":"IF(WEEKDAY(C14,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D14,Sheet1!E14)+ColTime(T!$A$1,T!$B$1,F14,G14),\"\")","v":""},{"$f":"IF(WEEKDAY(C14,2)=7,ColTime(T!$B$1,T!$A$1,D14,E14)+ColTime(T!$B$1,T!$A$1,F14,G14),\"\")","v":""},null,null,null,null,2,"05:15:00","13:00:00"]
[null,"on","2018-07-11","07:00:00","15:45:00","18:00:00","21:00:00","11:45:00","11:45:00","02:00:00","02:00:00","00:00:00",{"$f":"IF(WEEKDAY(C15,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D15,Sheet1!E15)+ColTime(T!$A$1,T!$B$1,F15,G15),\"\")","v":""},{"$f":"IF(WEEKDAY(C15,2)=6,ColTime(T!$B$1,T!$A$1,D15,E15)+ColTime(T!$B$1,T!$A$1,F15,G15),\"\")","v":""},{"$f":"IF(WEEKDAY(C15,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D15,Sheet1!E15)+ColTime(T!$A$1,T!$B$1,F15,G15),\"\")","v":""},{"$f":"IF(WEEKDAY(C15,2)=7,ColTime(T!$B$1,T!$A$1,D15,E15)+ColTime(T!$B$1,T!$A$1,F15,G15),\"\")","v":""},null,null,null,null,3,"04:00:00","11:45:00"]
[null,"to","2018-07-12","07:00:00","16:00:00",null,null,{"$f":"IF(OR(D16=\"\",E16=\"\"),\"\",((E16-D16)+(E16<D16))+((G16-F16)+(G16<F16)))","v":"09:00:00"},"09:00:00","01:15:00",{"$f":"IF(OR(D16=\"\",E16=\"\"),0,IF(H16>=$AA$1,$AA$5,IF(AND(H16>$Z$1,H16<$AA$1),H16-$Z$1,0)))","v":"00:00:00"},{"$f":"IF(OR(D16=\"\",E16=\"\"),0,IF(H16>$AA$1,H16-$AA$1,0))","v":"00:00:00"},{"$f":"IF(WEEKDAY(C16,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D16,Sheet1!E16)+ColTime(T!$A$1,T!$B$1,F16,G16),\"\")","v":""},{"$f":"IF(WEEKDAY(C16,2)=6,ColTime(T!$B$1,T!$A$1,D16,E16)+ColTime(T!$B$1,T!$A$1,F16,G16),\"\")","v":""},{"$f":"IF(WEEKDAY(C16,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D16,Sheet1!E16)+ColTime(T!$A$1,T!$B$1,F16,G16),\"\")","v":""},{"$f":"IF(WEEKDAY(C16,2)=7,ColTime(T!$B$1,T!$A$1,D16,E16)+ColTime(T!$B$1,T!$A$1,F16,G16),\"\")","v":""},null,null,null,null,4,"01:15:00",{"$f":"IF(H16=\"\",\"\",V16+$Y$1)","v":"09:00:00"}]
[null,"fr","2018-07-13","07:00:00","16:15:00","20:45:00",1.0104166666666667,"12:45:00","12:45:00","02:00:00",{"$f":"IF(OR(D17=\"\",E17=\"\"),0,IF(H17>=$AA$1,$AA$5,IF(AND(H17>$Z$1,H17<$AA$1),H17-$Z$1,0)))","v":"02:00:00"},{"$f":"IF(OR(D17=\"\",E17=\"\"),0,IF(H17>$AA$1,H17-$AA$1,0))","v":"01:00:00"},{"$f":"IF(WEEKDAY(C17,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D17,Sheet1!E17)+ColTime(T!$A$1,T!$B$1,F17,G17),\"\")","v":""},{"$f":"IF(WEEKDAY(C17,2)=6,ColTime(T!$B$1,T!$A$1,D17,E17)+ColTime(T!$B$1,T!$A$1,F17,G17),\"\")","v":""},{"$f":"IF(WEEKDAY(C17,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D17,Sheet1!E17)+ColTime(T!$A$1,T!$B$1,F17,G17),\"\")","v":""},{"$f":"IF(WEEKDAY(C17,2)=7,ColTime(T!$B$1,T!$A$1,D17,E17)+ColTime(T!$B$1,T!$A$1,F17,G17),\"\")","v":""},null,null,null,null,5,"05:00:00",{"$f":"IF(H17=\"\",\"\",V17+$Y$1)","v":"12:45:00"}]
[null,"lø","2018-07-14","07:45:00","15:15:00",null,null,"07:30:00","07:30:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(WEEKDAY(C18,2)=6,ColTime(T!$A$1,T!$B$1,Sheet1!D18,Sheet1!E18)+ColTime(T!$A$1,T!$B$1,F18,G18),\"\")","v":"07:30:00"},{"$f":"IF(WEEKDAY(C18,2)=6,ColTime(T!$B$1,T!$A$1,D18,E18)+ColTime(T!$B$1,T!$A$1,F18,G18),\"\")","v":"00:00:00"},{"$f":"IF(WEEKDAY(C18,2)=7,ColTime(T!$A$1,T!$B$1,Sheet1!D18,Sheet1!E18)+ColTime(T!$A$1,T!$B$1,F18,G18),\"\")","v":""},{"$f":"IF(WEEKDAY(C18,2)=7,ColTime(T!$B$1,T!$A$1,D18,E18)+ColTime(T!$B$1,T!$A$1,F18,G18),\"\")","v":""},null,null,null,null,6,"00:00:00","07:45:00"]
[]
[]
[null,"Problem  : Der ønskes 2 mødetider på samme dag.( 03-07-2018)"]
[null,"Dette gøres ved at indsætte en ny række og der efter tilrette alt manuelt i arket for at få tal til at passe"]
[null,"Dette medfører a formler m.m. ødelægges. "]
[null,"Kunne en VBA løsning kigge på start/sluttid og udfylde resten af felterne. Dermed ville indsættelse af rækker ikke være et problem eller ?"]
[null,"Er der allerede nogen der har \"tryllet\" sådan en ?"]
[]
[null,"Arbejder på lørdag og søndag"]

{"sheet":"T","index":1,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["06:00:00","18:00:00"]