{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Keyboard Shortcuts","TODAY","NOW","IF & NOW","VBA","Custom"],"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":"Keyboard Shortcuts","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Keyboard Shortcuts"]
[]
[null,"Shortcut Keys","Output"]
[null,"Ctrl + ;","2023-02-20"]
[null,"Ctrl + Shift + ;","15:54:00"]
[null,"(Ctrl + ;) + Space + (Ctrl + Shift + ;)","2023-02-20T15:54:00"]

{"sheet":"TODAY","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of TODAY Function"]
[]
[null,"Formula","Output"]
[null,"\"=TODAY()\" for CurrentDate",{"$f":"TODAY()","v":"2023-02-20"}]

{"sheet":"NOW","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of NOW Function"]
[]
[null,"Formula","Output"]
[null,"\"=NOW()\" for current date and time",{"$f":"NOW()","v":"2023-02-20T16:05:59.970"}]

{"sheet":"IF & NOW","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of IF & NOW Functions"]
[]
[null,"Name","Entry Time"]
[null,"John",{"$f":"IF(B5<>\"\",IF(C5=\"\",NOW(),C5),\"\")","v":"2023-02-20T15:56:00.540"}]
[null,"Chris",{"$f":"IF(B6<>\"\",IF(C6=\"\",NOW(),C6),\"\")","v":"2023-02-20T15:58:20.130"}]
[null,"Lisa","2023-02-20T15:58:22.600"]
[null,"Tom","2023-02-20T15:58:27.010"]

{"sheet":"VBA","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Name","Entry Time"]
[null,"Lisa","2023-02-20T15:56:50"]
[null,"Jessica","2023-02-20T15:57:09"]
[null,"Natasha","2023-02-20T15:57:15"]

{"sheet":"Custom","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Custom Function"]
[]
[null,"Name","Entry Time"]
[null,"John",{"$f":"TIMESTAMP(B5)","v":"20-02-2023 16:05:57"}]
[null,"Chris",{"$f":"TIMESTAMP(B6)","v":"20-02-2023 16:05:57"}]
[null,"Lisa",{"$f":"TIMESTAMP(B7)","v":"20-02-2023 16:05:57"}]