{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["주간 근무 시간 기록표"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"주간 근무 시간 기록표","index":0,"n_rows":25,"n_cols":11,"rows_kept":25,"merged":[[0,1,0,10],[2,2,2,7],[3,2,3,7],[4,2,4,7],[5,2,5,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[21,5,21,9],[23,5,23,9]]}
[null,"주간 근무 시간 기록표"]
[null,"회사 이름"]
[null,"주소:",{"$nulls":7},"주 종료 날짜:"]
[null,"주소 2:"]
[null,"주소 3:",{"$nulls":7},"직원:"]
[null,"시/도, 우편 번호:",{"$nulls":7},"관리자:"]
[null,"전화:",{"$nulls":7},"직원 전화 번호:"]
[null,"팩스:",{"$nulls":7},"직원 전자 메일:"]
[null,"전자 메일:",{"$nulls":7},"세금 ID#:"]
[]
[null,"요일","출근","퇴근","출근 ","퇴근 ","규정 근무 시간","초과 근무 시간","병가 시간","휴가 시간","합계"]
[null,"월요일","08:00:00","11:00:00","12:00:00","18:00:00",{"$f":"IFERROR(IF((((D12-C12)+(F12-E12))*24)>8,8,((D12-C12)+(F12-E12))*24), \"\")","v":{"v":8,"d":"8.00"}},{"$f":"IFERROR(IF(((D12-C12)+(F12-E12))*24>8,((D12-C12)+(F12-E12))*24-8,0), \"\")","v":{"v":1,"d":"1.00"}},null,null,{"$f":"IFERROR(SUM(G12:J12), \"\")","v":{"v":9,"d":"9.00"}}]
[null,"화요일",{"$nulls":4},{"$f":"IFERROR(IF((((D13-C13)+(F13-E13))*24)>8,8,((D13-C13)+(F13-E13))*24), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF(((D13-C13)+(F13-E13))*24>8,((D13-C13)+(F13-E13))*24-8,0), \"\")","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"}]
[null,"수요일",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"목요일",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"금요일",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"토요일",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"일요일",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},"총 시간",{"$f":"SUM(G12:G18)","v":{"v":8,"d":"8.00"}},{"$f":"SUM(H12:H18)","v":{"v":1,"d":"1.00"}},{"$f":"SUM(I12:I18)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J12:J18)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(TimeSheet[합계])","v":{"v":9,"d":"9.00"}}]
[{"$nulls":5},"시간당 급여",{"v":20000,"d":"₩20,000.00"},{"v":30000,"d":"₩30,000.00"}]
[{"$nulls":5},"급여 합계",{"$f":"G19*G20","v":{"v":160000,"d":"₩160,000.00"}},{"$f":"H19*H20","v":{"v":30000,"d":"₩30,000.00"}},{"$f":"I19*I20","v":{"v":0,"d":"₩0.00"}},{"$f":"J19*J20","v":{"v":0,"d":"₩0.00"}},{"$f":"SUM(G21:J21)","v":{"v":190000,"d":"₩190,000.00"}}]
[]
[{"$nulls":5},"직원 서명",{"$nulls":4},"날짜"]
[]
[{"$nulls":5},"관리자 서명",{"$nulls":4},"날짜"]