{"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,"工作週總時數","總工時","正常工時","加班時數"]
[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"}}]