{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tstamp Formula","Tstamp Alt-Formula","Tstamp 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":"Tstamp Formula","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Timestamp in Excel with Formula",null,null,null,"Practice Here!"]
[]
[null,"Data Entry","Timestamp","Helper Column",null,"Data Entry","Timestamp","Helper Column"]
[null,"Amelia",{"$f":"IF(AND(B5<>\"\",D5<>B5),NOW(),IF(B5=\"\",\"\",C5))","v":"00:00:00"},{"$f":"IF(B5=\"\",\"\",IF(OR(C5=\"\",AND(ISNUMBER(D5),B5=D5)),D5,B5))","v":"Amelia"}]
[null,"Charlotte",{"$f":"IF(AND(B6<>\"\",D6<>B6),NOW(),IF(B6=\"\",\"\",C6))","v":"2022-06-15T11:05:58.830"},{"$f":"IF(B6=\"\",\"\",IF(OR(C6=\"\",AND(ISNUMBER(D6),B6=D6)),D6,B6))","v":"Charlotte"}]
[null,"Elizabeth","2022-06-15T11:06:11.030","Elizabeth"]
[null,"Isabella","2022-06-15T11:06:17.860","Isabella"]
[null,"Olivia","2022-06-15T11:06:23.790","Olivia"]
[null,"Sophia","2022-06-15T11:06:33.550","Sophia"]

{"sheet":"Tstamp Alt-Formula","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Timestamp in Excel with Formula",null,null,"Practice Here!"]
[]
[null,"Data Entry","Timestamp",null,"Data Entry","Timestamp"]
[null,"Amelia",{"$f":"IF(B5<>\"\",IF(C5=\"\",NOW(),C5),\"\")","v":"2022-06-15T11:15:10.130"}]
[null,"Charlotte",{"$f":"IF(B6<>\"\",IF(C6=\"\",NOW(),C6),\"\")","v":"2022-06-15T11:15:21.190"}]
[null,"Elizabeth","2022-06-15T11:15:31.250"]
[null,"Isabella","2022-06-15T11:15:39.610"]
[null,"Olivia","2022-06-15T11:15:48.070"]
[null,"Sophia","2022-06-15T11:15:59.120"]

{"sheet":"Tstamp VBA","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Timestamp in Excel with VBA",null,null,"Practice Here!"]
[]
[null,"Data Entry","Timestamp",null,"Data Entry","Timestamp"]
[null,"Amelia","15-06-2022 11:32:24 AM"]
[null,"Charlotte","15-06-2022 11:32:35 AM"]
[null,"Elizabeth","15-06-2022 11:32:40 AM"]
[null,"Isabella","15-06-2022 11:32:46 AM"]
[null,"Olivia","15-06-2022 11:32:53 AM"]
[null,"Sophia","15-06-2022 11:33:00 AM"]