{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["TIME_&_MID","TIME_MID_RIGHT_&_LEFT","DATE","CONVERT","VBA","Format_Cells","TEXT","TEXT_&_TRUNC","TIME","Text_to_Columns","13-digit_Timestamp"],"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":"TIME_&_MID","index":0,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Combination of TIME & MID Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Time",null,null,null,null,"Timestamp","Time"]
[null,"00h08m05s",{"$f":"TIME(MID(B5,1,2),MID(B5,4,2),MID(B5,7,2))","v":"00:08:05"},null,null,null,null,"00h08m05s"]
[null,"02h13m15s",{"$f":"TIME(MID(B6,1,2),MID(B6,4,2),MID(B6,7,2))","v":"02:13:15"},null,null,null,null,"02h13m15s"]
[null,"06h34m54s","06:34:54",null,null,null,null,"06h34m54s"]
[null,"08h32m23s","08:32:23",null,null,null,null,"08h32m23s"]
[null,"10h23m45s","10:23:45",null,null,null,null,"10h23m45s"]
[null,"12h45m32s","12:45:32",null,null,null,null,"12h45m32s"]
[null,"16h12m43s","16:12:43",null,null,null,null,"16h12m43s"]
[null,"18h17m39s","18:17:39",null,null,null,null,"18h17m39s"]
[null,"21h19m52s","21:19:52",null,null,null,null,"21h19m52s"]
[null,"23h11m18s","23:11:18",null,null,null,null,"23h11m18s"]

{"sheet":"TIME_MID_RIGHT_&_LEFT","index":1,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Combining TIME, MID, RIGHT & LEFT Functions ",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Time",null,null,null,null,"Timestamp","Time"]
[null,"00h08m05",{"$f":"TIME(LEFT(B5,2),MID(B5,4,2),RIGHT(B5,2))","v":"00:08:05"},null,null,null,null,"00h08m05"]
[null,"02h13m15",{"$f":"TIME(LEFT(B6,2),MID(B6,4,2),RIGHT(B6,2))","v":"02:13:15"},null,null,null,null,"02h13m15"]
[null,"06h34m54","06:34:54",null,null,null,null,"06h34m54"]
[null,"08h32m23","08:32:23",null,null,null,null,"08h32m23"]
[null,"10h23m45","10:23:45",null,null,null,null,"10h23m45"]
[null,"12h45m32","12:45:32",null,null,null,null,"12h45m32"]
[null,"16h12m43","16:12:43",null,null,null,null,"16h12m43"]
[null,"18h17m39","18:17:39",null,null,null,null,"18h17m39"]
[null,"21h19m52","21:19:52",null,null,null,null,"21h19m52"]
[null,"23h11m18","23:11:18",null,null,null,null,"23h11m18"]

{"sheet":"DATE","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Excel DATE Function to Convert Unix Timestamp",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Time (GMT)",null,null,null,null,"Timestamp","Time (GMT)"]
[null,1108634704,{"$f":"(B5/86400)+DATE(1970,1,1)","v":38400.420185185183},null,null,null,null,1108634704]
[null,1395014400,{"$f":"(B6/86400)+DATE(1970,1,1)","v":41715},null,null,null,null,1395014400]
[null,1408227739,41867.932164351849,null,null,null,null,1408227739]
[null,1510884484,43056.08893518518,null,null,null,null,1510884484]
[null,1655499904,44729.878518518519,null,null,null,null,1655499904]
[null,1660727284,44790.380601851852,null,null,null,null,1660727284]
[null,1666663684,44859.08893518518,null,null,null,null,1666663684]
[null,1668168604,44876.506990740745,null,null,null,null,1668168604]
[null,1710000000,45360.666666666672,null,null,null,null,1710000000]
[null,1710340000,45364.601851851854,null,null,null,null,1710340000]

{"sheet":"CONVERT","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Use of Excel CONVERT Function",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Time (GMT)",null,null,null,null,"Timestamp","Time (GMT)"]
[null,1108634704,{"$f":"CONVERT(B5,\"sec\",\"day\")+25569","v":38400.420185185183},null,null,null,null,1108634704]
[null,1395014400,{"$f":"CONVERT(B6,\"sec\",\"day\")+25569","v":41715},null,null,null,null,1395014400]
[null,1408227739,41867.932164351849,null,null,null,null,1408227739]
[null,1510884484,43056.08893518518,null,null,null,null,1510884484]
[null,1655499904,44729.878518518519,null,null,null,null,1655499904]
[null,1660727284,44790.380601851852,null,null,null,null,1660727284]
[null,1666663684,44859.08893518518,null,null,null,null,1666663684]
[null,1668168604,44876.506990740745,null,null,null,null,1668168604]
[null,1710000000,45360.666666666672,null,null,null,null,1710000000]
[null,1710340000,45364.601851851854,null,null,null,null,1710340000]

{"sheet":"VBA","index":4,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Excel VBA to Convert Unix Timestamp",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Time (GMT)",null,null,null,null,"Timestamp","Time (GMT)"]
[null,1108634704,38400.420185185183,null,null,null,null,1108634704]
[null,1395014400,41715,null,null,null,null,1395014400]
[null,1408227739,41867.932164351849,null,null,null,null,1408227739]
[null,1510884484,43056.08893518518,null,null,null,null,1510884484]
[null,1655499904,44729.878518518519,null,null,null,null,1655499904]
[null,1660727284,44790.380601851852,null,null,null,null,1660727284]
[null,1666663684,44859.08893518518,null,null,null,null,1666663684]
[null,1668168604,44876.506990740745,null,null,null,null,1668168604]
[null,1710000000,45360.666666666672,null,null,null,null,1710000000]
[null,1710340000,45364.601851851854,null,null,null,null,1710340000]

{"sheet":"Format_Cells","index":5,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Applying Format Cells Option",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Time ",null,null,null,null,"Timestamp","Time "]
[null,"2005-02-17T10:05:04",{"$f":"B5","v":38400.420185185183},null,null,null,null,"2005-02-17T10:05:04"]
[null,"2014-03-17",{"$f":"B6","v":41715},null,null,null,null,"2014-03-17"]
[null,"2014-08-16T22:22:19",41867.932164351849,null,null,null,null,"2014-08-16T22:22:19"]
[null,"2017-11-17T02:08:04",43056.08893518518,null,null,null,null,"2017-11-17T02:08:04"]
[null,"2022-06-17T21:05:04",44729.878518518519,null,null,null,null,"2022-06-17T21:05:04"]
[null,"2022-08-17T09:08:04",44790.380601851852,null,null,null,null,"2022-08-17T09:08:04"]
[null,"2022-10-25T02:08:04",44859.08893518518,null,null,null,null,"2022-10-25T02:08:04"]
[null,"2022-11-11T12:10:04",44876.506990740745,null,null,null,null,"2022-11-11T12:10:04"]
[null,"2024-03-09T16:00:00",45360.666666666672,null,null,null,null,"2024-03-09T16:00:00"]
[null,"2024-03-13T14:26:40",45364.601851851854,null,null,null,null,"2024-03-13T14:26:40"]

{"sheet":"TEXT","index":6,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Use of Excel TEXT Function",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Time ",null,null,null,null,"Timestamp","Time "]
[null,"2005-02-17T10:05:04",{"$f":"TEXT(B5,\"h:mm:ss AM/PM\")","v":"10:05:04 AM"},null,null,null,null,"2005-02-17T10:05:04"]
[null,"2014-03-17",{"$f":"TEXT(B6,\"h:mm:ss AM/PM\")","v":"12:00:00 AM"},null,null,null,null,"2014-03-17"]
[null,"2014-08-16T22:22:19","10:22:19 PM",null,null,null,null,"2014-08-16T22:22:19"]
[null,"2017-11-17T02:08:04","2:08:04 AM",null,null,null,null,"2017-11-17T02:08:04"]
[null,"2022-06-17T21:05:04","9:05:04 PM",null,null,null,null,"2022-06-17T21:05:04"]
[null,"2022-08-17T09:08:04","9:08:04 AM",null,null,null,null,"2022-08-17T09:08:04"]
[null,"2022-10-25T02:08:04","2:08:04 AM",null,null,null,null,"2022-10-25T02:08:04"]
[null,"2022-11-11T12:10:04","12:10:04 PM",null,null,null,null,"2022-11-11T12:10:04"]
[null,"2024-03-09T16:00:00","4:00:00 PM",null,null,null,null,"2024-03-09T16:00:00"]
[null,"2024-03-13T14:26:40","2:26:40 PM",null,null,null,null,"2024-03-13T14:26:40"]

{"sheet":"TEXT_&_TRUNC","index":7,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Combining TEXT and TRUNC Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Time ",null,null,null,null,"Timestamp","Time "]
[null,"2005-02-17T10:05:04",{"$f":"TEXT(B5-TRUNC(B5), \"hh:mm:ss AM/PM\")","v":"10:05:04 AM"},null,null,null,null,"2005-02-17T10:05:04"]
[null,"2014-03-17",{"$f":"TEXT(B6-TRUNC(B6), \"hh:mm:ss AM/PM\")","v":"12:00:00 AM"},null,null,null,null,"2014-03-17"]
[null,"2014-08-16T22:22:19","10:22:19 PM",null,null,null,null,"2014-08-16T22:22:19"]
[null,"2017-11-17T02:08:04","02:08:04 AM",null,null,null,null,"2017-11-17T02:08:04"]
[null,"2022-06-17T21:05:04","09:05:04 PM",null,null,null,null,"2022-06-17T21:05:04"]
[null,"2022-08-17T09:08:04","09:08:04 AM",null,null,null,null,"2022-08-17T09:08:04"]
[null,"2022-10-25T02:08:04","02:08:04 AM",null,null,null,null,"2022-10-25T02:08:04"]
[null,"2022-11-11T12:10:04","12:10:04 PM",null,null,null,null,"2022-11-11T12:10:04"]
[null,"2024-03-09T16:00:00","04:00:00 PM",null,null,null,null,"2024-03-09T16:00:00"]
[null,"2024-03-13T14:26:40","02:26:40 PM",null,null,null,null,"2024-03-13T14:26:40"]

{"sheet":"TIME","index":8,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Applying TIME with HOUR, MINUTE & SECOND Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Time ",null,null,null,null,"Timestamp","Time "]
[null,"2005-02-17T10:05:04",{"$f":"TIME(HOUR(B5), MINUTE(B5), SECOND(B5))","v":"10:05:04"},null,null,null,null,"2005-02-17T10:05:04"]
[null,"2014-03-17",{"$f":"TIME(HOUR(B6), MINUTE(B6), SECOND(B6))","v":"00:00:00"},null,null,null,null,"2014-03-17"]
[null,"2014-08-16T22:22:19","22:22:19",null,null,null,null,"2014-08-16T22:22:19"]
[null,"2017-11-17T02:08:04","02:08:04",null,null,null,null,"2017-11-17T02:08:04"]
[null,"2022-06-17T21:05:04","21:05:04",null,null,null,null,"2022-06-17T21:05:04"]
[null,"2022-08-17T09:08:04","09:08:04",null,null,null,null,"2022-08-17T09:08:04"]
[null,"2022-10-25T02:08:04","02:08:04",null,null,null,null,"2022-10-25T02:08:04"]
[null,"2022-11-11T12:10:04","12:10:04",null,null,null,null,"2022-11-11T12:10:04"]
[null,"2024-03-09T16:00:00","16:00:00",null,null,null,null,"2024-03-09T16:00:00"]
[null,"2024-03-13T14:26:40","14:26:40",null,null,null,null,"2024-03-13T14:26:40"]

{"sheet":"Text_to_Columns","index":9,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Applying Text to Columns Wizard",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Time ",null,null,null,null,"Timestamp","Time "]
[null,"2005-02-17T10:05:04","10:05:04",null,null,null,null,"2005-02-17T10:05:04"]
[null,"2014-03-17","00:00:00",null,null,null,null,"2014-03-17"]
[null,"2014-08-16T22:22:19","22:22:19",null,null,null,null,"2014-08-16T22:22:19"]
[null,"2017-11-17T02:08:04","02:08:04",null,null,null,null,"2017-11-17T02:08:04"]
[null,"2022-06-17T21:05:04","21:05:04",null,null,null,null,"2022-06-17T21:05:04"]
[null,"2022-08-17T09:08:04","09:08:04",null,null,null,null,"2022-08-17T09:08:04"]
[null,"2022-10-25T02:08:04","02:08:04",null,null,null,null,"2022-10-25T02:08:04"]
[null,"2022-11-11T12:10:04","12:10:04",null,null,null,null,"2022-11-11T12:10:04"]
[null,"2024-03-09T16:00:00","16:00:00",null,null,null,null,"2024-03-09T16:00:00"]
[null,"2024-03-13T14:26:40","14:26:40",null,null,null,null,"2024-03-13T14:26:40"]

{"sheet":"13-digit_Timestamp","index":10,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Converting 13 Digit Timestamp to Date and Time",null,null,null,null,null,"Try Yourself"]
[]
[null,"Timestamp","Date and Time (GMT)",null,null,null,null,"Timestamp","Time (GMT)"]
[null,1108634704000,{"$f":"(B5/86400000)+DATE(1970,1,1)","v":"2005-02-17T10:05:04"},null,null,null,null,1108634704]
[null,1395014400000,{"$f":"(B6/86400000)+DATE(1970,1,1)","v":"2014-03-17"},null,null,null,null,1395014400]
[null,1408227739000,"2014-08-16T22:22:19",null,null,null,null,1408227739]
[null,1510884484000,"2017-11-17T02:08:04",null,null,null,null,1510884484]
[null,1655499904000,"2022-06-17T21:05:04",null,null,null,null,1655499904]
[null,1660727284000,"2022-08-17T09:08:04",null,null,null,null,1660727284]
[null,1666663684000,"2022-10-25T02:08:04",null,null,null,null,1666663684]
[null,1668168604000,"2022-11-11T12:10:04",null,null,null,null,1668168604]
[null,1710000000000,"2024-03-09T16:00:00",null,null,null,null,1710000000]
[null,1710340000000,"2024-03-13T14:26:40",null,null,null,null,1710340000]