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

{"sheet":"Timesheet","index":0,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[1,1,3,3]]}
[]
[null,"Timesheet",{"$nulls":3},"EMPLOYEE DETAILS:","Takuma Hayashi"]
[{"$nulls":6},"takuma@contoso.com"]
[{"$nulls":6},"(415) 555-0123"]
[]
[null,"TOTAL WORK \nWEEK HOURS","TOTAL HOURS \nWORKED","REGULAR \nHOURS","OVERTIME \nHOURS","MANAGER:","Smiriti Sisodiya"]
[null,{"v":40,"d":"40.00"},{"$f":"SUBTOTAL(109,TimeSheet[HOURS WORKED])","v":{"v":35.00000000000001,"d":"35.00"}},{"$f":"IFERROR(IF(C7<=WorkweekHours,C7,WorkweekHours),\"\")","v":{"v":35.00000000000001,"d":"35.00"}},{"$f":"IFERROR(C7-D7, \"\")","v":{"v":0,"d":"0.00"}},"2023-01-01","2023-01-15"]
[]
[null,"DATE(S)","TIME IN","LUNCH START","LUNCH END","TIME OUT","HOURS WORKED"]
[null,"2023-01-03","09:00:00","11:00:00","12:00:00","17:00:00",{"$f":"IFERROR(IF(COUNT(TimeSheet[[#This Row],[TIME IN]:[TIME OUT]])=4,(IF(TimeSheet[[#This Row],[TIME OUT]]<TimeSheet[[#This Row],[TIME IN]],1,0)+TimeSheet[[#This Row],[TIME OUT]])-TimeSheet[[#This Row],[LUNCH END]]+TimeSheet[[#This Row],[LUNCH START]]-TimeSheet[[#This Row],[TIME IN]],IF(AND(LEN(TimeSheet[[#This Row],[TIME IN]])<>0,LEN(TimeSheet[[#This Row],[TIME OUT]])<>0),(IF(TimeSheet[[#This Row],[TIME OUT]]<TimeSheet[[#This Row],[TIME IN]],1,0)+TimeSheet[[#This Row],[TIME OUT]])-TimeSheet[[#This Row],[TIME IN]],0))*24,0)","v":{"v":7.000000000000002,"d":"7.00"}}]
[null,"2023-01-04","09:00:00","11:00:00","12:00:00","17:00:00",{"$f":"IFERROR(IF(COUNT(TimeSheet[[#This Row],[TIME IN]:[TIME OUT]])=4,(IF(TimeSheet[[#This Row],[TIME OUT]]<TimeSheet[[#This Row],[TIME IN]],1,0)+TimeSheet[[#This Row],[TIME OUT]])-TimeSheet[[#This Row],[LUNCH END]]+TimeSheet[[#This Row],[LUNCH START]]-TimeSheet[[#This Row],[TIME IN]],IF(AND(LEN(TimeSheet[[#This Row],[TIME IN]])<>0,LEN(TimeSheet[[#This Row],[TIME OUT]])<>0),(IF(TimeSheet[[#This Row],[TIME OUT]]<TimeSheet[[#This Row],[TIME IN]],1,0)+TimeSheet[[#This Row],[TIME OUT]])-TimeSheet[[#This Row],[TIME IN]],0))*24,0)","v":{"v":7.000000000000002,"d":"7.00"}}]
[null,"2023-01-05","09:00:00","11:00:00","12:00:00","17:00:00",{"$f":"IFERROR(IF(COUNT(TimeSheet[[#This Row],[TIME IN]:[TIME OUT]])=4,(IF(TimeSheet[[#This Row],[TIME OUT]]<TimeSheet[[#This Row],[TIME IN]],1,0)+TimeSheet[[#This Row],[TIME OUT]])-TimeSheet[[#This Row],[LUNCH END]]+TimeSheet[[#This Row],[LUNCH START]]-TimeSheet[[#This Row],[TIME IN]],IF(AND(LEN(TimeSheet[[#This Row],[TIME IN]])<>0,LEN(TimeSheet[[#This Row],[TIME OUT]])<>0),(IF(TimeSheet[[#This Row],[TIME OUT]]<TimeSheet[[#This Row],[TIME IN]],1,0)+TimeSheet[[#This Row],[TIME OUT]])-TimeSheet[[#This Row],[TIME IN]],0))*24,0)","v":{"v":7.000000000000002,"d":"7.00"}}]
[null,"2023-01-06","09:00:00","11:00:00","12:00:00","17:00:00",{"$f":"IFERROR(IF(COUNT(TimeSheet[[#This Row],[TIME IN]:[TIME OUT]])=4,(IF(TimeSheet[[#This Row],[TIME OUT]]<TimeSheet[[#This Row],[TIME IN]],1,0)+TimeSheet[[#This Row],[TIME OUT]])-TimeSheet[[#This Row],[LUNCH END]]+TimeSheet[[#This Row],[LUNCH START]]-TimeSheet[[#This Row],[TIME IN]],IF(AND(LEN(TimeSheet[[#This Row],[TIME IN]])<>0,LEN(TimeSheet[[#This Row],[TIME OUT]])<>0),(IF(TimeSheet[[#This Row],[TIME OUT]]<TimeSheet[[#This Row],[TIME IN]],1,0)+TimeSheet[[#This Row],[TIME OUT]])-TimeSheet[[#This Row],[TIME IN]],0))*24,0)","v":{"v":7.000000000000002,"d":"7.00"}}]
[null,"2023-01-09","09:00:00","11:00:00","12:00:00","17:00:00",{"$f":"IFERROR(IF(COUNT(TimeSheet[[#This Row],[TIME IN]:[TIME OUT]])=4,(IF(TimeSheet[[#This Row],[TIME OUT]]<TimeSheet[[#This Row],[TIME IN]],1,0)+TimeSheet[[#This Row],[TIME OUT]])-TimeSheet[[#This Row],[LUNCH END]]+TimeSheet[[#This Row],[LUNCH START]]-TimeSheet[[#This Row],[TIME IN]],IF(AND(LEN(TimeSheet[[#This Row],[TIME IN]])<>0,LEN(TimeSheet[[#This Row],[TIME OUT]])<>0),(IF(TimeSheet[[#This Row],[TIME OUT]]<TimeSheet[[#This Row],[TIME IN]],1,0)+TimeSheet[[#This Row],[TIME OUT]])-TimeSheet[[#This Row],[TIME IN]],0))*24,0)","v":{"v":7.000000000000002,"d":"7.00"}}]