{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","hh-mm-ss","dd-mm-yyyy","Subtract Hours","Current-Time","Current-Subtract hours"],"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":"Dataset","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Traveler","Timestamp GMT"]
[null,"Mike","18:11:00"]
[null,"Adam","08:27:00"]
[null,"Hopper","23:23:00"]
[null,"Stuart","03:45:00"]
[null,"David","17:19:00"]

{"sheet":"hh-mm-ss","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Converting (hh:mm:ss AM/PM) Format"]
[]
[null,"Traveler","Timestamp GMT","Timestamp EST"]
[null,"Mike","18:11:00",{"$f":"C5+1-TIME(5,0,0)","v":1.5493055555555555}]
[null,"Adam","08:27:00",{"$f":"C6+1-TIME(5,0,0)","v":1.14375}]
[null,"Hopper","23:23:00",1.7659722222222223]
[null,"Stuart","03:45:00","22:45:00"]
[null,"David","17:19:00",1.5131944444444445]

{"sheet":"dd-mm-yyyy","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Converting (DD-MM-YY hh:mm:ss) Format"]
[]
[null,"Traveler","Timestamp GMT","Timestamp EST"]
[null,"Mike","2022-08-28T18:11:00",{"$f":"C5-TIME(5,0,0)","v":"2022-08-28T13:11:00"}]
[null,"Adam","2022-08-27T08:27:00",{"$f":"C6-TIME(5,0,0)","v":"2022-08-27T03:27:00"}]
[null,"Hopper","2022-08-28T23:23:00","2022-08-28T18:23:00"]
[null,"Stuart","2022-08-26T03:45:00","2022-08-25T22:45:00"]
[null,"David","2022-08-25T17:19:00","2022-08-25T12:19:00"]

{"sheet":"Subtract Hours","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Unhiding Sheet Tab with Tab Bar Option"]
[]
[null,"Traveler","Timestamp GMT","Timestamp EST"]
[null,"Mike","2022-08-28T18:11:00",{"$f":"C5-5/24","v":"2022-08-28T13:11:00"}]
[null,"Adam","2022-08-27T08:27:00",{"$f":"C6-5/24","v":"2022-08-27T03:27:00"}]
[null,"Hopper","2022-08-28T23:23:00","2022-08-28T18:23:00"]
[null,"Stuart","2022-08-26T03:45:00","2022-08-25T22:45:00"]
[null,"David","2022-08-25T17:19:00","2022-08-25T12:19:00"]

{"sheet":"Current-Time","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,2,8,2]]}
[]
[null,"Converting Current Time Using TIME Function"]
[]
[null,"Traveler","Timestamp EST"]
[null,"Mike",{"$f":"NOW()-TIME(5,0,0)","v":"2022-09-12T04:10:50.450"}]
[null,"Adam"]
[null,"Hopper"]
[null,"Stuart"]
[null,"David"]

{"sheet":"Current-Subtract hours","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,2,8,2]]}
[]
[null,"Converting Current Time by Subracting Hours"]
[]
[null,"Traveler","Timestamp EST"]
[null,"Mike",{"$f":"NOW()-5/24","v":"2022-09-12T04:10:50.450"}]
[null,"Adam"]
[null,"Hopper"]
[null,"Stuart"]
[null,"David"]