{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INT Function","Custom Format","TRUNC Function","Excel 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":"INT Function","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of INT Function",null,null,null,"Try Yourself"]
[]
[null,"Sales Meeting Schedule","Clients","Truncate Date",null,"Sales Meeting Schedule","Clients","Truncate Date"]
[null,"2022-12-07T07:10:00","Andy Teal",{"$f":"B5-INT(B5)","v":"07:10:00"},null,"2022-12-07T07:10:00","Andy Teal"]
[null,"2022-12-21T12:30:00","Robert Walters",{"$f":"B6-INT(B6)","v":"12:30:00"},null,"2022-12-21T12:30:00","Robert Walters"]
[null,"2023-01-05T08:30:00","Susan W. Eaton","08:30:00",null,"2023-01-05T08:30:00","Susan W. Eaton"]
[null,"2023-01-19T10:00:00","Kim Ralls","10:00:00",null,"2023-01-19T10:00:00","Kim Ralls"]
[null,"2023-02-03T11:00:00","Kathie Flood","11:00:00",null,"2023-02-03T11:00:00","Kathie Flood"]

{"sheet":"Custom Format","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of Custom Formatting",null,null,null,null,"Try Yourself"]
[]
[null,"Sales Meeting Schedule","Clients","Truncate Date",null,null,"Sales Meeting Schedule","Clients","Truncate Date"]
[null,"2022-12-07T07:10:00","Andy Teal","2022-12-07T07:10:00",null,null,"2022-12-07T07:10:00","Andy Teal","2022-12-07T07:10:00"]
[null,"2022-12-21T12:30:00","Robert Walters","2022-12-21T12:30:00",null,null,"2022-12-21T12:30:00","Robert Walters","2022-12-21T12:30:00"]
[null,"2023-01-05T08:30:00","Susan W. Eaton","2023-01-05T08:30:00",null,null,"2023-01-05T08:30:00","Susan W. Eaton","2023-01-05T08:30:00"]
[null,"2023-01-19T10:00:00","Kim Ralls","2023-01-19T10:00:00",null,null,"2023-01-19T10:00:00","Kim Ralls","2023-01-19T10:00:00"]
[null,"2023-02-03T11:00:00","Kathie Flood","2023-02-03T11:00:00",null,null,"2023-02-03T11:00:00","Kathie Flood","2023-02-03T11:00:00"]

{"sheet":"TRUNC Function","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of TRUNC Function",null,null,null,"Try Yourself"]
[]
[null,"Sales Meeting Schedule","Clients","Truncate Date",null,"Sales Meeting Schedule","Clients","Truncate Date"]
[null,"2022-12-07T07:10:00","Andy Teal",{"$f":"B5-TRUNC(B5)","v":"07:10:00"},null,"2022-12-07T07:10:00","Andy Teal"]
[null,"2022-12-21T12:30:00","Robert Walters",{"$f":"B6-TRUNC(B6)","v":"12:30:00"},null,"2022-12-21T12:30:00","Robert Walters"]
[null,"2023-01-05T08:30:00","Susan W. Eaton","08:30:00",null,"2023-01-05T08:30:00","Susan W. Eaton"]
[null,"2023-01-19T10:00:00","Kim Ralls","10:00:00",null,"2023-01-19T10:00:00","Kim Ralls"]
[null,"2023-02-03T11:00:00","Kathie Flood","11:00:00",null,"2023-02-03T11:00:00","Kathie Flood"]

{"sheet":"Excel VBA","index":3,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of Excel VBA",null,null,null,null,"Try Yourself"]
[]
[null,"Sales Meeting Schedule","Clients","Truncate Date",null,null,"Sales Meeting Schedule","Clients","Truncate Date"]
[null,"2022-12-07T07:10:00","Andy Teal","07:10:00",null,null,"2022-12-07T07:10:00","Andy Teal","07:10:00"]
[null,"2022-12-21T12:30:00","Robert Walters","12:30:00",null,null,"2022-12-21T12:30:00","Robert Walters","12:30:00"]
[null,"2023-01-05T08:30:00","Susan W. Eaton","08:30:00",null,null,"2023-01-05T08:30:00","Susan W. Eaton","08:30:00"]
[null,"2023-01-19T10:00:00","Kim Ralls","09:30:00",null,null,"2023-01-19T10:00:00","Kim Ralls","09:30:00"]
[null,"2023-02-03T11:00:00","Kathie Flood","10:30:00",null,null,"2023-02-03T11:00:00","Kathie Flood","10:30:00"]