{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["main","1.Date+Time","2.Convert","3.VBA"],"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":"main","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Converting 13 Digit Timestamp to Date Time in Excel"]
[]
[null,"Timestamp","Length","Date Time (GMT)"]
[null,"1666663684000",{"$f":"LEN(B5)","v":13},{"$f":"B5/86400000+DATE(1970,1,1)","v":"2022-10-25T02:08:04"}]
[null,"1108634704000",{"$f":"LEN(B6)","v":13},{"$f":"B6/86400000+DATE(1970,1,1)","v":"2005-02-17T10:05:04"}]
[null,"1510884484000",13,"2017-11-17T02:08:04"]
[null,"1655499904000",13,"2022-06-17T21:05:04"]
[null,"1660727284000",13,"2022-08-17T09:08:04"]
[null,"1668168604000",13,"2022-11-11T12:10:04"]

{"sheet":"1.Date+Time","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining Arithmetic Formula with DATE and Time Functions"]
[]
[null,"Timestamp","Date Time (GMT)","ET (GMT-4)"]
[null,"1666663684000",{"$f":"B5/86400000+DATE(1970,1,1)","v":"2022-10-25T02:08:04"},{"$f":"C5-TIME(4,0,0)","v":"2022-10-24T22:08:04"}]
[null,"1108634704000",{"$f":"B6/86400000+DATE(1970,1,1)","v":"2005-02-17T10:05:04"},{"$f":"C6-TIME(4,0,0)","v":"2005-02-17T06:05:04"}]
[null,"1510884484000","2017-11-17T02:08:04","2017-11-16T22:08:04"]
[null,"1655499904000","2022-06-17T21:05:04","2022-06-17T17:05:04"]
[null,"1660727284000","2022-08-17T09:08:04","2022-08-17T05:08:04"]
[null,"1668168604000","2022-11-11T12:10:04","2022-11-11T08:10:04"]

{"sheet":"2.Convert","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using CONVERT Function"]
[]
[null,"Timestamp","Date Time (GMT)"]
[null,"1666663684000",{"$f":"CONVERT(B5,\"msec\",\"day\")+25569","v":"2022-10-25T02:08:04"}]
[null,"1108634704000","2005-02-17T10:05:04"]
[null,"1510884484000","2017-11-17T02:08:04"]
[null,"1655499904000","2022-06-17T21:05:04"]
[null,"1660727284000","2022-08-17T09:08:04"]
[null,"1668168604000","2022-11-11T12:10:04"]

{"sheet":"3.VBA","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Timestamp","Date Time (GMT)"]
[null,"1666663684000","2022-10-25T02:08:04"]
[null,"1108634704000","2005-02-17T10:05:04"]
[null,"1510884484000","2017-11-17T02:08:04"]
[null,"1655499904000","2022-06-17T21:05:04"]
[null,"1660727284000","2022-08-17T09:08:04"]
[null,"1668168604000","2022-11-11T12:10:04"]