{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset 1","Deselecting Show Comments","Using Keyboard Shortcuts","Using Excel Options","Using VBA Code","Using Resolve Thread"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":12,"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":"Dataset 1","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,3],[1,1,1,4]]}
[]
[null,"Dataset 1"]
[]
[null,"Date","Entry Time","Exit Time","Work Hour"]
[null,"2022-05-08","09:30:00","18:30:00",{"$f":"D5-C5","v":0.37500000000000006}]
[null,"2022-05-09","08:30:00","17:30:00",{"$f":"D6-C6","v":0.37499999999999994}]
[null,"2022-05-10","09:00:00","17:00:00",0.33333333333333337]
[null,"2022-05-11","08:00:00","16:00:00",0.33333333333333331]
[null,"2022-05-12","08:45:00","17:35:00",0.36805555555555552]
[null,"2022-05-13","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-14","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-15","08:55:00","18:20:00",0.3923611111111111]
[null,"Total Weekly Hour",null,null,{"$f":"SUM(E5:E12)","v":2.1770833333333335}]

{"sheet":"Deselecting Show Comments","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,3]]}
[]
[null,"Deselecting Show Comments Button"]
[]
[null,"Date","Entry Time","Exit Time","Work Hour"]
[null,"2022-05-08","09:30:00","18:30:00",{"$f":"D5-C5","v":0.37500000000000006}]
[null,"2022-05-09","08:30:00","17:30:00",{"$f":"D6-C6","v":0.37499999999999994}]
[null,"2022-05-10","09:00:00","17:00:00",0.33333333333333337]
[null,"2022-05-11","08:00:00","16:00:00",0.33333333333333331]
[null,"2022-05-12","08:45:00","17:35:00",0.36805555555555552]
[null,"2022-05-13","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-14","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-15","08:55:00","18:20:00",0.3923611111111111]
[null,"Total Weekly Hour",null,null,{"$f":"SUM(E5:E12)","v":2.1770833333333335}]

{"sheet":"Using Keyboard Shortcuts","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,3]]}
[]
[null,"Using Keyboard Shortcuts"]
[]
[null,"Date","Entry Time","Exit Time","Work Hour"]
[null,"2022-05-08","09:30:00","18:30:00",{"$f":"D5-C5","v":0.37500000000000006}]
[null,"2022-05-09","08:30:00","17:30:00",{"$f":"D6-C6","v":0.37499999999999994}]
[null,"2022-05-10","09:00:00","17:00:00",0.33333333333333337]
[null,"2022-05-11","08:00:00","16:00:00",0.33333333333333331]
[null,"2022-05-12","08:45:00","17:35:00",0.36805555555555552]
[null,"2022-05-13","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-14","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-15","08:55:00","18:20:00",0.3923611111111111]
[null,"Total Weekly Hour",null,null,{"$f":"SUM(E5:E12)","v":2.1770833333333335}]

{"sheet":"Using Excel Options","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,3]]}
[]
[null,"Using Excel Options"]
[]
[null,"Date","Entry Time","Exit Time","Work Hour"]
[null,"2022-05-08","09:30:00","18:30:00",{"$f":"D5-C5","v":0.37500000000000006}]
[null,"2022-05-09","08:30:00","17:30:00",{"$f":"D6-C6","v":0.37499999999999994}]
[null,"2022-05-10","09:00:00","17:00:00",0.33333333333333337]
[null,"2022-05-11","08:00:00","16:00:00",0.33333333333333331]
[null,"2022-05-12","08:45:00","17:35:00",0.36805555555555552]
[null,"2022-05-13","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-14","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-15","08:55:00","18:20:00",0.3923611111111111]
[null,"Total Weekly Hour",null,null,{"$f":"SUM(E5:E12)","v":2.1770833333333335}]

{"sheet":"Using VBA Code","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,3]]}
[]
[null,"Using VBA Code"]
[]
[null,"Date","Entry Time","Exit Time","Work Hour"]
[null,"2022-05-08","09:30:00","18:30:00",{"$f":"D5-C5","v":0.37500000000000006}]
[null,"2022-05-09","08:30:00","17:30:00",{"$f":"D6-C6","v":0.37499999999999994}]
[null,"2022-05-10","09:00:00","17:00:00",0.33333333333333337]
[null,"2022-05-11","08:00:00","16:00:00",0.33333333333333331]
[null,"2022-05-12","08:45:00","17:35:00",0.36805555555555552]
[null,"2022-05-13","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-14","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-15","08:55:00","18:20:00",0.3923611111111111]
[null,"Total Weekly Hour",null,null,{"$f":"SUM(E5:E12)","v":2.1770833333333335}]

{"sheet":"Using Resolve Thread","index":5,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,1,12,3]]}
[]
[null,"Using Resolve Thread"]
[]
[null,"Date","Entry Time","Exit Time","Work Hour"]
[null,"2022-05-08","09:30:00","18:30:00",{"$f":"D5-C5","v":0.37500000000000006}]
[null,"2022-05-09","08:30:00","17:30:00",{"$f":"D6-C6","v":0.37499999999999994}]
[null,"2022-05-10","09:00:00","17:00:00",0.33333333333333337]
[null,"2022-05-11","08:00:00","16:00:00",0.33333333333333331]
[null,"2022-05-12","08:45:00","17:35:00",0.36805555555555552]
[null,"2022-05-13","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-14","Weekend","Weekend",{"$f":"CONCATENATE(\"0\", \":\",\"00\")","v":"0:00"}]
[null,"2022-05-15","08:55:00","18:20:00",0.3923611111111111]
[null,"Total Weekly Hour",null,null,{"$f":"SUM(E5:E12)","v":2.1770833333333335}]