{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Timeliste"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Timeliste","index":0,"n_rows":12,"n_cols":7,"rows_kept":12}
[null,"Timeliste"]
[null,"Detaljer om den ansatte:","Navn","E-postadresse","Telefonnummer"]
[null,"Detaljer om leder:","Navn"]
[null,"Startdato for periode","Sluttdato for periode"]
[null,"Totalt antall \narbeidstimer i uken","Totalt antall\narbeidstimer","Ordinære timer","Overtidstimer"]
[null,{"v":40,"d":"40.00"},{"$f":"SUBTOTAL(109,Timeliste[Antall arbeidstimer])","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF(C6<=ArbeidsukeTimer,C6,ArbeidsukeTimer),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(C6-D6, \"\")","v":{"v":0,"d":"0.00"}}]
[null,"Dato(er)","Starttidspunkt","Starttidspunkt for lunsj","Sluttidspunkt for lunsj","Sluttidspunkt","Antall arbeidstimer"]
[null,"Dato","Starttidspunkt","Starttidspunkt for lunsj","Sluttidspunkt for lunsj","Sluttidspunkt",{"$f":"IFERROR(IF(COUNT(Timeliste[[#This Row],[Starttidspunkt]:[Sluttidspunkt]])=4,(IF(Timeliste[[#This Row],[Sluttidspunkt]]<Timeliste[[#This Row],[Starttidspunkt]],1,0)+Timeliste[[#This Row],[Sluttidspunkt]])-Timeliste[[#This Row],[Sluttidspunkt for lunsj]]+Timeliste[[#This Row],[Starttidspunkt for lunsj]]-Timeliste[[#This Row],[Starttidspunkt]],IF(AND(LEN(Timeliste[[#This Row],[Starttidspunkt]])<>0,LEN(Timeliste[[#This Row],[Sluttidspunkt]])<>0),(IF(Timeliste[[#This Row],[Sluttidspunkt]]<Timeliste[[#This Row],[Starttidspunkt]],1,0)+Timeliste[[#This Row],[Sluttidspunkt]])-Timeliste[[#This Row],[Starttidspunkt]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Dato","Starttidspunkt","Starttidspunkt for lunsj","Sluttidspunkt for lunsj","Sluttidspunkt",{"$f":"IFERROR(IF(COUNT(Timeliste[[#This Row],[Starttidspunkt]:[Sluttidspunkt]])=4,(IF(Timeliste[[#This Row],[Sluttidspunkt]]<Timeliste[[#This Row],[Starttidspunkt]],1,0)+Timeliste[[#This Row],[Sluttidspunkt]])-Timeliste[[#This Row],[Sluttidspunkt for lunsj]]+Timeliste[[#This Row],[Starttidspunkt for lunsj]]-Timeliste[[#This Row],[Starttidspunkt]],IF(AND(LEN(Timeliste[[#This Row],[Starttidspunkt]])<>0,LEN(Timeliste[[#This Row],[Sluttidspunkt]])<>0),(IF(Timeliste[[#This Row],[Sluttidspunkt]]<Timeliste[[#This Row],[Starttidspunkt]],1,0)+Timeliste[[#This Row],[Sluttidspunkt]])-Timeliste[[#This Row],[Starttidspunkt]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Dato","Starttidspunkt","Starttidspunkt for lunsj","Sluttidspunkt for lunsj","Sluttidspunkt",{"$f":"IFERROR(IF(COUNT(Timeliste[[#This Row],[Starttidspunkt]:[Sluttidspunkt]])=4,(IF(Timeliste[[#This Row],[Sluttidspunkt]]<Timeliste[[#This Row],[Starttidspunkt]],1,0)+Timeliste[[#This Row],[Sluttidspunkt]])-Timeliste[[#This Row],[Sluttidspunkt for lunsj]]+Timeliste[[#This Row],[Starttidspunkt for lunsj]]-Timeliste[[#This Row],[Starttidspunkt]],IF(AND(LEN(Timeliste[[#This Row],[Starttidspunkt]])<>0,LEN(Timeliste[[#This Row],[Sluttidspunkt]])<>0),(IF(Timeliste[[#This Row],[Sluttidspunkt]]<Timeliste[[#This Row],[Starttidspunkt]],1,0)+Timeliste[[#This Row],[Sluttidspunkt]])-Timeliste[[#This Row],[Starttidspunkt]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Dato","Starttidspunkt","Starttidspunkt for lunsj","Sluttidspunkt for lunsj","Sluttidspunkt",{"$f":"IFERROR(IF(COUNT(Timeliste[[#This Row],[Starttidspunkt]:[Sluttidspunkt]])=4,(IF(Timeliste[[#This Row],[Sluttidspunkt]]<Timeliste[[#This Row],[Starttidspunkt]],1,0)+Timeliste[[#This Row],[Sluttidspunkt]])-Timeliste[[#This Row],[Sluttidspunkt for lunsj]]+Timeliste[[#This Row],[Starttidspunkt for lunsj]]-Timeliste[[#This Row],[Starttidspunkt]],IF(AND(LEN(Timeliste[[#This Row],[Starttidspunkt]])<>0,LEN(Timeliste[[#This Row],[Sluttidspunkt]])<>0),(IF(Timeliste[[#This Row],[Sluttidspunkt]]<Timeliste[[#This Row],[Starttidspunkt]],1,0)+Timeliste[[#This Row],[Sluttidspunkt]])-Timeliste[[#This Row],[Starttidspunkt]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Dato","Starttidspunkt","Starttidspunkt for lunsj","Sluttidspunkt for lunsj","Sluttidspunkt",{"$f":"IFERROR(IF(COUNT(Timeliste[[#This Row],[Starttidspunkt]:[Sluttidspunkt]])=4,(IF(Timeliste[[#This Row],[Sluttidspunkt]]<Timeliste[[#This Row],[Starttidspunkt]],1,0)+Timeliste[[#This Row],[Sluttidspunkt]])-Timeliste[[#This Row],[Sluttidspunkt for lunsj]]+Timeliste[[#This Row],[Starttidspunkt for lunsj]]-Timeliste[[#This Row],[Starttidspunkt]],IF(AND(LEN(Timeliste[[#This Row],[Starttidspunkt]])<>0,LEN(Timeliste[[#This Row],[Sluttidspunkt]])<>0),(IF(Timeliste[[#This Row],[Sluttidspunkt]]<Timeliste[[#This Row],[Starttidspunkt]],1,0)+Timeliste[[#This Row],[Sluttidspunkt]])-Timeliste[[#This Row],[Starttidspunkt]],0))*24,0)","v":{"v":0,"d":"0.00"}}]