{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Keyboard Shortcut","Using NOW and TODAY","Using Circular Reference","Timestamp Using VBA","Custom Function","Current time as dynamic value","Converting Timestamp to Date","Removing Time From Timestamp"," Getting Hours, Minutes, and Se","Inserting Specific Time in Exce","Cell value changes"],"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 Shortcut","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Inserting Timestamp Using Keyboard Shortcut"]
[]
[null,"Timestamp","Shortcut","Description"]
[null,"05:04:00","Ctrl + Shift+ ;","Time"]
[null,"2023-06-07","Ctrl + ;","Date"]
[null,"2023-06-07T05:06:00","Ctrl + Shift + ;  [Space] Ctrl + ;","Date & Time"]

{"sheet":"Using NOW and TODAY","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting Timestamp Using NOW and TODAY Functions"]
[]
[null,"Timestamp","Formula"]
[null,{"$f":"NOW()","v":"2023-06-11T02:55:13.410"},"=NOW()"]
[null,{"$f":"TODAY()","v":"2023-06-11"},"=TODAY()"]

{"sheet":"Using Circular Reference","index":2,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting Timestamp Automatically Using Circular Reference"]
[]
[null,"Data","Timestamp"]
[null,"A",{"$f":"IF(B5<>\"\",IF(C5<>\"\",C5,NOW()),\"\")","v":"00:00:00"}]
[null,"B",{"$f":"IF(B6<>\"\",IF(C6<>\"\",C6,NOW()),\"\")","v":"00:00:00"}]
[null,"C","00:00:00",null,null,{"$f":"NOW()","v":"2023-06-11T02:55:13.410"}]
[null,"D","00:00:00"]
[null,null,{"$f":"IF(B10<>\"\",IF(C9<>\"\",C9,NOW()),\"\")","v":""}]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"Timestamp Using VBA","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Timestamp Using VBA"]
[]
[null,"Timestamp"]
[null,"2023-06-10T21:10:35"]

{"sheet":"Custom Function","index":4,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Inserting Timestamp Using User-Defind Function"]
[]
[null,"Timestamp"]
[null,{"$f":"Time_Stamp(B5)","v":"00:00:00"}]
[null,{"$f":"Time_Stamp(B6)","v":{"$error":"#NAME?"}}]
[null,{"$f":"Time_Stamp(B7)","v":{"$error":"#NAME?"}}]
[null,{"$f":"Time_Stamp(B8)","v":{"$error":"#NAME?"}}]

{"sheet":"Current time as dynamic value","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting Current Time as Dynamic Value"]
[]
[null,"Dynamic Value","Formula"]
[null,{"$f":"NOW()","v":45088.121682986108},"=NOW"]
[null,{"$f":"NOW()-INT(NOW())","v":0.12168298610777128},"=NOW()-INT(NOW())"]
[null,{"$f":"NOW()-TODAY()","v":0.12168298610777128},"=NOW()-INT(NOW())"]

{"sheet":"Converting Timestamp to Date","index":6,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Converting Timestamp to Date"]
[]
[null,"Timestamp","Date"]
[null,{"$f":"NOW()","v":"2023-06-11T02:55:13.410"},{"$f":"NOW()","v":"2023-06-11T02:55:13.410"}]

{"sheet":"Removing Time From Timestamp","index":7,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Removing Time From Timestamp"]
[]
[null,"Timestamp","Date (Defaut Format)","Date (Custom Format)"]
[null,{"$f":"NOW()","v":"2023-06-11T02:55:13.410"},{"$f":"INT(B5)","v":"2023-06-11"},{"$f":"DATE(YEAR(B5),MONTH(B5),DAY(B5))","v":"2023-06-11"}]

{"sheet":" Getting Hours, Minutes, and Se","index":8,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null," Getting Hours, Minutes, and Seconds from Timestamp"]
[]
[null,"Timestamp"]
[null,{"$f":"NOW()","v":"2023-06-11T02:55:13.410"}]
[]
[]
[null,"Time Related Parameter","Values","Formula","Description"]
[null,"Hour",{"$f":"HOUR(B5)","v":2},"=HOUR(B6)","Returns Hours"]
[null,"Minutes",{"$f":"MINUTE(B5)","v":55},"=MINUTE(B6)","Returns Minutes"]
[null,"Seconds",{"$f":"SECOND(B5)","v":13},"=SECOND(B6)","Returns Seconds"]

{"sheet":"Inserting Specific Time in Exce","index":9,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Inserting Specific Time in Excel"]
[]
[null,"Hours","Minutes","Seconds","Time"]
[null,12,13,15,{"$f":"TIME(B5,C5,D5)","v":"12:13:15"}]
[null,15,16,35,{"$f":"TIME(B6,C6,D6)","v":"15:16:35"}]

{"sheet":"Cell value changes","index":10,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting Timestamp When Cell Value Changes"]
[]
[null,"Data Entry ","Timestamp"]
[null,"Emily","2023-10-06T22:33:14"]
[null,"Katrina","2023-10-06T22:11:55"]
[null,"Abella","2023-10-06T22:12:00"]