{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Overview","TimeValue_SingleCell","TimeValue_Worksheet"],"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":"Overview","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Overview of VBA TimeValue Function"]
[]
[]
[]
[null,"Time As String","Time Value","Explanation"]
[null,"06:30:00","06:30:00","Returns time value from 12-hours format"]
[null,"23:30:00","23:30:00","Returns time value from 24-hours format "]
[null,"2022-02-13T02:30:00","02:30:00","Returns time value form date-time "]
[null,"2022-02-13T02:30:00",0.104166666666,"Returns time serial number from date-time "]

{"sheet":"TimeValue_SingleCell","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Extracting Time Value Using VBA TimeValue Function"]
[]
[null,"Order ID","Delivery Date-Time","Time Value"]
[null,1006,"2022-02-13T02:30:00","02:30:00"]

{"sheet":"TimeValue_Worksheet","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Extracting Time Value Using VBA TimeValue Function"]
[]
[null,"Order ID","Delivery Date-Time","Time Value"]
[null,1006,"2022-02-13T02:30:00","02:30:00"]
[null,1005,"2021-03-12T01:12:00","01:12:00"]
[null,1010,"2021-04-01T12:34:00","12:34:00"]
[null,1004,"2022-04-08T13:12:00","13:12:00"]
[null,1003,"2021-05-05T02:30:00","02:30:00"]
[null,1007,"2021-05-05T23:12:00","23:12:00"]
[null,1001,"2021-06-01T17:50:00","17:50:00"]
[null,1008,"2021-06-05T17:34:00","17:34:00"]
[null,1011,"2021-06-10T00:10:00","00:10:00"]
[null,1009,"2021-07-05T05:34:00","05:34:00"]
[null,1012,"2021-07-15T14:10:00","14:10:00"]
[null,1002,"2021-07-29T06:05:00","06:05:00"]