{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Method 1","Method 2","Method 3","Method 4","LSI","Method 1 (6)","Method 1 (7)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Method 1","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Employee Attendance"]
[]
[null,"Office ID","Entry Time","Exit Time"]
[null,"0102F","08:00:00",{"$f":"C6+(8/24)","v":"16:00:00"}]
[null,"0112F","08:30:00",{"$f":"C7+(8/24)","v":"16:30:00"}]
[null,"0122F","09:00:00","17:00:00"]
[null,"0132F","09:15:00","17:15:00"]
[null,"0142F","08:45:00","16:45:00"]
[null,"0152F","10:05:00","18:05:00"]
[null,"0162F","08:50:00","16:50:00"]

{"sheet":"Method 2","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Employee Attendance"]
[]
[null,"Office ID","Entry Time","Exit Time"]
[null,"0102F","08:00:00",{"$f":"C6+TIME(8,0,0)","v":"16:00:00"}]
[null,"0112F","08:30:00",{"$f":"C7+TIME(8,0,0)","v":"16:30:00"}]
[null,"0122F","09:00:00","17:00:00"]
[null,"0132F","09:15:00","17:15:00"]
[null,"0142F","08:45:00","16:45:00"]
[null,"0152F","10:05:00","18:05:00"]
[null,"0162F","08:50:00","16:50:00"]

{"sheet":"Method 3","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Employee Attendance"]
[]
[null,"Office ID","Entry Time","Exit Time"]
[null,"0102F","08:00:00",{"$f":"C6+TIMEVALUE(\"8:0:0\")","v":"16:00:00"}]
[null,"0112F","08:30:00",{"$f":"C7+TIMEVALUE(\"8:0:0\")","v":"16:30:00"}]
[null,"0122F","09:00:00","17:00:00"]
[null,"0132F","09:15:00","17:15:00"]
[null,"0142F","08:45:00","16:45:00"]
[null,"0152F","10:05:00","18:05:00"]
[null,"0162F","08:50:00","16:50:00"]

{"sheet":"Method 4","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Employee Attendance"]
[]
[null,"Office ID","Entry Time","Exit Time"]
[null,"0102F","08:00:00","16:00:00"]
[null,"0112F","08:30:00","16:30:00"]
[null,"0122F","09:00:00","17:00:00"]
[null,"0132F","09:15:00","17:15:00"]
[null,"0142F","08:45:00","16:45:00"]
[null,"0152F","10:05:00","18:05:00"]
[null,"0162F","08:50:00","16:50:00"]

{"sheet":"LSI","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Employee Attendance"]
[]
[null,"Office ID","Entry Time","Exit Time"]
[null,"0102F","2023-01-01T20:30:00",{"$f":"C6+(8/24)","v":"2023-01-02T04:30:00"}]
[null,"0102F","2023-01-02T20:15:00",{"$f":"C7+(8/24)","v":"2023-01-03T04:15:00"}]
[null,"0102F","2023-01-03T20:35:00","2023-01-04T04:35:00"]
[null,"0102F","2023-01-04T21:30:00","2023-01-05T05:30:00"]
[null,"0102F","2023-01-05T20:52:00","2023-01-06T04:52:00"]
[null,"0102F","2023-01-06T22:00:00","2023-01-07T06:00:00"]
[null,"0102F","2023-01-07T21:05:00","2023-01-08T05:05:00"]

{"sheet":"Method 1 (6)","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Employee Attendance"]
[]
[null,"Office ID","Entry Time","Exit Time"]
[null,"0102F","08:00:00"]
[null,"0112F","08:30:00"]
[null,"0122F","09:00:00"]
[null,"0132F","09:15:00"]
[null,"0142F","08:45:00"]
[null,"0152F","10:05:00"]
[null,"0162F","08:50:00"]

{"sheet":"Method 1 (7)","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Employee Attendance"]
[]
[null,"Office ID","Entry Time",null,"Exit Time"]
[null,"0102F","08:00:00",null,{"$f":"C6+TIME(8,0,0)","v":"16:00:00"}]
[null,"0112F","08:30:00",null,{"$f":"C7+TIME(8,0,0)","v":"16:30:00"}]
[null,"0122F","09:00:00",null,"17:00:00"]
[null,"0132F","09:15:00",null,"17:15:00"]
[null,"0142F","08:45:00",null,"16:45:00"]
[null,"0152F","10:05:00",null,"18:05:00"]
[null,"0162F","08:50:00",null,{"$f":"C12+TIME(8,0,0)","v":"16:50:00"}]