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

{"sheet":"Tidrapport","index":0,"n_rows":12,"n_cols":7,"rows_kept":12}
[null,"Tidrapport"]
[null,"Information om anställd:","Namn","E-post","Telefon"]
[null,"Information om chef:","Namn"]
[null,"Period, startdatum","Period, slutdatum"]
[null,"Totalt antal arbetstimmar per vecka  ","Totalt antal arbetade timmar ","Normal arbetstid","Övertidstimmar"]
[null,{"v":40,"d":"40.00"},{"$f":"SUBTOTAL(109,Tidrapport[Arbetade timmar])","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF(C6<=Timmar_arbetsvecka,C6,Timmar_arbetsvecka),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(C6-D6, \"\")","v":{"v":0,"d":"0.00"}}]
[null,"Datum","Tid in","Lunch, start","Lunch, slut","Tid ut","Arbetade timmar"]
[null,"Datum","Tid in","Lunch, start","Lunch, slut","Tid ut",{"$f":"IFERROR(IF(COUNT(Tidrapport[[#This Row],[Tid in]:[Tid ut]])=4,(IF(Tidrapport[[#This Row],[Tid ut]]<Tidrapport[[#This Row],[Tid in]],1,0)+Tidrapport[[#This Row],[Tid ut]])-Tidrapport[[#This Row],[Lunch, slut]]+Tidrapport[[#This Row],[Lunch, start]]-Tidrapport[[#This Row],[Tid in]],IF(AND(LEN(Tidrapport[[#This Row],[Tid in]])<>0,LEN(Tidrapport[[#This Row],[Tid ut]])<>0),(IF(Tidrapport[[#This Row],[Tid ut]]<Tidrapport[[#This Row],[Tid in]],1,0)+Tidrapport[[#This Row],[Tid ut]])-Tidrapport[[#This Row],[Tid in]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Datum","Tid in","Lunch, start","Lunch, slut","Tid ut",{"$f":"IFERROR(IF(COUNT(Tidrapport[[#This Row],[Tid in]:[Tid ut]])=4,(IF(Tidrapport[[#This Row],[Tid ut]]<Tidrapport[[#This Row],[Tid in]],1,0)+Tidrapport[[#This Row],[Tid ut]])-Tidrapport[[#This Row],[Lunch, slut]]+Tidrapport[[#This Row],[Lunch, start]]-Tidrapport[[#This Row],[Tid in]],IF(AND(LEN(Tidrapport[[#This Row],[Tid in]])<>0,LEN(Tidrapport[[#This Row],[Tid ut]])<>0),(IF(Tidrapport[[#This Row],[Tid ut]]<Tidrapport[[#This Row],[Tid in]],1,0)+Tidrapport[[#This Row],[Tid ut]])-Tidrapport[[#This Row],[Tid in]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Datum","Tid in","Lunch, start","Lunch, slut","Tid ut",{"$f":"IFERROR(IF(COUNT(Tidrapport[[#This Row],[Tid in]:[Tid ut]])=4,(IF(Tidrapport[[#This Row],[Tid ut]]<Tidrapport[[#This Row],[Tid in]],1,0)+Tidrapport[[#This Row],[Tid ut]])-Tidrapport[[#This Row],[Lunch, slut]]+Tidrapport[[#This Row],[Lunch, start]]-Tidrapport[[#This Row],[Tid in]],IF(AND(LEN(Tidrapport[[#This Row],[Tid in]])<>0,LEN(Tidrapport[[#This Row],[Tid ut]])<>0),(IF(Tidrapport[[#This Row],[Tid ut]]<Tidrapport[[#This Row],[Tid in]],1,0)+Tidrapport[[#This Row],[Tid ut]])-Tidrapport[[#This Row],[Tid in]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Datum","Tid in","Lunch, start","Lunch, slut","Tid ut",{"$f":"IFERROR(IF(COUNT(Tidrapport[[#This Row],[Tid in]:[Tid ut]])=4,(IF(Tidrapport[[#This Row],[Tid ut]]<Tidrapport[[#This Row],[Tid in]],1,0)+Tidrapport[[#This Row],[Tid ut]])-Tidrapport[[#This Row],[Lunch, slut]]+Tidrapport[[#This Row],[Lunch, start]]-Tidrapport[[#This Row],[Tid in]],IF(AND(LEN(Tidrapport[[#This Row],[Tid in]])<>0,LEN(Tidrapport[[#This Row],[Tid ut]])<>0),(IF(Tidrapport[[#This Row],[Tid ut]]<Tidrapport[[#This Row],[Tid in]],1,0)+Tidrapport[[#This Row],[Tid ut]])-Tidrapport[[#This Row],[Tid in]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Datum","Tid in","Lunch, start","Lunch, slut","Tid ut",{"$f":"IFERROR(IF(COUNT(Tidrapport[[#This Row],[Tid in]:[Tid ut]])=4,(IF(Tidrapport[[#This Row],[Tid ut]]<Tidrapport[[#This Row],[Tid in]],1,0)+Tidrapport[[#This Row],[Tid ut]])-Tidrapport[[#This Row],[Lunch, slut]]+Tidrapport[[#This Row],[Lunch, start]]-Tidrapport[[#This Row],[Tid in]],IF(AND(LEN(Tidrapport[[#This Row],[Tid in]])<>0,LEN(Tidrapport[[#This Row],[Tid ut]])<>0),(IF(Tidrapport[[#This Row],[Tid ut]]<Tidrapport[[#This Row],[Tid in]],1,0)+Tidrapport[[#This Row],[Tid ut]])-Tidrapport[[#This Row],[Tid in]],0))*24,0)","v":{"v":0,"d":"0.00"}}]