{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["dataset","CDate","DateValue","Time","Practice"],"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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"X\" Company"]
[]
[null,"Product ID","Order Time","Order Date"]
[null,1234568,20190109063000,"1/9/2019"]
[null,1234569,20190112050000,"1/12/2019"]
[null,1234570,20190127064500,"1/27/2019"]
[null,1234571,20200225073000,"2/25/2020"]
[null,1234572,20200227074000,"2/27/2020"]
[null,1234573,20210305083000,"3/5/2021"]
[null,1234574,20210310093000,"3/10/2021"]

{"sheet":"CDate","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"String to Date Using CDate Function"]
[]
[null,"Product ID","Order Date","Real Date"]
[null,1234568,"1/9/2019","2019-01-09"]
[null,1234569,"1/12/2019","2019-01-12"]
[null,1234570,"1/27/2019","2019-01-27"]
[null,1234571,"2/25/2020","2020-02-25"]
[null,1234572,"2/27/2020","2020-02-27"]
[null,1234573,"3/5/2021","2021-03-05"]
[null,1234574,"3/10/2021","2021-03-10"]

{"sheet":"DateValue","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"String to Date Using DateValue Function"]
[]
[null,"Product ID","Order Date","Real Date"]
[null,1234568,"1/9/2019","2019-01-09"]
[null,1234569,"1/12/2019","2019-01-12"]
[null,1234570,"1/27/2019","2019-01-27"]
[null,1234571,"2/25/2020","2020-02-25"]
[null,1234572,"2/27/2020","2020-02-27"]
[null,1234573,"3/5/2021","2021-03-05"]
[null,1234574,"3/10/2021","2021-03-10"]

{"sheet":"Time","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Conversion to Date and Time"]
[]
[null,"Product ID","Order Time","Real Time"]
[null,1234568,20190109063000,{"$f":"datetimecomb(C5)","v":"2019-01-09T06:30:00"}]
[null,1234569,20190112050000,{"$f":"datetimecomb(C6)","v":"2019-01-12T05:00:00"}]
[null,1234570,20190127064500,{"$f":"datetimecomb(C7)","v":"2019-01-27T06:45:00"}]
[null,1234571,20200225073000,{"$f":"datetimecomb(C8)","v":"2020-02-25T07:30:00"}]
[null,1234572,20200227074000,{"$f":"datetimecomb(C9)","v":"2020-02-27T07:40:00"}]
[null,1234573,20210305083000,{"$f":"datetimecomb(C10)","v":"2021-03-05T08:30:00"}]
[null,1234574,20210310093000,{"$f":"datetimecomb(C11)","v":"2021-03-10T09:30:00"}]

{"sheet":"Practice","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice"]
[]
[null,"Product ID","Order Time","Order Date"]
[null,1234568,20190109063000,"1/9/2019"]
[null,1234569,20190112050000,"1/12/2019"]
[null,1234570,20190127064500,"1/27/2019"]
[null,1234571,20200225073000,"2/25/2020"]
[null,1234572,20200227074000,"2/27/2020"]
[null,1234573,20210305083000,"3/5/2021"]
[null,1234574,20210310093000,"3/10/2021"]