{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Original","T","Løn data","Original (2)","Ark2"],"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":"Original","index":0,"n_rows":110,"n_cols":20,"rows_kept":110,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,19],[2,1,6,2],[2,3,6,19],[8,0,12,0],[8,12,12,12],[8,13,12,13],[8,14,12,14],[8,15,12,15],[8,16,12,16],[8,17,12,17],[8,18,12,18],[8,19,12,19],[13,0,17,0],[13,12,17,12],[13,13,17,13],[13,14,17,14],[13,15,17,15],[13,16,17,16],[13,17,17,17],[13,18,17,18],[13,19,17,19],[18,0,22,0],[18,12,22,12],[18,13,22,13],[18,14,22,14],[18,15,22,15],[18,16,22,16],[18,17,22,17],[18,18,22,18],[18,19,22,19],[23,0,27,0],[23,12,27,12],[23,13,27,13],[23,14,27,14],[23,15,27,15],[23,16,27,16],[23,17,27,17],[23,18,27,18],[23,19,27,19],[28,17,32,17],[28,18,32,18],[28,19,32,19],[33,0,37,0],[33,12,37,12],[33,13,37,13],[33,14,37,14],[33,15,37,15],[33,16,37,16],[33,17,37,17],[28,0,32,0],[28,12,32,12],[28,13,32,13],[28,14,32,14],[28,15,32,15],[28,16,32,16],[33,18,37,18],[33,19,37,19],[38,0,42,0],[38,12,42,12],[38,13,42,13],[38,14,42,14],[38,15,42,15],[38,16,42,16],[38,17,42,17],[38,18,42,18],[38,19,42,19],[46,1,46,2],[46,3,46,19],[47,1,51,2],[47,3,51,19],[53,0,57,0],[53,12,57,12],[53,13,57,13],[53,14,57,14],[53,15,57,15],[53,16,57,16],[53,17,57,17],[53,18,57,18],[53,19,57,19],[58,0,62,0],[58,12,62,12],[58,13,62,13],[58,14,62,14],[58,15,62,15],[58,16,62,16],[58,17,62,17],[58,18,62,18],[58,19,62,19],[63,0,67,0],[63,12,67,12],[63,13,67,13],[63,14,67,14],[63,15,67,15],[63,16,67,16],[63,17,67,17],[63,18,67,18],[63,19,67,19],[68,0,72,0],[68,12,72,12],[68,13,72,13],[68,14,72,14],[68,15,72,15],[68,16,72,16],[68,17,72,17],[68,18,72,18],[68,19,72,19],[73,0,77,0],[73,12,77,12],[73,13,77,13],[73,14,77,14],[73,15,77,15],[73,16,77,16],[73,17,77,17],[73,18,77,18],[73,19,77,19],[83,19,87,19],[91,2,91,3],[94,2,94,3],[97,2,97,3],[98,2,98,3],[78,17,82,17],[78,18,82,18],[78,19,82,19],[83,0,87,0],[83,12,87,12],[83,13,87,13],[83,14,87,14],[83,15,87,15],[83,16,87,16],[83,17,87,17],[78,0,82,0],[78,12,82,12],[78,13,82,13],[78,14,82,14],[78,15,82,15],[78,16,82,16],[105,2,105,3],[109,2,110,5],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[83,18,87,18],[109,7,109,9]]}
[]
[null,"Uge nr.",null,"Navn"]
[]
[]
[]
[]
[]
[null,null,"Starttid              06:00","Sluttid               20:00","Forbrugt tid","Starttid                   20:00","Sluttid                  06:00","Forbrugt tid\n20:00 - 06:00","Starttid                        06:00","Sluttid                          20:00","Forbrugt tid","Udført arbejde/vagt nr.","Døgn","Afgang","Slut","Døgn/Timer","Vend ski","Diæt","Tærepenge","Tærepenge timer"]
["2024-02-12","Mandag",0.75,8.3333333333333329E-2,{"$f":"D9-C9+(D9<C9)","v":0.33333333333333337},null,null,{"$f":"ColTime(C9,D9,T!A1,T!B1)","v":0.24999999999999994},null,null,{"$f":"J9-I9+(J9<I9)","v":0}]
[null,null,null,null,{"$f":"D10-C10+(D10<C10)","v":0},null,null,{"$f":"ColTime(C10,D10,T!A2,T!B2)","v":0},0.29166666666666669,0.625,{"$f":"J10-I10+(J10<I10)","v":0.33333333333333331}]
[null,null,null,null,0,null,null,{"$f":"ColTime(C11,D11,T!A3,T!B3)","v":0},null,null,{"$f":"IF(OR(I11=\"\",J11=\"\"),0,IF(VALUE(I11)>=VALUE(J11),(TIME(TRUNC(J11/100),MOD(J11,100),0))+1-(TIME(TRUNC(I11/100),MOD(I11,100),0)),(TIME(TRUNC(J11/100),MOD(J11,100),0))-(TIME(TRUNC(I11/100),MOD(I11,100),0))))","v":0}]
[null,null,null,null,0,null,null,{"$f":"ColTime(C12,D12,T!A4,T!B4)","v":0},null,null,0]
[null,"Sammenlagt",null,{"$f":"E9+E10+E11+E12","v":"08:00:00"},{"$f":"E9+E10+E11+E12","v":0.33333333333333337},null,{"$f":"H9+H10+H11+H12","v":"06:00:00"},{"$f":"H9+H10+H11+H12","v":0.24999999999999994},null,{"$f":"K9+K10+K11+K12","v":"08:00:00"},{"$f":"K9+K10+K11+K12","v":0.33333333333333331}]
[{"$f":"A9+1","v":"2024-02-13"},"Tirsdag",null,null,{"$f":"IF(OR(C14=\"\",D14=\"\"),0,IF(VALUE(C14)>=VALUE(D14),(TIME(TRUNC(D14/100),MOD(D14,100),0))+1-(TIME(TRUNC(C14/100),MOD(C14,100),0)),(TIME(TRUNC(D14/100),MOD(D14,100),0))-(TIME(TRUNC(C14/100),MOD(C14,100),0))))","v":0},null,null,{"$f":"IF(OR(F14=\"\",G14=\"\"),0,IF(VALUE(F14)>=VALUE(G14),(TIME(TRUNC(G14/100),MOD(G14,100),0))+1-(TIME(TRUNC(F14/100),MOD(F14,100),0)),(TIME(TRUNC(G14/100),MOD(G14,100),0))-(TIME(TRUNC(F14/100),MOD(F14,100),0))))","v":0},null,null,{"$f":"IF(OR(I14=\"\",J14=\"\"),0,IF(VALUE(I14)>=VALUE(J14),(TIME(TRUNC(J14/100),MOD(J14,100),0))+1-(TIME(TRUNC(I14/100),MOD(I14,100),0)),(TIME(TRUNC(J14/100),MOD(J14,100),0))-(TIME(TRUNC(I14/100),MOD(I14,100),0))))","v":0}]
[null,null,null,null,{"$f":"IF(OR(C15=\"\",D15=\"\"),0,IF(VALUE(C15)>=VALUE(D15),(TIME(TRUNC(D15/100),MOD(D15,100),0))+1-(TIME(TRUNC(C15/100),MOD(C15,100),0)),(TIME(TRUNC(D15/100),MOD(D15,100),0))-(TIME(TRUNC(C15/100),MOD(C15,100),0))))","v":0},null,null,{"$f":"IF(OR(F15=\"\",G15=\"\"),0,IF(VALUE(F15)>=VALUE(G15),(TIME(TRUNC(G15/100),MOD(G15,100),0))+1-(TIME(TRUNC(F15/100),MOD(F15,100),0)),(TIME(TRUNC(G15/100),MOD(G15,100),0))-(TIME(TRUNC(F15/100),MOD(F15,100),0))))","v":0},null,null,{"$f":"IF(OR(I15=\"\",J15=\"\"),0,IF(VALUE(I15)>=VALUE(J15),(TIME(TRUNC(J15/100),MOD(J15,100),0))+1-(TIME(TRUNC(I15/100),MOD(I15,100),0)),(TIME(TRUNC(J15/100),MOD(J15,100),0))-(TIME(TRUNC(I15/100),MOD(I15,100),0))))","v":0}]
[null,null,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0]
[null,"Sammenlagt",null,{"$f":"E14+E15+E16+E17","v":"00:00:00"},{"$f":"E14+E15+E16+E17","v":0},null,{"$f":"H14+H15+H16+H17","v":"00:00:00"},{"$f":"H14+H15+H16+H17","v":0},null,{"$f":"K14+K15+K16+K17","v":"00:00:00"},{"$f":"K14+K15+K16+K17","v":0}]
[{"$f":"A14+1","v":"2024-02-14"},"Onsdag",0,2400,{"$f":"IF(OR(C19=\"\",D19=\"\"),0,IF(VALUE(C19)>=VALUE(D19),(TIME(TRUNC(D19/100),MOD(D19,100),0))+1-(TIME(TRUNC(C19/100),MOD(C19,100),0)),(TIME(TRUNC(D19/100),MOD(D19,100),0))-(TIME(TRUNC(C19/100),MOD(C19,100),0))))","v":0},0,2400,{"$f":"IF(OR(F19=\"\",G19=\"\"),0,IF(VALUE(F19)>=VALUE(G19),(TIME(TRUNC(G19/100),MOD(G19,100),0))+1-(TIME(TRUNC(F19/100),MOD(F19,100),0)),(TIME(TRUNC(G19/100),MOD(G19,100),0))-(TIME(TRUNC(F19/100),MOD(F19,100),0))))","v":0},null,null,{"$f":"IF(OR(I19=\"\",J19=\"\"),0,IF(VALUE(I19)>=VALUE(J19),(TIME(TRUNC(J19/100),MOD(J19,100),0))+1-(TIME(TRUNC(I19/100),MOD(I19,100),0)),(TIME(TRUNC(J19/100),MOD(J19,100),0))-(TIME(TRUNC(I19/100),MOD(I19,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C20=\"\",D20=\"\"),0,IF(VALUE(C20)>=VALUE(D20),(TIME(TRUNC(D20/100),MOD(D20,100),0))+1-(TIME(TRUNC(C20/100),MOD(C20,100),0)),(TIME(TRUNC(D20/100),MOD(D20,100),0))-(TIME(TRUNC(C20/100),MOD(C20,100),0))))","v":0},0,2400,{"$f":"IF(OR(F20=\"\",G20=\"\"),0,IF(VALUE(F20)>=VALUE(G20),(TIME(TRUNC(G20/100),MOD(G20,100),0))+1-(TIME(TRUNC(F20/100),MOD(F20,100),0)),(TIME(TRUNC(G20/100),MOD(G20,100),0))-(TIME(TRUNC(F20/100),MOD(F20,100),0))))","v":0},null,null,{"$f":"IF(OR(I20=\"\",J20=\"\"),0,IF(VALUE(I20)>=VALUE(J20),(TIME(TRUNC(J20/100),MOD(J20,100),0))+1-(TIME(TRUNC(I20/100),MOD(I20,100),0)),(TIME(TRUNC(J20/100),MOD(J20,100),0))-(TIME(TRUNC(I20/100),MOD(I20,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,null,null,0]
[null,null,0,2400,0,0,2400,0,null,null,0]
[null,"Sammenlagt",null,{"$f":"E19+E20+E21+E22","v":"00:00:00"},{"$f":"E19+E20+E21+E22","v":0},null,{"$f":"H19+H20+H21+H22","v":"00:00:00"},{"$f":"H19+H20+H21+H22","v":0},null,{"$f":"K19+K20+K21+K22","v":"00:00:00"},{"$f":"K19+K20+K21+K22","v":0}]
[{"$f":"A19+1","v":"2024-02-15"},"Torsdag",0,2400,{"$f":"IF(OR(C24=\"\",D24=\"\"),0,IF(VALUE(C24)>=VALUE(D24),(TIME(TRUNC(D24/100),MOD(D24,100),0))+1-(TIME(TRUNC(C24/100),MOD(C24,100),0)),(TIME(TRUNC(D24/100),MOD(D24,100),0))-(TIME(TRUNC(C24/100),MOD(C24,100),0))))","v":0},0,2400,{"$f":"IF(OR(F24=\"\",G24=\"\"),0,IF(VALUE(F24)>=VALUE(G24),(TIME(TRUNC(G24/100),MOD(G24,100),0))+1-(TIME(TRUNC(F24/100),MOD(F24,100),0)),(TIME(TRUNC(G24/100),MOD(G24,100),0))-(TIME(TRUNC(F24/100),MOD(F24,100),0))))","v":0},null,null,{"$f":"IF(OR(I24=\"\",J24=\"\"),0,IF(VALUE(I24)>=VALUE(J24),(TIME(TRUNC(J24/100),MOD(J24,100),0))+1-(TIME(TRUNC(I24/100),MOD(I24,100),0)),(TIME(TRUNC(J24/100),MOD(J24,100),0))-(TIME(TRUNC(I24/100),MOD(I24,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C25=\"\",D25=\"\"),0,IF(VALUE(C25)>=VALUE(D25),(TIME(TRUNC(D25/100),MOD(D25,100),0))+1-(TIME(TRUNC(C25/100),MOD(C25,100),0)),(TIME(TRUNC(D25/100),MOD(D25,100),0))-(TIME(TRUNC(C25/100),MOD(C25,100),0))))","v":0},0,2400,{"$f":"IF(OR(F25=\"\",G25=\"\"),0,IF(VALUE(F25)>=VALUE(G25),(TIME(TRUNC(G25/100),MOD(G25,100),0))+1-(TIME(TRUNC(F25/100),MOD(F25,100),0)),(TIME(TRUNC(G25/100),MOD(G25,100),0))-(TIME(TRUNC(F25/100),MOD(F25,100),0))))","v":0},null,null,{"$f":"IF(OR(I25=\"\",J25=\"\"),0,IF(VALUE(I25)>=VALUE(J25),(TIME(TRUNC(J25/100),MOD(J25,100),0))+1-(TIME(TRUNC(I25/100),MOD(I25,100),0)),(TIME(TRUNC(J25/100),MOD(J25,100),0))-(TIME(TRUNC(I25/100),MOD(I25,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,null,null,0]
[null,null,0,2400,0,0,2400,0,null,null,0]
[null,"Sammenlagt",null,{"$f":"E24+E25+E26+E27","v":"00:00:00"},{"$f":"E24+E25+E26+E27","v":0},null,{"$f":"H24+H25+H26+H27","v":"00:00:00"},{"$f":"H24+H25+H26+H27","v":0},null,{"$f":"K24+K25+K26+K27","v":"00:00:00"},{"$f":"K24+K25+K26+K27","v":0}]
[{"$f":"A24+1","v":"2024-02-16"},"Fredag",0,2400,{"$f":"IF(OR(C29=\"\",D29=\"\"),0,IF(VALUE(C29)>=VALUE(D29),(TIME(TRUNC(D29/100),MOD(D29,100),0))+1-(TIME(TRUNC(C29/100),MOD(C29,100),0)),(TIME(TRUNC(D29/100),MOD(D29,100),0))-(TIME(TRUNC(C29/100),MOD(C29,100),0))))","v":0},0,2400,{"$f":"IF(OR(F29=\"\",G29=\"\"),0,IF(VALUE(F29)>=VALUE(G29),(TIME(TRUNC(G29/100),MOD(G29,100),0))+1-(TIME(TRUNC(F29/100),MOD(F29,100),0)),(TIME(TRUNC(G29/100),MOD(G29,100),0))-(TIME(TRUNC(F29/100),MOD(F29,100),0))))","v":0},0,2400,{"$f":"IF(OR(I29=\"\",J29=\"\"),0,IF(VALUE(I29)>=VALUE(J29),(TIME(TRUNC(J29/100),MOD(J29,100),0))+1-(TIME(TRUNC(I29/100),MOD(I29,100),0)),(TIME(TRUNC(J29/100),MOD(J29,100),0))-(TIME(TRUNC(I29/100),MOD(I29,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C30=\"\",D30=\"\"),0,IF(VALUE(C30)>=VALUE(D30),(TIME(TRUNC(D30/100),MOD(D30,100),0))+1-(TIME(TRUNC(C30/100),MOD(C30,100),0)),(TIME(TRUNC(D30/100),MOD(D30,100),0))-(TIME(TRUNC(C30/100),MOD(C30,100),0))))","v":0},0,2400,{"$f":"IF(OR(F30=\"\",G30=\"\"),0,IF(VALUE(F30)>=VALUE(G30),(TIME(TRUNC(G30/100),MOD(G30,100),0))+1-(TIME(TRUNC(F30/100),MOD(F30,100),0)),(TIME(TRUNC(G30/100),MOD(G30,100),0))-(TIME(TRUNC(F30/100),MOD(F30,100),0))))","v":0},0,2400,{"$f":"IF(OR(I30=\"\",J30=\"\"),0,IF(VALUE(I30)>=VALUE(J30),(TIME(TRUNC(J30/100),MOD(J30,100),0))+1-(TIME(TRUNC(I30/100),MOD(I30,100),0)),(TIME(TRUNC(J30/100),MOD(J30,100),0))-(TIME(TRUNC(I30/100),MOD(I30,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E29+E30+E31+E32","v":"00:00:00"},{"$f":"E29+E30+E31+E32","v":0},null,{"$f":"H29+H30+H31+H32","v":"00:00:00"},{"$f":"H29+H30+H31+H32","v":0},null,{"$f":"K29+K30+K31+K32","v":"00:00:00"},{"$f":"K29+K30+K31+K32","v":0}]
[{"$f":"A29+1","v":"2024-02-17"},"Lørdag",0,2400,{"$f":"IF(OR(C34=\"\",D34=\"\"),0,IF(VALUE(C34)>=VALUE(D34),(TIME(TRUNC(D34/100),MOD(D34,100),0))+1-(TIME(TRUNC(C34/100),MOD(C34,100),0)),(TIME(TRUNC(D34/100),MOD(D34,100),0))-(TIME(TRUNC(C34/100),MOD(C34,100),0))))","v":0},0,2400,{"$f":"IF(OR(F34=\"\",G34=\"\"),0,IF(VALUE(F34)>=VALUE(G34),(TIME(TRUNC(G34/100),MOD(G34,100),0))+1-(TIME(TRUNC(F34/100),MOD(F34,100),0)),(TIME(TRUNC(G34/100),MOD(G34,100),0))-(TIME(TRUNC(F34/100),MOD(F34,100),0))))","v":0},0,2400,{"$f":"IF(OR(I34=\"\",J34=\"\"),0,IF(VALUE(I34)>=VALUE(J34),(TIME(TRUNC(J34/100),MOD(J34,100),0))+1-(TIME(TRUNC(I34/100),MOD(I34,100),0)),(TIME(TRUNC(J34/100),MOD(J34,100),0))-(TIME(TRUNC(I34/100),MOD(I34,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C35=\"\",D35=\"\"),0,IF(VALUE(C35)>=VALUE(D35),(TIME(TRUNC(D35/100),MOD(D35,100),0))+1-(TIME(TRUNC(C35/100),MOD(C35,100),0)),(TIME(TRUNC(D35/100),MOD(D35,100),0))-(TIME(TRUNC(C35/100),MOD(C35,100),0))))","v":0},0,2400,{"$f":"IF(OR(F35=\"\",G35=\"\"),0,IF(VALUE(F35)>=VALUE(G35),(TIME(TRUNC(G35/100),MOD(G35,100),0))+1-(TIME(TRUNC(F35/100),MOD(F35,100),0)),(TIME(TRUNC(G35/100),MOD(G35,100),0))-(TIME(TRUNC(F35/100),MOD(F35,100),0))))","v":0},0,2400,{"$f":"IF(OR(I35=\"\",J35=\"\"),0,IF(VALUE(I35)>=VALUE(J35),(TIME(TRUNC(J35/100),MOD(J35,100),0))+1-(TIME(TRUNC(I35/100),MOD(I35,100),0)),(TIME(TRUNC(J35/100),MOD(J35,100),0))-(TIME(TRUNC(I35/100),MOD(I35,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E34+E35+E36+E37","v":"00:00:00"},{"$f":"E34+E35+E36+E37","v":0},null,{"$f":"H34+H35+H36+H37","v":"00:00:00"},{"$f":"H34+H35+H36+H37","v":0},null,{"$f":"K34+K35+K36+K37","v":"00:00:00"},{"$f":"K34+K35+K36+K37","v":0}]
[{"$f":"A34+1","v":"2024-02-18"},"Søndag",0,2400,{"$f":"IF(OR(C39=\"\",D39=\"\"),0,IF(VALUE(C39)>=VALUE(D39),(TIME(TRUNC(D39/100),MOD(D39,100),0))+1-(TIME(TRUNC(C39/100),MOD(C39,100),0)),(TIME(TRUNC(D39/100),MOD(D39,100),0))-(TIME(TRUNC(C39/100),MOD(C39,100),0))))","v":0},0,2400,{"$f":"IF(OR(F39=\"\",G39=\"\"),0,IF(VALUE(F39)>=VALUE(G39),(TIME(TRUNC(G39/100),MOD(G39,100),0))+1-(TIME(TRUNC(F39/100),MOD(F39,100),0)),(TIME(TRUNC(G39/100),MOD(G39,100),0))-(TIME(TRUNC(F39/100),MOD(F39,100),0))))","v":0},0,2400,{"$f":"IF(OR(I39=\"\",J39=\"\"),0,IF(VALUE(I39)>=VALUE(J39),(TIME(TRUNC(J39/100),MOD(J39,100),0))+1-(TIME(TRUNC(I39/100),MOD(I39,100),0)),(TIME(TRUNC(J39/100),MOD(J39,100),0))-(TIME(TRUNC(I39/100),MOD(I39,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C40=\"\",D40=\"\"),0,IF(VALUE(C40)>=VALUE(D40),(TIME(TRUNC(D40/100),MOD(D40,100),0))+1-(TIME(TRUNC(C40/100),MOD(C40,100),0)),(TIME(TRUNC(D40/100),MOD(D40,100),0))-(TIME(TRUNC(C40/100),MOD(C40,100),0))))","v":0},0,2400,{"$f":"IF(OR(F40=\"\",G40=\"\"),0,IF(VALUE(F40)>=VALUE(G40),(TIME(TRUNC(G40/100),MOD(G40,100),0))+1-(TIME(TRUNC(F40/100),MOD(F40,100),0)),(TIME(TRUNC(G40/100),MOD(G40,100),0))-(TIME(TRUNC(F40/100),MOD(F40,100),0))))","v":0},0,2400,{"$f":"IF(OR(I40=\"\",J40=\"\"),0,IF(VALUE(I40)>=VALUE(J40),(TIME(TRUNC(J40/100),MOD(J40,100),0))+1-(TIME(TRUNC(I40/100),MOD(I40,100),0)),(TIME(TRUNC(J40/100),MOD(J40,100),0))-(TIME(TRUNC(I40/100),MOD(I40,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E39+E40+E41+E42","v":"00:00:00"},{"$f":"E39+E40+E41+E42","v":0},null,{"$f":"H39+H40+H41+H42","v":"00:00:00"},{"$f":"H39+H40+H41+H42","v":0},null,{"$f":"K39+K40+K41+K42","v":"00:00:00"},{"$f":"K39+K40+K41+K42","v":0}]
[null,null,null,"Sum timer",{"$f":"(E13+E18+E23+E28+E33+E38+E43)*24","v":8},null,"Sum timer",{"$f":"(H13+H18+H23+H28+H33+H38+H43)*24","v":5.9999999999999982},null,"Sum timer",{"$f":"(K13+K18+K23+K28+K33+K38+K43)*24","v":8},null,{"$f":"SUM(M9:M43)","v":0},null,null,{"$f":"SUM(P9:P43)","v":0},{"$f":"SUM(Q9:Q43)","v":0},{"$f":"SUM(R9:R43)","v":0},{"$f":"SUM(S9:S43)","v":0},{"$f":"SUM(T9:T43)","v":0}]
[]
[]
[null,"Uge nr.",null,"Navn"]
[]
[]
[]
[]
[]
[null,null,"Starttid               06:00","Sluttid                20:00","Forbrugt tid","Starttid              20:00","Sluttid                         06:00","Forbrugt tid","Starttid                06:00","Sluttid                  20:00","Forbrugt tid","Udført arbejde/vagt nr.","Døgn","Afgang","Slut","Døgn/Timer","Vend ski","Diæt","Tærepenge","Tærepenge timer"]
["2024-02-19","Mandag",0,2400,{"$f":"IF(OR(C54=\"\",D54=\"\"),0,IF(VALUE(C54)>=VALUE(D54),(TIME(TRUNC(D54/100),MOD(D54,100),0))+1-(TIME(TRUNC(C54/100),MOD(C54,100),0)),(TIME(TRUNC(D54/100),MOD(D54,100),0))-(TIME(TRUNC(C54/100),MOD(C54,100),0))))","v":0},null,null,{"$f":"IF(OR(F54=\"\",G54=\"\"),0,IF(VALUE(F54)>=VALUE(G54),(TIME(TRUNC(G54/100),MOD(G54,100),0))+1-(TIME(TRUNC(F54/100),MOD(F54,100),0)),(TIME(TRUNC(G54/100),MOD(G54,100),0))-(TIME(TRUNC(F54/100),MOD(F54,100),0))))","v":0},0,2400,{"$f":"IF(OR(I54=\"\",J54=\"\"),0,IF(VALUE(I54)>=VALUE(J54),(TIME(TRUNC(J54/100),MOD(J54,100),0))+1-(TIME(TRUNC(I54/100),MOD(I54,100),0)),(TIME(TRUNC(J54/100),MOD(J54,100),0))-(TIME(TRUNC(I54/100),MOD(I54,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C55=\"\",D55=\"\"),0,IF(VALUE(C55)>=VALUE(D55),(TIME(TRUNC(D55/100),MOD(D55,100),0))+1-(TIME(TRUNC(C55/100),MOD(C55,100),0)),(TIME(TRUNC(D55/100),MOD(D55,100),0))-(TIME(TRUNC(C55/100),MOD(C55,100),0))))","v":0},null,null,{"$f":"IF(OR(F55=\"\",G55=\"\"),0,IF(VALUE(F55)>=VALUE(G55),(TIME(TRUNC(G55/100),MOD(G55,100),0))+1-(TIME(TRUNC(F55/100),MOD(F55,100),0)),(TIME(TRUNC(G55/100),MOD(G55,100),0))-(TIME(TRUNC(F55/100),MOD(F55,100),0))))","v":0},0,2400,{"$f":"IF(OR(I55=\"\",J55=\"\"),0,IF(VALUE(I55)>=VALUE(J55),(TIME(TRUNC(J55/100),MOD(J55,100),0))+1-(TIME(TRUNC(I55/100),MOD(I55,100),0)),(TIME(TRUNC(J55/100),MOD(J55,100),0))-(TIME(TRUNC(I55/100),MOD(I55,100),0))))","v":0}]
[null,null,0,2400,0,null,null,0,0,2400,0]
[null,null,0,2400,0,null,null,0,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E54+E55+E56+E57","v":"00:00:00"},{"$f":"E54+E55+E56+E57","v":0},null,{"$f":"H54+H55+H56+H57","v":"00:00:00"},{"$f":"H54+H55+H56+H57","v":0},null,{"$f":"K54+K55+K56+K57","v":"00:00:00"},{"$f":"K54+K55+K56+K57","v":0}]
[{"$f":"A54+1","v":"2024-02-20"},"Tirsdag",0,2400,{"$f":"IF(OR(C59=\"\",D59=\"\"),0,IF(VALUE(C59)>=VALUE(D59),(TIME(TRUNC(D59/100),MOD(D59,100),0))+1-(TIME(TRUNC(C59/100),MOD(C59,100),0)),(TIME(TRUNC(D59/100),MOD(D59,100),0))-(TIME(TRUNC(C59/100),MOD(C59,100),0))))","v":0},0,2400,{"$f":"IF(OR(F59=\"\",G59=\"\"),0,IF(VALUE(F59)>=VALUE(G59),(TIME(TRUNC(G59/100),MOD(G59,100),0))+1-(TIME(TRUNC(F59/100),MOD(F59,100),0)),(TIME(TRUNC(G59/100),MOD(G59,100),0))-(TIME(TRUNC(F59/100),MOD(F59,100),0))))","v":0},0,2400,{"$f":"IF(OR(I59=\"\",J59=\"\"),0,IF(VALUE(I59)>=VALUE(J59),(TIME(TRUNC(J59/100),MOD(J59,100),0))+1-(TIME(TRUNC(I59/100),MOD(I59,100),0)),(TIME(TRUNC(J59/100),MOD(J59,100),0))-(TIME(TRUNC(I59/100),MOD(I59,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C60=\"\",D60=\"\"),0,IF(VALUE(C60)>=VALUE(D60),(TIME(TRUNC(D60/100),MOD(D60,100),0))+1-(TIME(TRUNC(C60/100),MOD(C60,100),0)),(TIME(TRUNC(D60/100),MOD(D60,100),0))-(TIME(TRUNC(C60/100),MOD(C60,100),0))))","v":0},0,2400,{"$f":"IF(OR(F60=\"\",G60=\"\"),0,IF(VALUE(F60)>=VALUE(G60),(TIME(TRUNC(G60/100),MOD(G60,100),0))+1-(TIME(TRUNC(F60/100),MOD(F60,100),0)),(TIME(TRUNC(G60/100),MOD(G60,100),0))-(TIME(TRUNC(F60/100),MOD(F60,100),0))))","v":0},0,2400,{"$f":"IF(OR(I60=\"\",J60=\"\"),0,IF(VALUE(I60)>=VALUE(J60),(TIME(TRUNC(J60/100),MOD(J60,100),0))+1-(TIME(TRUNC(I60/100),MOD(I60,100),0)),(TIME(TRUNC(J60/100),MOD(J60,100),0))-(TIME(TRUNC(I60/100),MOD(I60,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E59+E60+E61+E62","v":"00:00:00"},{"$f":"E59+E60+E61+E62","v":0},null,{"$f":"H59+H60+H61+H62","v":"00:00:00"},{"$f":"H59+H60+H61+H62","v":0},null,{"$f":"K59+K60+K61+K62","v":"00:00:00"},{"$f":"K59+K60+K61+K62","v":0}]
[{"$f":"A59+1","v":"2024-02-21"},"Onsdag",0,2400,{"$f":"IF(OR(C64=\"\",D64=\"\"),0,IF(VALUE(C64)>=VALUE(D64),(TIME(TRUNC(D64/100),MOD(D64,100),0))+1-(TIME(TRUNC(C64/100),MOD(C64,100),0)),(TIME(TRUNC(D64/100),MOD(D64,100),0))-(TIME(TRUNC(C64/100),MOD(C64,100),0))))","v":0},0,2400,{"$f":"IF(OR(F64=\"\",G64=\"\"),0,IF(VALUE(F64)>=VALUE(G64),(TIME(TRUNC(G64/100),MOD(G64,100),0))+1-(TIME(TRUNC(F64/100),MOD(F64,100),0)),(TIME(TRUNC(G64/100),MOD(G64,100),0))-(TIME(TRUNC(F64/100),MOD(F64,100),0))))","v":0},0,2400,{"$f":"IF(OR(I64=\"\",J64=\"\"),0,IF(VALUE(I64)>=VALUE(J64),(TIME(TRUNC(J64/100),MOD(J64,100),0))+1-(TIME(TRUNC(I64/100),MOD(I64,100),0)),(TIME(TRUNC(J64/100),MOD(J64,100),0))-(TIME(TRUNC(I64/100),MOD(I64,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C65=\"\",D65=\"\"),0,IF(VALUE(C65)>=VALUE(D65),(TIME(TRUNC(D65/100),MOD(D65,100),0))+1-(TIME(TRUNC(C65/100),MOD(C65,100),0)),(TIME(TRUNC(D65/100),MOD(D65,100),0))-(TIME(TRUNC(C65/100),MOD(C65,100),0))))","v":0},0,2400,{"$f":"IF(OR(F65=\"\",G65=\"\"),0,IF(VALUE(F65)>=VALUE(G65),(TIME(TRUNC(G65/100),MOD(G65,100),0))+1-(TIME(TRUNC(F65/100),MOD(F65,100),0)),(TIME(TRUNC(G65/100),MOD(G65,100),0))-(TIME(TRUNC(F65/100),MOD(F65,100),0))))","v":0},0,2400,{"$f":"IF(OR(I65=\"\",J65=\"\"),0,IF(VALUE(I65)>=VALUE(J65),(TIME(TRUNC(J65/100),MOD(J65,100),0))+1-(TIME(TRUNC(I65/100),MOD(I65,100),0)),(TIME(TRUNC(J65/100),MOD(J65,100),0))-(TIME(TRUNC(I65/100),MOD(I65,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E64+E65+E66+E67","v":"00:00:00"},{"$f":"E64+E65+E66+E67","v":0},null,{"$f":"H64+H65+H66+H67","v":"00:00:00"},{"$f":"H64+H65+H66+H67","v":0},null,{"$f":"K64+K65+K66+K67","v":"00:00:00"},{"$f":"K64+K65+K66+K67","v":0}]
[{"$f":"A64+1","v":"2024-02-22"},"Torsdag",0,2400,{"$f":"IF(OR(C69=\"\",D69=\"\"),0,IF(VALUE(C69)>=VALUE(D69),(TIME(TRUNC(D69/100),MOD(D69,100),0))+1-(TIME(TRUNC(C69/100),MOD(C69,100),0)),(TIME(TRUNC(D69/100),MOD(D69,100),0))-(TIME(TRUNC(C69/100),MOD(C69,100),0))))","v":0},0,2400,{"$f":"IF(OR(F69=\"\",G69=\"\"),0,IF(VALUE(F69)>=VALUE(G69),(TIME(TRUNC(G69/100),MOD(G69,100),0))+1-(TIME(TRUNC(F69/100),MOD(F69,100),0)),(TIME(TRUNC(G69/100),MOD(G69,100),0))-(TIME(TRUNC(F69/100),MOD(F69,100),0))))","v":0},0,2400,{"$f":"IF(OR(I69=\"\",J69=\"\"),0,IF(VALUE(I69)>=VALUE(J69),(TIME(TRUNC(J69/100),MOD(J69,100),0))+1-(TIME(TRUNC(I69/100),MOD(I69,100),0)),(TIME(TRUNC(J69/100),MOD(J69,100),0))-(TIME(TRUNC(I69/100),MOD(I69,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C70=\"\",D70=\"\"),0,IF(VALUE(C70)>=VALUE(D70),(TIME(TRUNC(D70/100),MOD(D70,100),0))+1-(TIME(TRUNC(C70/100),MOD(C70,100),0)),(TIME(TRUNC(D70/100),MOD(D70,100),0))-(TIME(TRUNC(C70/100),MOD(C70,100),0))))","v":0},0,2400,{"$f":"IF(OR(F70=\"\",G70=\"\"),0,IF(VALUE(F70)>=VALUE(G70),(TIME(TRUNC(G70/100),MOD(G70,100),0))+1-(TIME(TRUNC(F70/100),MOD(F70,100),0)),(TIME(TRUNC(G70/100),MOD(G70,100),0))-(TIME(TRUNC(F70/100),MOD(F70,100),0))))","v":0},0,2400,{"$f":"IF(OR(I70=\"\",J70=\"\"),0,IF(VALUE(I70)>=VALUE(J70),(TIME(TRUNC(J70/100),MOD(J70,100),0))+1-(TIME(TRUNC(I70/100),MOD(I70,100),0)),(TIME(TRUNC(J70/100),MOD(J70,100),0))-(TIME(TRUNC(I70/100),MOD(I70,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E69+E70+E71+E72","v":"00:00:00"},{"$f":"E69+E70+E71+E72","v":0},null,{"$f":"H69+H70+H71+H72","v":"00:00:00"},{"$f":"H69+H70+H71+H72","v":0},null,{"$f":"K69+K70+K71+K72","v":"00:00:00"},{"$f":"K69+K70+K71+K72","v":0}]
[{"$f":"A69+1","v":"2024-02-23"},"Fredag",0,2400,{"$f":"IF(OR(C74=\"\",D74=\"\"),0,IF(VALUE(C74)>=VALUE(D74),(TIME(TRUNC(D74/100),MOD(D74,100),0))+1-(TIME(TRUNC(C74/100),MOD(C74,100),0)),(TIME(TRUNC(D74/100),MOD(D74,100),0))-(TIME(TRUNC(C74/100),MOD(C74,100),0))))","v":0},0,2400,{"$f":"IF(OR(F74=\"\",G74=\"\"),0,IF(VALUE(F74)>=VALUE(G74),(TIME(TRUNC(G74/100),MOD(G74,100),0))+1-(TIME(TRUNC(F74/100),MOD(F74,100),0)),(TIME(TRUNC(G74/100),MOD(G74,100),0))-(TIME(TRUNC(F74/100),MOD(F74,100),0))))","v":0},0,2400,{"$f":"IF(OR(I74=\"\",J74=\"\"),0,IF(VALUE(I74)>=VALUE(J74),(TIME(TRUNC(J74/100),MOD(J74,100),0))+1-(TIME(TRUNC(I74/100),MOD(I74,100),0)),(TIME(TRUNC(J74/100),MOD(J74,100),0))-(TIME(TRUNC(I74/100),MOD(I74,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C75=\"\",D75=\"\"),0,IF(VALUE(C75)>=VALUE(D75),(TIME(TRUNC(D75/100),MOD(D75,100),0))+1-(TIME(TRUNC(C75/100),MOD(C75,100),0)),(TIME(TRUNC(D75/100),MOD(D75,100),0))-(TIME(TRUNC(C75/100),MOD(C75,100),0))))","v":0},0,2400,{"$f":"IF(OR(F75=\"\",G75=\"\"),0,IF(VALUE(F75)>=VALUE(G75),(TIME(TRUNC(G75/100),MOD(G75,100),0))+1-(TIME(TRUNC(F75/100),MOD(F75,100),0)),(TIME(TRUNC(G75/100),MOD(G75,100),0))-(TIME(TRUNC(F75/100),MOD(F75,100),0))))","v":0},0,2400,{"$f":"IF(OR(I75=\"\",J75=\"\"),0,IF(VALUE(I75)>=VALUE(J75),(TIME(TRUNC(J75/100),MOD(J75,100),0))+1-(TIME(TRUNC(I75/100),MOD(I75,100),0)),(TIME(TRUNC(J75/100),MOD(J75,100),0))-(TIME(TRUNC(I75/100),MOD(I75,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E74+E75+E76+E77","v":"00:00:00"},{"$f":"E74+E75+E76+E77","v":0},null,{"$f":"H74+H75+H76+H77","v":"00:00:00"},{"$f":"H74+H75+H76+H77","v":0},null,{"$f":"K74+K75+K76+K77","v":"00:00:00"},{"$f":"K74+K75+K76+K77","v":0}]
[{"$f":"A74+1","v":"2024-02-24"},"Lørdag",0,2400,{"$f":"IF(OR(C79=\"\",D79=\"\"),0,IF(VALUE(C79)>=VALUE(D79),(TIME(TRUNC(D79/100),MOD(D79,100),0))+1-(TIME(TRUNC(C79/100),MOD(C79,100),0)),(TIME(TRUNC(D79/100),MOD(D79,100),0))-(TIME(TRUNC(C79/100),MOD(C79,100),0))))","v":0},0,2400,{"$f":"IF(OR(F79=\"\",G79=\"\"),0,IF(VALUE(F79)>=VALUE(G79),(TIME(TRUNC(G79/100),MOD(G79,100),0))+1-(TIME(TRUNC(F79/100),MOD(F79,100),0)),(TIME(TRUNC(G79/100),MOD(G79,100),0))-(TIME(TRUNC(F79/100),MOD(F79,100),0))))","v":0},0,2400,{"$f":"IF(OR(I79=\"\",J79=\"\"),0,IF(VALUE(I79)>=VALUE(J79),(TIME(TRUNC(J79/100),MOD(J79,100),0))+1-(TIME(TRUNC(I79/100),MOD(I79,100),0)),(TIME(TRUNC(J79/100),MOD(J79,100),0))-(TIME(TRUNC(I79/100),MOD(I79,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C80=\"\",D80=\"\"),0,IF(VALUE(C80)>=VALUE(D80),(TIME(TRUNC(D80/100),MOD(D80,100),0))+1-(TIME(TRUNC(C80/100),MOD(C80,100),0)),(TIME(TRUNC(D80/100),MOD(D80,100),0))-(TIME(TRUNC(C80/100),MOD(C80,100),0))))","v":0},0,2400,{"$f":"IF(OR(F80=\"\",G80=\"\"),0,IF(VALUE(F80)>=VALUE(G80),(TIME(TRUNC(G80/100),MOD(G80,100),0))+1-(TIME(TRUNC(F80/100),MOD(F80,100),0)),(TIME(TRUNC(G80/100),MOD(G80,100),0))-(TIME(TRUNC(F80/100),MOD(F80,100),0))))","v":0},0,2400,{"$f":"IF(OR(I80=\"\",J80=\"\"),0,IF(VALUE(I80)>=VALUE(J80),(TIME(TRUNC(J80/100),MOD(J80,100),0))+1-(TIME(TRUNC(I80/100),MOD(I80,100),0)),(TIME(TRUNC(J80/100),MOD(J80,100),0))-(TIME(TRUNC(I80/100),MOD(I80,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E79+E80+E81+E82","v":"00:00:00"},{"$f":"E79+E80+E81+E82","v":0},null,{"$f":"H79+H80+H81+H82","v":"00:00:00"},{"$f":"H79+H80+H81+H82","v":0},null,{"$f":"K79+K80+K81+K82","v":"00:00:00"},{"$f":"K79+K80+K81+K82","v":0}]
[{"$f":"A79+1","v":"2024-02-25"},"Søndag",0,2400,{"$f":"IF(OR(C84=\"\",D84=\"\"),0,IF(VALUE(C84)>=VALUE(D84),(TIME(TRUNC(D84/100),MOD(D84,100),0))+1-(TIME(TRUNC(C84/100),MOD(C84,100),0)),(TIME(TRUNC(D84/100),MOD(D84,100),0))-(TIME(TRUNC(C84/100),MOD(C84,100),0))))","v":0},0,2400,{"$f":"IF(OR(F84=\"\",G84=\"\"),0,IF(VALUE(F84)>=VALUE(G84),(TIME(TRUNC(G84/100),MOD(G84,100),0))+1-(TIME(TRUNC(F84/100),MOD(F84,100),0)),(TIME(TRUNC(G84/100),MOD(G84,100),0))-(TIME(TRUNC(F84/100),MOD(F84,100),0))))","v":0},0,2400,{"$f":"IF(OR(I84=\"\",J84=\"\"),0,IF(VALUE(I84)>=VALUE(J84),(TIME(TRUNC(J84/100),MOD(J84,100),0))+1-(TIME(TRUNC(I84/100),MOD(I84,100),0)),(TIME(TRUNC(J84/100),MOD(J84,100),0))-(TIME(TRUNC(I84/100),MOD(I84,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C85=\"\",D85=\"\"),0,IF(VALUE(C85)>=VALUE(D85),(TIME(TRUNC(D85/100),MOD(D85,100),0))+1-(TIME(TRUNC(C85/100),MOD(C85,100),0)),(TIME(TRUNC(D85/100),MOD(D85,100),0))-(TIME(TRUNC(C85/100),MOD(C85,100),0))))","v":0},0,2400,{"$f":"IF(OR(F85=\"\",G85=\"\"),0,IF(VALUE(F85)>=VALUE(G85),(TIME(TRUNC(G85/100),MOD(G85,100),0))+1-(TIME(TRUNC(F85/100),MOD(F85,100),0)),(TIME(TRUNC(G85/100),MOD(G85,100),0))-(TIME(TRUNC(F85/100),MOD(F85,100),0))))","v":0},0,2400,{"$f":"IF(OR(I85=\"\",J85=\"\"),0,IF(VALUE(I85)>=VALUE(J85),(TIME(TRUNC(J85/100),MOD(J85,100),0))+1-(TIME(TRUNC(I85/100),MOD(I85,100),0)),(TIME(TRUNC(J85/100),MOD(J85,100),0))-(TIME(TRUNC(I85/100),MOD(I85,100),0))))","v":0}]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,null,0,2400,0,0,2400,0,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E84+E85+E86+E87","v":"00:00:00"},{"$f":"E84+E85+E86+E87","v":0},null,{"$f":"H84+H85+H86+H87","v":"00:00:00"},{"$f":"H84+H85+H86+H87","v":0},null,{"$f":"K84+K85+K86+K87","v":"00:00:00"},{"$f":"K84+K85+K86+K87","v":0}]
[null,{"$f":"47:89","v":0},null,"Sum timer",{"$f":"(E58+E63+E68+E73+E78+E83+E88)*24+E44","v":8},null,"Sum timer",{"$f":"(H58+H63+H68+H73+H78+H83+H88)*24+H44","v":5.9999999999999982},null,"Sum timer",{"$f":"(K58+K63+K68+K73+K78+K83+K88)*24+K44","v":8},null,{"$f":"SUM(M54:M88)+M44","v":0},null,null,{"$f":"SUM(P54:P88)+P44","v":0},{"$f":"SUM(Q54:Q88)+Q44","v":0},{"$f":"SUM(R54:R88)+R44","v":0},0,{"$f":"SUM(T54:T88)+T44","v":0}]
[]
[]
[]
[null,null,"Antal timer i lønperiode inkl. døgn",null,null,{"$f":"M89*10+P89+E89","v":8},null,"001 Arbejdstimer"]
[]
[null,null,"Antal normal timer",null,null,{"$f":"E89+P89","v":8},null,"1213 Normaltimer 1xsats"]
[]
[]
[null,null,"Timeløn kørsel",null,176,{"$f":"F95*E98","v":1408},null,null,null,null,"Dagstimer","Skriv tidsrum for arbejds timer"]
[null,null,"Timeløn kontor",null,150,{"$f":"E99*K89","v":1200},null,null,null,null,"Kontortimer","Skriv tidsrum for arbejds timer"]
[null,null,"Forskudt tid",null,38,{"$f":"H89*E100","v":227.99999999999994},null,null,null,null,"Forskudt tid","Skriv tidsrum for arbejds timer"]
["10 timer",null,"Døgn",null,1926,{"$f":"E101*M89","v":0},null,"1415 Døgn"]
["Skattefri",null,"Tærepenge",null,150,{"$f":"E102*S89","v":0},null,"0007 Skattefri godtgørelse"]
[null,null,"Tærepenge pr. time",null,6.25,{"$f":"E103*P89","v":0},null,"0007 Skattefri godtgørelse",null,null,"døgn","skriv 1 hvis det er aktuelt - ellers skal feltet være blank"]
[null,null,"Diæt",null,135,{"$f":"E104*R89","v":0},null,"0086 Diæter",null,null,"vend ski","skriv 1 hvis det er aktuelt - ellers skal feltet være blank"]
[null,null,"Vendetillæg ski",null,1000,{"$f":"Q89*E105","v":0},null,"006A Vend",null,null,"afgang","skriv hvornår turen starter"]
[null,null,"Døgn / normaltimertimer",null,176,null,null,"1213 Normaltimer 1xsats",null,null,"slut","skriv når turen er sluttet"]
[null,null,null,null,null,null,null,null,null,null,"timer døgn","skriv antal timer udover døgn"]
[null,null,null,null,null,null,null,"0037 Sygeløn",null,null,"diæt","skriv antal diæter"]
[null,null,null,null,null,",",null,"0072 Sygetimer"]
[null,null,{"$f":"F98+F99+F100+F101+F102+F103+F104+F105","v":2836},null,null,null,null,"0037 Sygeløn med AM bidrag 2"]

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

{"sheet":"Løn data","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Dato"," mandag","2024-12-25"]
["Lønperiode uger",null,"2-3"]

{"sheet":"Original (2)","index":3,"n_rows":110,"n_cols":19,"rows_kept":110,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,18],[2,1,6,2],[2,3,6,18],[8,0,12,0],[8,11,12,11],[8,12,12,12],[8,13,12,13],[8,14,12,14],[8,15,12,15],[8,16,12,16],[8,17,12,17],[8,18,12,18],[13,0,17,0],[13,11,17,11],[13,12,17,12],[13,13,17,13],[13,14,17,14],[13,15,17,15],[13,16,17,16],[13,17,17,17],[13,18,17,18],[18,0,22,0],[18,11,22,11],[18,12,22,12],[18,13,22,13],[18,14,22,14],[18,15,22,15],[18,16,22,16],[18,17,22,17],[18,18,22,18],[23,0,27,0],[23,11,27,11],[23,12,27,12],[23,13,27,13],[23,14,27,14],[23,15,27,15],[23,16,27,16],[23,17,27,17],[23,18,27,18],[28,16,32,16],[28,17,32,17],[28,18,32,18],[33,0,37,0],[33,11,37,11],[33,12,37,12],[33,13,37,13],[33,14,37,14],[33,15,37,15],[33,16,37,16],[28,0,32,0],[28,11,32,11],[28,12,32,12],[28,13,32,13],[28,14,32,14],[28,15,32,15],[33,17,37,17],[33,18,37,18],[38,0,42,0],[38,11,42,11],[38,12,42,12],[38,13,42,13],[38,14,42,14],[38,15,42,15],[38,16,42,16],[38,17,42,17],[38,18,42,18],[46,1,46,2],[46,3,46,18],[47,1,51,2],[47,3,51,18],[53,0,57,0],[53,11,57,11],[53,12,57,12],[53,13,57,13],[53,14,57,14],[53,15,57,15],[53,16,57,16],[53,17,57,17],[53,18,57,18],[58,0,62,0],[58,11,62,11],[58,12,62,12],[58,13,62,13],[58,14,62,14],[58,15,62,15],[58,16,62,16],[58,17,62,17],[58,18,62,18],[63,0,67,0],[63,11,67,11],[63,12,67,12],[63,13,67,13],[63,14,67,14],[63,15,67,15],[63,16,67,16],[63,17,67,17],[63,18,67,18],[68,0,72,0],[68,11,72,11],[68,12,72,12],[68,13,72,13],[68,14,72,14],[68,15,72,15],[68,16,72,16],[68,17,72,17],[68,18,72,18],[73,0,77,0],[73,11,77,11],[73,12,77,12],[73,13,77,13],[73,14,77,14],[73,15,77,15],[73,16,77,16],[73,17,77,17],[73,18,77,18],[109,2,110,4],[83,17,87,17],[83,18,87,18],[91,2,91,3],[78,16,82,16],[78,17,82,17],[78,18,82,18],[83,0,87,0],[83,11,87,11],[83,12,87,12],[83,13,87,13],[83,14,87,14],[83,15,87,15],[83,16,87,16],[78,0,82,0],[78,11,82,11],[78,12,82,12],[78,13,82,13],[78,14,82,14],[78,15,82,15]]}
[]
[null,"Uge nr.",null,"Navn"]
[null,"7",null,"Klaus Schmidt"]
[]
[]
[]
[]
[null,null,"Starttid              06:00","Sluttid               20:00","Forbrugt tid","Timer med tilæg",null,"Starttid                        06:00","Sluttid                          20:00","Forbrugt tid","Udført arbejde/vagt nr.","Døgn","Afgang","Slut","Døgn/Timer","Vend ski","Diæt","Tærepenge","Tærepenge timer"]
["2024-02-12","Mandag","04:00:00",1,{"$f":"IF(D9<C9, D9+1, D9) - C9","v":"20:00:00"},{"$f":"IF(C9<TIME(6,0,0),TIME(6,0,0)-C9,0)+IF(OR(D9<TIME(20,0,0),D9>TIME(0,0,0)),0,D9-TIME(20,0,0))+IF(D9<TIME(20,0,0),IF(D9<TIME(1,0,0),D9+TIME(4,0,0),D9),D9-TIME(20,0,0))","v":"06:00:00"},null,0,2400,{"$f":"IF(OR(H9=\"\",I9=\"\"),0,IF(VALUE(H9)>=VALUE(I9),(TIME(TRUNC(I9/100),MOD(I9,100),0))+1-(TIME(TRUNC(H9/100),MOD(H9,100),0)),(TIME(TRUNC(I9/100),MOD(I9,100),0))-(TIME(TRUNC(H9/100),MOD(H9,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,{"$f":"IF(OR(H10=\"\",I10=\"\"),0,IF(VALUE(H10)>=VALUE(I10),(TIME(TRUNC(I10/100),MOD(I10,100),0))+1-(TIME(TRUNC(H10/100),MOD(H10,100),0)),(TIME(TRUNC(I10/100),MOD(I10,100),0))-(TIME(TRUNC(H10/100),MOD(H10,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,0]
[null,null,null,null,null,null,null,0,2400,0]
[null,"Sammenlagt",null,null,{"$f":"E9+E10+E11+E12","v":"20:00:00"},{"$f":"F9+F10+F11+F12","v":"06:00:00"},null,null,{"$f":"J9+J10+J11+J12","v":"00:00:00"},{"$f":"J9+J10+J11+J12","v":0}]
[{"$f":"A9+1","v":"2024-02-13"},"Tirsdag","00:00:00","08:00:00",{"$f":"IF(D14<C14, D14+1, D14) - C14","v":"08:00:00"},{"$f":"IF(C14<TIME(6,0,0),TIME(6,0,0)-C14,0)+IF(OR(D14<TIME(20,0,0),D14>TIME(0,0,0)),0,D14-TIME(20,0,0))+IF(D14<TIME(20,0,0),IF(D14<TIME(1,0,0),D14+TIME(4,0,0),D14),D14-TIME(20,0,0))","v":"14:00:00"},null,0,2400,{"$f":"IF(OR(H14=\"\",I14=\"\"),0,IF(VALUE(H14)>=VALUE(I14),(TIME(TRUNC(I14/100),MOD(I14,100),0))+1-(TIME(TRUNC(H14/100),MOD(H14,100),0)),(TIME(TRUNC(I14/100),MOD(I14,100),0))-(TIME(TRUNC(H14/100),MOD(H14,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,{"$f":"IF(OR(H15=\"\",I15=\"\"),0,IF(VALUE(H15)>=VALUE(I15),(TIME(TRUNC(I15/100),MOD(I15,100),0))+1-(TIME(TRUNC(H15/100),MOD(H15,100),0)),(TIME(TRUNC(I15/100),MOD(I15,100),0))-(TIME(TRUNC(H15/100),MOD(H15,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,0]
[null,null,null,null,null,null,null,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E14+E15+E16+E17","v":"08:00:00"},{"$f":"E14+E15+E16+E17","v":"08:00:00"},{"$f":"F14+F15+F16+F17","v":"14:00:00"},null,null,{"$f":"J14+J15+J16+J17","v":"00:00:00"},{"$f":"J14+J15+J16+J17","v":0}]
[{"$f":"A14+1","v":"2024-02-14"},"Onsdag",null,null,null,null,null,0,2400,{"$f":"IF(OR(H19=\"\",I19=\"\"),0,IF(VALUE(H19)>=VALUE(I19),(TIME(TRUNC(I19/100),MOD(I19,100),0))+1-(TIME(TRUNC(H19/100),MOD(H19,100),0)),(TIME(TRUNC(I19/100),MOD(I19,100),0))-(TIME(TRUNC(H19/100),MOD(H19,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,{"$f":"IF(OR(H20=\"\",I20=\"\"),0,IF(VALUE(H20)>=VALUE(I20),(TIME(TRUNC(I20/100),MOD(I20,100),0))+1-(TIME(TRUNC(H20/100),MOD(H20,100),0)),(TIME(TRUNC(I20/100),MOD(I20,100),0))-(TIME(TRUNC(H20/100),MOD(H20,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,0]
[null,null,null,null,null,null,null,0,2400,0]
[null,"Sammenlagt",null,null,null,null,null,null,{"$f":"J19+J20+J21+J22","v":"00:00:00"},{"$f":"J19+J20+J21+J22","v":0}]
[{"$f":"A19+1","v":"2024-02-15"},"Torsdag",null,null,null,null,null,0,2400,{"$f":"IF(OR(H24=\"\",I24=\"\"),0,IF(VALUE(H24)>=VALUE(I24),(TIME(TRUNC(I24/100),MOD(I24,100),0))+1-(TIME(TRUNC(H24/100),MOD(H24,100),0)),(TIME(TRUNC(I24/100),MOD(I24,100),0))-(TIME(TRUNC(H24/100),MOD(H24,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,{"$f":"IF(OR(H25=\"\",I25=\"\"),0,IF(VALUE(H25)>=VALUE(I25),(TIME(TRUNC(I25/100),MOD(I25,100),0))+1-(TIME(TRUNC(H25/100),MOD(H25,100),0)),(TIME(TRUNC(I25/100),MOD(I25,100),0))-(TIME(TRUNC(H25/100),MOD(H25,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,0]
[null,null,null,null,null,null,null,0,2400,0]
[null,"Sammenlagt",null,null,null,null,null,null,{"$f":"J24+J25+J26+J27","v":"00:00:00"},{"$f":"J24+J25+J26+J27","v":0}]
[{"$f":"A24+1","v":"2024-02-16"},"Fredag",null,null,null,null,null,0,2400,{"$f":"IF(OR(H29=\"\",I29=\"\"),0,IF(VALUE(H29)>=VALUE(I29),(TIME(TRUNC(I29/100),MOD(I29,100),0))+1-(TIME(TRUNC(H29/100),MOD(H29,100),0)),(TIME(TRUNC(I29/100),MOD(I29,100),0))-(TIME(TRUNC(H29/100),MOD(H29,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,{"$f":"IF(OR(H30=\"\",I30=\"\"),0,IF(VALUE(H30)>=VALUE(I30),(TIME(TRUNC(I30/100),MOD(I30,100),0))+1-(TIME(TRUNC(H30/100),MOD(H30,100),0)),(TIME(TRUNC(I30/100),MOD(I30,100),0))-(TIME(TRUNC(H30/100),MOD(H30,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,0]
[null,null,null,null,null,null,null,0,2400,0]
[null,"Sammenlagt",null,null,null,null,null,null,{"$f":"J29+J30+J31+J32","v":"00:00:00"},{"$f":"J29+J30+J31+J32","v":0}]
[{"$f":"A29+1","v":"2024-02-17"},"Lørdag",null,null,null,null,null,0,2400,{"$f":"IF(OR(H34=\"\",I34=\"\"),0,IF(VALUE(H34)>=VALUE(I34),(TIME(TRUNC(I34/100),MOD(I34,100),0))+1-(TIME(TRUNC(H34/100),MOD(H34,100),0)),(TIME(TRUNC(I34/100),MOD(I34,100),0))-(TIME(TRUNC(H34/100),MOD(H34,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,{"$f":"IF(OR(H35=\"\",I35=\"\"),0,IF(VALUE(H35)>=VALUE(I35),(TIME(TRUNC(I35/100),MOD(I35,100),0))+1-(TIME(TRUNC(H35/100),MOD(H35,100),0)),(TIME(TRUNC(I35/100),MOD(I35,100),0))-(TIME(TRUNC(H35/100),MOD(H35,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,0]
[null,null,null,null,null,null,null,0,2400,0]
[null,"Sammenlagt",null,null,null,null,null,null,{"$f":"J34+J35+J36+J37","v":"00:00:00"},{"$f":"J34+J35+J36+J37","v":0}]
[{"$f":"A34+1","v":"2024-02-18"},"Søndag",null,null,null,null,null,0,2400,{"$f":"IF(OR(H39=\"\",I39=\"\"),0,IF(VALUE(H39)>=VALUE(I39),(TIME(TRUNC(I39/100),MOD(I39,100),0))+1-(TIME(TRUNC(H39/100),MOD(H39,100),0)),(TIME(TRUNC(I39/100),MOD(I39,100),0))-(TIME(TRUNC(H39/100),MOD(H39,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,{"$f":"IF(OR(H40=\"\",I40=\"\"),0,IF(VALUE(H40)>=VALUE(I40),(TIME(TRUNC(I40/100),MOD(I40,100),0))+1-(TIME(TRUNC(H40/100),MOD(H40,100),0)),(TIME(TRUNC(I40/100),MOD(I40,100),0))-(TIME(TRUNC(H40/100),MOD(H40,100),0))))","v":0}]
[null,null,null,null,null,null,null,0,2400,0]
[null,null,null,null,null,null,null,0,2400,0]
[null,"Sammenlagt",null,null,null,null,null,null,{"$f":"J39+J40+J41+J42","v":"00:00:00"},{"$f":"J39+J40+J41+J42","v":0}]
[null,null,null,"Sum timer",{"$f":"(E13+E18+E23+E28+E33+E38+E43)*24","v":28},{"$f":"(F13+F18+F23+F28+F33+F38+F43)*24","v":20},null,null,"Sum timer",{"$f":"(J13+J18+J23+J28+J33+J38+J43)*24","v":0},null,{"$f":"SUM(L9:L43)","v":0},null,null,{"$f":"SUM(O9:O43)","v":0},{"$f":"SUM(P9:P43)","v":0},{"$f":"SUM(Q9:Q43)","v":0},{"$f":"SUM(R9:R43)","v":0},{"$f":"SUM(S9:S43)","v":0}]
[]
[]
[null,"Uge nr.",null,"Navn"]
[null,"8",null,"Klaus Schmidt"]
[]
[]
[]
[]
[null,null,"Starttid               06:00","Sluttid                20:00","Forbrugt tid","Forbrugt tid",null,"Starttid                06:00","Sluttid                  20:00","Forbrugt tid","Udført arbejde/vagt nr.","Døgn","Afgang","Slut","Døgn/Timer","Vend ski","Diæt","Tærepenge","Tærepenge timer"]
["2024-02-19","Mandag",0,2400,{"$f":"IF(OR(C54=\"\",D54=\"\"),0,IF(VALUE(C54)>=VALUE(D54),(TIME(TRUNC(D54/100),MOD(D54,100),0))+1-(TIME(TRUNC(C54/100),MOD(C54,100),0)),(TIME(TRUNC(D54/100),MOD(D54,100),0))-(TIME(TRUNC(C54/100),MOD(C54,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H54=\"\",I54=\"\"),0,IF(VALUE(H54)>=VALUE(I54),(TIME(TRUNC(I54/100),MOD(I54,100),0))+1-(TIME(TRUNC(H54/100),MOD(H54,100),0)),(TIME(TRUNC(I54/100),MOD(I54,100),0))-(TIME(TRUNC(H54/100),MOD(H54,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C55=\"\",D55=\"\"),0,IF(VALUE(C55)>=VALUE(D55),(TIME(TRUNC(D55/100),MOD(D55,100),0))+1-(TIME(TRUNC(C55/100),MOD(C55,100),0)),(TIME(TRUNC(D55/100),MOD(D55,100),0))-(TIME(TRUNC(C55/100),MOD(C55,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H55=\"\",I55=\"\"),0,IF(VALUE(H55)>=VALUE(I55),(TIME(TRUNC(I55/100),MOD(I55,100),0))+1-(TIME(TRUNC(H55/100),MOD(H55,100),0)),(TIME(TRUNC(I55/100),MOD(I55,100),0))-(TIME(TRUNC(H55/100),MOD(H55,100),0))))","v":0}]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E54+E55+E56+E57","v":"00:00:00"},{"$f":"E54+E55+E56+E57","v":0},{"$f":"F54+F55+F56+F57","v":{"$error":"#REF!"}},null,null,{"$f":"J54+J55+J56+J57","v":"00:00:00"},{"$f":"J54+J55+J56+J57","v":0}]
[{"$f":"A54+1","v":"2024-02-20"},"Tirsdag",0,2400,{"$f":"IF(OR(C59=\"\",D59=\"\"),0,IF(VALUE(C59)>=VALUE(D59),(TIME(TRUNC(D59/100),MOD(D59,100),0))+1-(TIME(TRUNC(C59/100),MOD(C59,100),0)),(TIME(TRUNC(D59/100),MOD(D59,100),0))-(TIME(TRUNC(C59/100),MOD(C59,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H59=\"\",I59=\"\"),0,IF(VALUE(H59)>=VALUE(I59),(TIME(TRUNC(I59/100),MOD(I59,100),0))+1-(TIME(TRUNC(H59/100),MOD(H59,100),0)),(TIME(TRUNC(I59/100),MOD(I59,100),0))-(TIME(TRUNC(H59/100),MOD(H59,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C60=\"\",D60=\"\"),0,IF(VALUE(C60)>=VALUE(D60),(TIME(TRUNC(D60/100),MOD(D60,100),0))+1-(TIME(TRUNC(C60/100),MOD(C60,100),0)),(TIME(TRUNC(D60/100),MOD(D60,100),0))-(TIME(TRUNC(C60/100),MOD(C60,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H60=\"\",I60=\"\"),0,IF(VALUE(H60)>=VALUE(I60),(TIME(TRUNC(I60/100),MOD(I60,100),0))+1-(TIME(TRUNC(H60/100),MOD(H60,100),0)),(TIME(TRUNC(I60/100),MOD(I60,100),0))-(TIME(TRUNC(H60/100),MOD(H60,100),0))))","v":0}]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E59+E60+E61+E62","v":"00:00:00"},{"$f":"E59+E60+E61+E62","v":0},{"$f":"F59+F60+F61+F62","v":{"$error":"#REF!"}},null,null,{"$f":"J59+J60+J61+J62","v":"00:00:00"},{"$f":"J59+J60+J61+J62","v":0}]
[{"$f":"A59+1","v":"2024-02-21"},"Onsdag",0,2400,{"$f":"IF(OR(C64=\"\",D64=\"\"),0,IF(VALUE(C64)>=VALUE(D64),(TIME(TRUNC(D64/100),MOD(D64,100),0))+1-(TIME(TRUNC(C64/100),MOD(C64,100),0)),(TIME(TRUNC(D64/100),MOD(D64,100),0))-(TIME(TRUNC(C64/100),MOD(C64,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H64=\"\",I64=\"\"),0,IF(VALUE(H64)>=VALUE(I64),(TIME(TRUNC(I64/100),MOD(I64,100),0))+1-(TIME(TRUNC(H64/100),MOD(H64,100),0)),(TIME(TRUNC(I64/100),MOD(I64,100),0))-(TIME(TRUNC(H64/100),MOD(H64,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C65=\"\",D65=\"\"),0,IF(VALUE(C65)>=VALUE(D65),(TIME(TRUNC(D65/100),MOD(D65,100),0))+1-(TIME(TRUNC(C65/100),MOD(C65,100),0)),(TIME(TRUNC(D65/100),MOD(D65,100),0))-(TIME(TRUNC(C65/100),MOD(C65,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H65=\"\",I65=\"\"),0,IF(VALUE(H65)>=VALUE(I65),(TIME(TRUNC(I65/100),MOD(I65,100),0))+1-(TIME(TRUNC(H65/100),MOD(H65,100),0)),(TIME(TRUNC(I65/100),MOD(I65,100),0))-(TIME(TRUNC(H65/100),MOD(H65,100),0))))","v":0}]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E64+E65+E66+E67","v":"00:00:00"},{"$f":"E64+E65+E66+E67","v":0},{"$f":"F64+F65+F66+F67","v":{"$error":"#REF!"}},null,null,{"$f":"J64+J65+J66+J67","v":"00:00:00"},{"$f":"J64+J65+J66+J67","v":0}]
[{"$f":"A64+1","v":"2024-02-22"},"Torsdag",0,2400,{"$f":"IF(OR(C69=\"\",D69=\"\"),0,IF(VALUE(C69)>=VALUE(D69),(TIME(TRUNC(D69/100),MOD(D69,100),0))+1-(TIME(TRUNC(C69/100),MOD(C69,100),0)),(TIME(TRUNC(D69/100),MOD(D69,100),0))-(TIME(TRUNC(C69/100),MOD(C69,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H69=\"\",I69=\"\"),0,IF(VALUE(H69)>=VALUE(I69),(TIME(TRUNC(I69/100),MOD(I69,100),0))+1-(TIME(TRUNC(H69/100),MOD(H69,100),0)),(TIME(TRUNC(I69/100),MOD(I69,100),0))-(TIME(TRUNC(H69/100),MOD(H69,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C70=\"\",D70=\"\"),0,IF(VALUE(C70)>=VALUE(D70),(TIME(TRUNC(D70/100),MOD(D70,100),0))+1-(TIME(TRUNC(C70/100),MOD(C70,100),0)),(TIME(TRUNC(D70/100),MOD(D70,100),0))-(TIME(TRUNC(C70/100),MOD(C70,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H70=\"\",I70=\"\"),0,IF(VALUE(H70)>=VALUE(I70),(TIME(TRUNC(I70/100),MOD(I70,100),0))+1-(TIME(TRUNC(H70/100),MOD(H70,100),0)),(TIME(TRUNC(I70/100),MOD(I70,100),0))-(TIME(TRUNC(H70/100),MOD(H70,100),0))))","v":0}]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E69+E70+E71+E72","v":"00:00:00"},{"$f":"E69+E70+E71+E72","v":0},{"$f":"F69+F70+F71+F72","v":{"$error":"#REF!"}},null,null,{"$f":"J69+J70+J71+J72","v":"00:00:00"},{"$f":"J69+J70+J71+J72","v":0}]
[{"$f":"A69+1","v":"2024-02-23"},"Fredag",0,2400,{"$f":"IF(OR(C74=\"\",D74=\"\"),0,IF(VALUE(C74)>=VALUE(D74),(TIME(TRUNC(D74/100),MOD(D74,100),0))+1-(TIME(TRUNC(C74/100),MOD(C74,100),0)),(TIME(TRUNC(D74/100),MOD(D74,100),0))-(TIME(TRUNC(C74/100),MOD(C74,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H74=\"\",I74=\"\"),0,IF(VALUE(H74)>=VALUE(I74),(TIME(TRUNC(I74/100),MOD(I74,100),0))+1-(TIME(TRUNC(H74/100),MOD(H74,100),0)),(TIME(TRUNC(I74/100),MOD(I74,100),0))-(TIME(TRUNC(H74/100),MOD(H74,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C75=\"\",D75=\"\"),0,IF(VALUE(C75)>=VALUE(D75),(TIME(TRUNC(D75/100),MOD(D75,100),0))+1-(TIME(TRUNC(C75/100),MOD(C75,100),0)),(TIME(TRUNC(D75/100),MOD(D75,100),0))-(TIME(TRUNC(C75/100),MOD(C75,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H75=\"\",I75=\"\"),0,IF(VALUE(H75)>=VALUE(I75),(TIME(TRUNC(I75/100),MOD(I75,100),0))+1-(TIME(TRUNC(H75/100),MOD(H75,100),0)),(TIME(TRUNC(I75/100),MOD(I75,100),0))-(TIME(TRUNC(H75/100),MOD(H75,100),0))))","v":0}]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E74+E75+E76+E77","v":"00:00:00"},{"$f":"E74+E75+E76+E77","v":0},{"$f":"F74+F75+F76+F77","v":{"$error":"#REF!"}},null,null,{"$f":"J74+J75+J76+J77","v":"00:00:00"},{"$f":"J74+J75+J76+J77","v":0}]
[{"$f":"A74+1","v":"2024-02-24"},"Lørdag",0,2400,{"$f":"IF(OR(C79=\"\",D79=\"\"),0,IF(VALUE(C79)>=VALUE(D79),(TIME(TRUNC(D79/100),MOD(D79,100),0))+1-(TIME(TRUNC(C79/100),MOD(C79,100),0)),(TIME(TRUNC(D79/100),MOD(D79,100),0))-(TIME(TRUNC(C79/100),MOD(C79,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H79=\"\",I79=\"\"),0,IF(VALUE(H79)>=VALUE(I79),(TIME(TRUNC(I79/100),MOD(I79,100),0))+1-(TIME(TRUNC(H79/100),MOD(H79,100),0)),(TIME(TRUNC(I79/100),MOD(I79,100),0))-(TIME(TRUNC(H79/100),MOD(H79,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C80=\"\",D80=\"\"),0,IF(VALUE(C80)>=VALUE(D80),(TIME(TRUNC(D80/100),MOD(D80,100),0))+1-(TIME(TRUNC(C80/100),MOD(C80,100),0)),(TIME(TRUNC(D80/100),MOD(D80,100),0))-(TIME(TRUNC(C80/100),MOD(C80,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H80=\"\",I80=\"\"),0,IF(VALUE(H80)>=VALUE(I80),(TIME(TRUNC(I80/100),MOD(I80,100),0))+1-(TIME(TRUNC(H80/100),MOD(H80,100),0)),(TIME(TRUNC(I80/100),MOD(I80,100),0))-(TIME(TRUNC(H80/100),MOD(H80,100),0))))","v":0}]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E79+E80+E81+E82","v":"00:00:00"},{"$f":"E79+E80+E81+E82","v":0},{"$f":"F79+F80+F81+F82","v":{"$error":"#REF!"}},null,null,{"$f":"J79+J80+J81+J82","v":"00:00:00"},{"$f":"J79+J80+J81+J82","v":0}]
[{"$f":"A79+1","v":"2024-02-25"},"Søndag",0,2400,{"$f":"IF(OR(C84=\"\",D84=\"\"),0,IF(VALUE(C84)>=VALUE(D84),(TIME(TRUNC(D84/100),MOD(D84,100),0))+1-(TIME(TRUNC(C84/100),MOD(C84,100),0)),(TIME(TRUNC(D84/100),MOD(D84,100),0))-(TIME(TRUNC(C84/100),MOD(C84,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H84=\"\",I84=\"\"),0,IF(VALUE(H84)>=VALUE(I84),(TIME(TRUNC(I84/100),MOD(I84,100),0))+1-(TIME(TRUNC(H84/100),MOD(H84,100),0)),(TIME(TRUNC(I84/100),MOD(I84,100),0))-(TIME(TRUNC(H84/100),MOD(H84,100),0))))","v":0}]
[null,null,0,2400,{"$f":"IF(OR(C85=\"\",D85=\"\"),0,IF(VALUE(C85)>=VALUE(D85),(TIME(TRUNC(D85/100),MOD(D85,100),0))+1-(TIME(TRUNC(C85/100),MOD(C85,100),0)),(TIME(TRUNC(D85/100),MOD(D85,100),0))-(TIME(TRUNC(C85/100),MOD(C85,100),0))))","v":0},{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,{"$f":"IF(OR(H85=\"\",I85=\"\"),0,IF(VALUE(H85)>=VALUE(I85),(TIME(TRUNC(I85/100),MOD(I85,100),0))+1-(TIME(TRUNC(H85/100),MOD(H85,100),0)),(TIME(TRUNC(I85/100),MOD(I85,100),0))-(TIME(TRUNC(H85/100),MOD(H85,100),0))))","v":0}]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,null,0,2400,0,{"$f":"IF(OR(#REF!=\"\",#REF!=\"\"),0,IF(VALUE(#REF!)>=VALUE(#REF!),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))+1-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0)),(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))-(TIME(TRUNC(#REF!/100),MOD(#REF!,100),0))))","v":{"$error":"#REF!"}},null,0,2400,0]
[null,"Sammenlagt",null,{"$f":"E84+E85+E86+E87","v":"00:00:00"},{"$f":"E84+E85+E86+E87","v":0},{"$f":"F84+F85+F86+F87","v":{"$error":"#REF!"}},null,null,{"$f":"J84+J85+J86+J87","v":"00:00:00"},{"$f":"J84+J85+J86+J87","v":0}]
[null,{"$f":"47:89","v":0},null,"Sum timer",{"$f":"(E58+E63+E68+E73+E78+E83+E88)*24+E44","v":28},{"$f":"(F58+F63+F68+F73+F78+F83+F88)*24+F44","v":{"$error":"#REF!"}},null,null,"Sum timer",{"$f":"(J58+J63+J68+J73+J78+J83+J88)*24+J44","v":0},null,{"$f":"SUM(L54:L88)+L44","v":0},null,null,{"$f":"SUM(O54:O88)+O44","v":0},{"$f":"SUM(P54:P88)+P44","v":0},{"$f":"SUM(Q54:Q88)+Q44","v":0},{"$f":"SUM(R54:R88)+R44","v":0},{"$f":"SUM(S54:S88)+S44","v":0}]
[]
[]
[]
[null,"Antal timer i lønperiode inkl. døgn",null,null,{"$f":"L89*10+O89+E89","v":28},"001 Arbejdstimer"]
[]
[null,"Antal normal timer",null,null,{"$f":"E89+O89","v":28},"1213 Normaltimer 1xsats"]
[]
[]
[null,"Timeløn kørsel",null,176,{"$f":"E95*D98","v":4928},null,null,null,null,"Dagstimer","Skriv tidsrum for arbejds timer"]
[null,"Timeløn kontor",null,150,{"$f":"D99*J89","v":0},null,null,null,null,"Kontortimer","Skriv tidsrum for arbejds timer"]
[null,"Forskudt tid",null,38,{"$f":"F89*D100","v":{"$error":"#REF!"}},null,null,null,null,"Forskudt tid","Skriv tidsrum for arbejds timer"]
["10 timer","Døgn",null,1926,{"$f":"D101*L89","v":0},"1415 Døgn"]
["Skattefri","Tærepenge",null,150,{"$f":"D102*L89","v":0},"0007 Skattefri godtgørelse"]
[null,"Tærepenge pr. time",null,6.25,{"$f":"D103*O89","v":0},"0007 Skattefri godtgørelse",null,null,null,"døgn","skriv 1 hvis det er aktuelt - ellers skal feltet være blank"]
[null,"Diæt",null,135,{"$f":"D104*Q89","v":0},"0086 Diæter",null,null,null,"vend ski","skriv 1 hvis det er aktuelt - ellers skal feltet være blank"]
[null,"Vendetillæg ski",null,1000,{"$f":"P89*D105","v":0},"006A Vend",null,null,null,"afgang","skriv hvornår turen starter"]
[null,"Døgn / normaltimertimer",null,176,null,"1213 Normaltimer 1xsats",null,null,null,"slut","skriv når turen er sluttet"]
[null,null,null,null,null,null,null,null,null,"timer døgn","skriv antal timer udover døgn"]
[null,null,null,null,null,"0037 Sygeløn",null,null,null,"diæt","skriv antal diæter"]
[null,null,null,null,null,"0072 Sygetimer"]
[null,null,{"$f":"E98+E99+E100+E101+E102+E103+E104+E105","v":{"$error":"#REF!"}},null,null,"0037 Sygeløn med AM bidrag 2"]

{"sheet":"Ark2","index":4,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[800,1600,{"$f":"B1-A1","v":800}]
[0,2400,null,{"$f":"IF(OR(B2=\"\",C2=\"\"),0,IF(VALUE(B2)>=VALUE(C2),(TIME(TRUNC(C2/100),MOD(C2,100),0))+1-(TIME(TRUNC(B2/100),MOD(B2,100),0)),(TIME(TRUNC(C2/100),MOD(C2,100),0))-(TIME(TRUNC(B2/100),MOD(B2,100),0))))","v":0}]
[0,2400,{"$f":"IF(OR(A3=\"\",B3=\"\"),0,IF(VALUE(A3)>=VALUE(B3),(TIME(TRUNC(B3/100),MOD(B3,100),0))+1-(TIME(TRUNC(A3/100),MOD(A3,100),0)),(TIME(TRUNC(B3/100),MOD(B3,100),0))-(TIME(TRUNC(A3/100),MOD(A3,100),0))))","v":0},{"$f":"IF(OR(B3=\"\",C3=\"\"),0,IF(VALUE(B3)>=VALUE(C3),(TIME(TRUNC(C3/100),MOD(C3,100),0))+1-(TIME(TRUNC(B3/100),MOD(B3,100),0)),(TIME(TRUNC(C3/100),MOD(C3,100),0))-(TIME(TRUNC(B3/100),MOD(B3,100),0))))","v":1}]
[0,2400,{"$f":"IF(OR(A4=\"\",B4=\"\"),0,IF(VALUE(A4)>=VALUE(B4),(TIME(TRUNC(B4/100),MOD(B4,100),0))+1-(TIME(TRUNC(A4/100),MOD(A4,100),0)),(TIME(TRUNC(B4/100),MOD(B4,100),0))-(TIME(TRUNC(A4/100),MOD(A4,100),0))))","v":0},{"$f":"IF(OR(B4=\"\",C4=\"\"),0,IF(VALUE(B4)>=VALUE(C4),(TIME(TRUNC(C4/100),MOD(C4,100),0))+1-(TIME(TRUNC(B4/100),MOD(B4,100),0)),(TIME(TRUNC(C4/100),MOD(C4,100),0))-(TIME(TRUNC(B4/100),MOD(B4,100),0))))","v":1}]
[null,{"$f":"C1+C2+C3+C4","v":800},{"$f":"C1+C2+C3+C4","v":800},{"$f":"D1+D2+D3+D4","v":2}]
[0,2400,{"$f":"IF(OR(A6=\"\",B6=\"\"),0,IF(VALUE(A6)>=VALUE(B6),(TIME(TRUNC(B6/100),MOD(B6,100),0))+1-(TIME(TRUNC(A6/100),MOD(A6,100),0)),(TIME(TRUNC(B6/100),MOD(B6,100),0))-(TIME(TRUNC(A6/100),MOD(A6,100),0))))","v":0},1]
[0,2400,0,1]
[0,2400,0,1]
[0,2400,0,1]
[null,{"$f":"C6+C7+C8+C9","v":"00:00:00"},{"$f":"C6+C7+C8+C9","v":0},{"$f":"D6+D7+D8+D9","v":4}]
[0,2400,{"$f":"IF(OR(A11=\"\",B11=\"\"),0,IF(VALUE(A11)>=VALUE(B11),(TIME(TRUNC(B11/100),MOD(B11,100),0))+1-(TIME(TRUNC(A11/100),MOD(A11,100),0)),(TIME(TRUNC(B11/100),MOD(B11,100),0))-(TIME(TRUNC(A11/100),MOD(A11,100),0))))","v":0},1]
[0,2400,0,1]
[0,2400,0,1]
[0,2400,0,1]
[null,{"$f":"C11+C12+C13+C14","v":"00:00:00"},{"$f":"C11+C12+C13+C14","v":0},{"$f":"D11+D12+D13+D14","v":4}]
[0,2400,{"$f":"IF(OR(A16=\"\",B16=\"\"),0,IF(VALUE(A16)>=VALUE(B16),(TIME(TRUNC(B16/100),MOD(B16,100),0))+1-(TIME(TRUNC(A16/100),MOD(A16,100),0)),(TIME(TRUNC(B16/100),MOD(B16,100),0))-(TIME(TRUNC(A16/100),MOD(A16,100),0))))","v":0},1]
[0,2400,0,1]
[0,2400,0,1]
[0,2400,0,1]
[null,{"$f":"C16+C17+C18+C19","v":"00:00:00"},{"$f":"C16+C17+C18+C19","v":0},{"$f":"D16+D17+D18+D19","v":4}]
[0,2400,{"$f":"IF(OR(A21=\"\",B21=\"\"),0,IF(VALUE(A21)>=VALUE(B21),(TIME(TRUNC(B21/100),MOD(B21,100),0))+1-(TIME(TRUNC(A21/100),MOD(A21,100),0)),(TIME(TRUNC(B21/100),MOD(B21,100),0))-(TIME(TRUNC(A21/100),MOD(A21,100),0))))","v":0},1]
[0,2400,0,1]
[0,2400,0,1]
[0,2400,0,1]
[null,{"$f":"C21+C22+C23+C24","v":"00:00:00"},{"$f":"C21+C22+C23+C24","v":0},{"$f":"D21+D22+D23+D24","v":4}]
[0,2400,{"$f":"IF(OR(A26=\"\",B26=\"\"),0,IF(VALUE(A26)>=VALUE(B26),(TIME(TRUNC(B26/100),MOD(B26,100),0))+1-(TIME(TRUNC(A26/100),MOD(A26,100),0)),(TIME(TRUNC(B26/100),MOD(B26,100),0))-(TIME(TRUNC(A26/100),MOD(A26,100),0))))","v":0},1]
[0,2400,0,1]
[0,2400,0,1]
[0,2400,0,1]
[null,{"$f":"C26+C27+C28+C29","v":"00:00:00"},{"$f":"C26+C27+C28+C29","v":0},{"$f":"D26+D27+D28+D29","v":4}]
[0,2400,{"$f":"IF(OR(A31=\"\",B31=\"\"),0,IF(VALUE(A31)>=VALUE(B31),(TIME(TRUNC(B31/100),MOD(B31,100),0))+1-(TIME(TRUNC(A31/100),MOD(A31,100),0)),(TIME(TRUNC(B31/100),MOD(B31,100),0))-(TIME(TRUNC(A31/100),MOD(A31,100),0))))","v":0},1]
[0,2400,0,1]
[0,2400,0,1]
[0,2400,0,1]
[null,{"$f":"C31+C32+C33+C34","v":"00:00:00"},{"$f":"C31+C32+C33+C34","v":0},{"$f":"D31+D32+D33+D34","v":4}]
[null,"Sum timer",{"$f":"(C5+C10+C15+C20+C25+C30+C35)*24","v":19200},{"$f":"(D5+D10+D15+D20+D25+D30+D35)*24","v":624}]