{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Løn for august","T"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Løn for august","index":0,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,2,9]]}
["Timeseddel"]
[]
[]
[]
["Medarbejders navn:",null,null,null,null,null,"Mobil:",null,"Mail:"]
[]
[]
["Perioden 21. Juli - 20. august 2019"]
[]
[]
["Arbejdstimer","Hviletid","Samlet Arbejdstimer","Overarbejde 1-3 timer","Overarbejde 3+","Tillæg kl. 18-23","Tillæg kl. 23-06","Helligdagstillæg","Sygdom","Ferie"]
[{"$f":"SUM(E16:E46)*24","v":39.900000000000006},{"$f":"SUM(D16:D46)*24","v":1.25},{"$f":"SUM(A12-B12)","v":38.650000000000006},{"$f":"SUM(F16:F46)*24","v":6.8999999999999986},{"$f":"SUM(G16:G46)*24","v":3},{"$f":"SUM(H16:H46)*24","v":5.0000000000000009},{"$f":"SUM(I16:I46)*24","v":13.999999999999998},{"$f":"SUM(J16:J46)*24","v":0}]
[]
[]
["Dato","Fra tid (tt:mm)","Til tid (tt:mm)","Hviletid (tt:mm)","Arbejdstimer (60/100 del)","Overarbejde 1-3 timer","Overarbejde 3+","Tillæg kl. 18-23","Tillæg kl. 23-06","Helligdagstillæg"]
["2019-07-21","07:00:00","15:24:00","00:30:00",{"$f":"C16-B16+(C16<B16)","v":"08:24:00"},{"$f":"IF(B16<>\"\",IF(E16>T!$B$4,T!$C$4,E16-T!$B$3),\"0:0\")","v":3.7500000000000033E-2},{"$f":"IF(E16>T!$B$4,E16-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!B7,T!C7,B16,C16)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B16,C16)","v":0}]
["2019-07-22","23:00:00","07:00:00",null,{"$f":"C17-B17+(C17<B17)","v":"08:00:00"},{"$f":"IF(B17<>\"\",IF(E17>T!$B$4,T!$C$4,E17-T!$B$3),\"0:0\")","v":2.0833333333333259E-2},{"$f":"IF(E17>T!$B$4,E17-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B17,C17)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B17,C17)","v":0.29166666666666663}]
["2019-07-23","15:30:00","01:30:00","00:45:00",{"$f":"C18-B18+(C18<B18)","v":"10:00:00"},{"$f":"IF(B18<>\"\",IF(E18>T!$B$4,T!$C$4,E18-T!$B$3),\"0:0\")","v":0.10416666666666663},{"$f":"IF(E18>T!$B$4,E18-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B18,C18)","v":0.20833333333333337},{"$f":"ColTime(T!$B$8,T!$C$8,B18,C18)","v":0.10416666666666663}]
["2019-07-24","01:30:00","15:00:00",null,"13:30:00",{"$f":"IF(B19<>\"\",IF(E19>T!$B$4,T!$C$4,E19-T!$B$3),\"0:0\")","v":0.125},{"$f":"IF(E19>T!$B$4,E19-T!$B$4,\"00:00\")","v":0.125},{"$f":"ColTime(T!$B$7,T!$C$7,B19,C19)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B19,C19)","v":0.1875}]
["2019-07-25",null,null,null,"00:00:00",{"$f":"IF(B20<>\"\",IF(E20>T!$B$4,T!$C$4,E20-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E20>T!$B$4,E20-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B20,C20)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B20,C20)","v":0}]
["2019-07-26",null,null,null,"00:00:00",{"$f":"IF(B21<>\"\",IF(E21>T!$B$4,T!$C$4,E21-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E21>T!$B$4,E21-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B21,C21)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B21,C21)","v":0}]
["2019-07-27",null,null,null,"00:00:00",{"$f":"IF(B22<>\"\",IF(E22>T!$B$4,T!$C$4,E22-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E22>T!$B$4,E22-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B22,C22)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B22,C22)","v":0}]
["2019-07-28",null,null,null,"00:00:00",{"$f":"IF(B23<>\"\",IF(E23>T!$B$4,T!$C$4,E23-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E23>T!$B$4,E23-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B23,C23)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B23,C23)","v":0}]
["2019-07-29",null,null,null,"00:00:00",{"$f":"IF(B24<>\"\",IF(E24>T!$B$4,T!$C$4,E24-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E24>T!$B$4,E24-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B24,C24)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B24,C24)","v":0}]
["2019-07-30",null,null,null,"00:00:00",{"$f":"IF(B25<>\"\",IF(E25>T!$B$4,T!$C$4,E25-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E25>T!$B$4,E25-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B25,C25)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B25,C25)","v":0}]
["2019-07-31",null,null,null,"00:00:00",{"$f":"IF(B26<>\"\",IF(E26>T!$B$4,T!$C$4,E26-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E26>T!$B$4,E26-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B26,C26)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B26,C26)","v":0}]
["2019-08-01",null,null,null,"00:00:00",{"$f":"IF(B27<>\"\",IF(E27>T!$B$4,T!$C$4,E27-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E27>T!$B$4,E27-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B27,C27)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B27,C27)","v":0}]
["2019-08-02",null,null,null,"00:00:00",{"$f":"IF(B28<>\"\",IF(E28>T!$B$4,T!$C$4,E28-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E28>T!$B$4,E28-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B28,C28)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B28,C28)","v":0}]
["2019-08-03",null,null,null,"00:00:00",{"$f":"IF(B29<>\"\",IF(E29>T!$B$4,T!$C$4,E29-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E29>T!$B$4,E29-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B29,C29)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B29,C29)","v":0}]
["2019-08-04",null,null,null,"00:00:00",{"$f":"IF(B30<>\"\",IF(E30>T!$B$4,T!$C$4,E30-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E30>T!$B$4,E30-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B30,C30)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B30,C30)","v":0}]
["2019-08-05",null,null,null,"00:00:00",{"$f":"IF(B31<>\"\",IF(E31>T!$B$4,T!$C$4,E31-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E31>T!$B$4,E31-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B31,C31)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B31,C31)","v":0}]
["2019-08-06",null,null,null,"00:00:00",{"$f":"IF(B32<>\"\",IF(E32>T!$B$4,T!$C$4,E32-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E32>T!$B$4,E32-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B32,C32)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B32,C32)","v":0}]
["2019-08-07",null,null,null,"00:00:00",{"$f":"IF(B33<>\"\",IF(E33>T!$B$4,T!$C$4,E33-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E33>T!$B$4,E33-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B33,C33)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B33,C33)","v":0}]
["2019-08-08",null,null,null,"00:00:00",{"$f":"IF(B34<>\"\",IF(E34>T!$B$4,T!$C$4,E34-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E34>T!$B$4,E34-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B34,C34)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B34,C34)","v":0}]
["2019-08-09",null,null,null,"00:00:00",{"$f":"IF(B35<>\"\",IF(E35>T!$B$4,T!$C$4,E35-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E35>T!$B$4,E35-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B35,C35)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B35,C35)","v":0}]
["2019-08-10",null,null,null,"00:00:00",{"$f":"IF(B36<>\"\",IF(E36>T!$B$4,T!$C$4,E36-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E36>T!$B$4,E36-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B36,C36)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B36,C36)","v":0}]
["2019-08-11",null,null,null,"00:00:00",{"$f":"IF(B37<>\"\",IF(E37>T!$B$4,T!$C$4,E37-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E37>T!$B$4,E37-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B37,C37)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B37,C37)","v":0}]
["2019-08-12",null,null,null,"00:00:00",{"$f":"IF(B38<>\"\",IF(E38>T!$B$4,T!$C$4,E38-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E38>T!$B$4,E38-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B38,C38)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B38,C38)","v":0}]
["2019-08-13",null,null,null,"00:00:00",{"$f":"IF(B39<>\"\",IF(E39>T!$B$4,T!$C$4,E39-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E39>T!$B$4,E39-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B39,C39)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B39,C39)","v":0}]
["2019-08-14",null,null,null,"00:00:00",{"$f":"IF(B40<>\"\",IF(E40>T!$B$4,T!$C$4,E40-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E40>T!$B$4,E40-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B40,C40)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B40,C40)","v":0}]
["2019-08-15",null,null,null,"00:00:00",{"$f":"IF(B41<>\"\",IF(E41>T!$B$4,T!$C$4,E41-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E41>T!$B$4,E41-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B41,C41)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B41,C41)","v":0}]
["2019-08-16",null,null,null,"00:00:00",{"$f":"IF(B42<>\"\",IF(E42>T!$B$4,T!$C$4,E42-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E42>T!$B$4,E42-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B42,C42)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B42,C42)","v":0}]
["2019-08-17",null,null,null,"00:00:00",{"$f":"IF(B43<>\"\",IF(E43>T!$B$4,T!$C$4,E43-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E43>T!$B$4,E43-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B43,C43)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B43,C43)","v":0}]
["2019-08-18",null,null,null,"00:00:00",{"$f":"IF(B44<>\"\",IF(E44>T!$B$4,T!$C$4,E44-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E44>T!$B$4,E44-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B44,C44)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B44,C44)","v":0}]
["2019-08-19",null,null,null,"00:00:00",{"$f":"IF(B45<>\"\",IF(E45>T!$B$4,T!$C$4,E45-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E45>T!$B$4,E45-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B45,C45)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B45,C45)","v":0}]
["2019-08-20",null,null,null,"00:00:00",{"$f":"IF(B46<>\"\",IF(E46>T!$B$4,T!$C$4,E46-T!$B$3),\"0:0\")","v":"0:0"},{"$f":"IF(E46>T!$B$4,E46-T!$B$4,\"00:00\")","v":"00:00"},{"$f":"ColTime(T!$B$7,T!$C$7,B46,C46)","v":0},{"$f":"ColTime(T!$B$8,T!$C$8,B46,C46)","v":0}]

{"sheet":"T","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Arbejdsdag beregnede til","07:30:00"]
["Overarbejde 1-3","10:30:00","03:00:00"]
[]
[]
["Aftentillæg","18:00:00","23:00:00"]
["Nattillæg","23:00:00","06:00:00"]