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

{"sheet":"考勤记录","index":0,"n_rows":12,"n_cols":7,"rows_kept":12}
[null,"考勤记录"]
[null,"员工详细信息：","姓名","电子邮件","电话"]
[null,"经理详细信息：","姓名"]
[null,"周期开始日期","周期结束日期"]
[null,"每周工作\n总时数","总工作\n时数","正常工作时数","加班小时数"]
[null,{"v":40,"d":"40.00"},{"$f":"SUBTOTAL(109,考勤记录[工作时数])","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF(C6<=每周工时,C6,每周工时),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(C6-D6, \"\")","v":{"v":0,"d":"0.00"}}]
[null,"日期","上班时间","午餐开始时间","午餐结束时间","下班时间","工作时数"]
[null,"日期","上班时间","午餐开始时间","午餐结束时间","下班时间",{"$f":"IFERROR(IF(COUNT(考勤记录[[#This Row],[上班时间]:[下班时间]])=4,(IF(考勤记录[[#This Row],[下班时间]]<考勤记录[[#This Row],[上班时间]],1,0)+考勤记录[[#This Row],[下班时间]])-考勤记录[[#This Row],[午餐结束时间]]+考勤记录[[#This Row],[午餐开始时间]]-考勤记录[[#This Row],[上班时间]],IF(AND(LEN(考勤记录[[#This Row],[上班时间]])<>0,LEN(考勤记录[[#This Row],[下班时间]])<>0),(IF(考勤记录[[#This Row],[下班时间]]<考勤记录[[#This Row],[上班时间]],1,0)+考勤记录[[#This Row],[下班时间]])-考勤记录[[#This Row],[上班时间]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"日期","上班时间","午餐开始时间","午餐结束时间","下班时间",{"$f":"IFERROR(IF(COUNT(考勤记录[[#This Row],[上班时间]:[下班时间]])=4,(IF(考勤记录[[#This Row],[下班时间]]<考勤记录[[#This Row],[上班时间]],1,0)+考勤记录[[#This Row],[下班时间]])-考勤记录[[#This Row],[午餐结束时间]]+考勤记录[[#This Row],[午餐开始时间]]-考勤记录[[#This Row],[上班时间]],IF(AND(LEN(考勤记录[[#This Row],[上班时间]])<>0,LEN(考勤记录[[#This Row],[下班时间]])<>0),(IF(考勤记录[[#This Row],[下班时间]]<考勤记录[[#This Row],[上班时间]],1,0)+考勤记录[[#This Row],[下班时间]])-考勤记录[[#This Row],[上班时间]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"日期","上班时间","午餐开始时间","午餐结束时间","下班时间",{"$f":"IFERROR(IF(COUNT(考勤记录[[#This Row],[上班时间]:[下班时间]])=4,(IF(考勤记录[[#This Row],[下班时间]]<考勤记录[[#This Row],[上班时间]],1,0)+考勤记录[[#This Row],[下班时间]])-考勤记录[[#This Row],[午餐结束时间]]+考勤记录[[#This Row],[午餐开始时间]]-考勤记录[[#This Row],[上班时间]],IF(AND(LEN(考勤记录[[#This Row],[上班时间]])<>0,LEN(考勤记录[[#This Row],[下班时间]])<>0),(IF(考勤记录[[#This Row],[下班时间]]<考勤记录[[#This Row],[上班时间]],1,0)+考勤记录[[#This Row],[下班时间]])-考勤记录[[#This Row],[上班时间]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"日期","上班时间","午餐开始时间","午餐结束时间","下班时间",{"$f":"IFERROR(IF(COUNT(考勤记录[[#This Row],[上班时间]:[下班时间]])=4,(IF(考勤记录[[#This Row],[下班时间]]<考勤记录[[#This Row],[上班时间]],1,0)+考勤记录[[#This Row],[下班时间]])-考勤记录[[#This Row],[午餐结束时间]]+考勤记录[[#This Row],[午餐开始时间]]-考勤记录[[#This Row],[上班时间]],IF(AND(LEN(考勤记录[[#This Row],[上班时间]])<>0,LEN(考勤记录[[#This Row],[下班时间]])<>0),(IF(考勤记录[[#This Row],[下班时间]]<考勤记录[[#This Row],[上班时间]],1,0)+考勤记录[[#This Row],[下班时间]])-考勤记录[[#This Row],[上班时间]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"日期","上班时间","午餐开始时间","午餐结束时间","下班时间",{"$f":"IFERROR(IF(COUNT(考勤记录[[#This Row],[上班时间]:[下班时间]])=4,(IF(考勤记录[[#This Row],[下班时间]]<考勤记录[[#This Row],[上班时间]],1,0)+考勤记录[[#This Row],[下班时间]])-考勤记录[[#This Row],[午餐结束时间]]+考勤记录[[#This Row],[午餐开始时间]]-考勤记录[[#This Row],[上班时间]],IF(AND(LEN(考勤记录[[#This Row],[上班时间]])<>0,LEN(考勤记录[[#This Row],[下班时间]])<>0),(IF(考勤记录[[#This Row],[下班时间]]<考勤记录[[#This Row],[上班时间]],1,0)+考勤记录[[#This Row],[下班时间]])-考勤记录[[#This Row],[上班时间]],0))*24,0)","v":{"v":0,"d":"0.00"}}]