{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Merging IF and NOW","Updating Data Entry Time","Applying VBA Code","Using Keyboard Shortcut","Using TODAY Function","Using NOW Function"],"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":"Merging IF and NOW","index":0,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Merging IF and NOW Functions",null,null,null,">>> Do Yourself >>>"]
[]
[null,"Employee","Entry Time",null,null,"Employee","Entry Time"]
[null,"John",{"$f":"IF(B5<>\"\",IF(C5<>\"\",C5,NOW()),\"\")","v":"2022-11-10T10:31:52.540"}]
[null,"Adam",{"$f":"IF(B6<>\"\",IF(C6<>\"\",C6,NOW()),\"\")","v":"2022-11-10T10:31:59.470"}]
[null,"Peter","2022-11-10T10:32:30"]
[null,"Sarah","2022-11-10T10:35:27.080"]
[null,"Jack","2022-11-10T10:39:59.310"]

{"sheet":"Updating Data Entry Time","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Updating Data Entry Time",null,null,null,">>> Do Yourself >>>"]
[]
[null,"Employee","Entry Time",null,null,"Employee","Entry Time"]
[null,"John",{"$f":"IF(B5<>\"\",IF(AND(C5<>\"\",CELL(\"address\")=ADDRESS(ROW(B5),COLUMN(B5))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B5),COLUMN(B5)),C5,NOW())),\"\")","v":"2022-11-10T10:35:31.720"}]
[null,"Adam",{"$f":"IF(B6<>\"\",IF(AND(C6<>\"\",CELL(\"address\")=ADDRESS(ROW(B6),COLUMN(B6))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B6),COLUMN(B6)),C6,NOW())),\"\")","v":"2022-11-10T10:34:27.490"}]
[null,"Peter",{"$f":"IF(B7<>\"\",IF(AND(C7<>\"\",CELL(\"address\")=ADDRESS(ROW(B7),COLUMN(B7))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B7),COLUMN(B7)),C7,NOW())),\"\")","v":"2022-11-10T10:35:33.620"}]
[null,"Sarah",{"$f":"IF(B8<>\"\",IF(AND(C8<>\"\",CELL(\"address\")=ADDRESS(ROW(B8),COLUMN(B8))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B8),COLUMN(B8)),C8,NOW())),\"\")","v":"2022-11-10T10:40:48.860"}]
[null,"Jack",{"$f":"IF(B9<>\"\",IF(AND(C9<>\"\",CELL(\"address\")=ADDRESS(ROW(B9),COLUMN(B9))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(B9),COLUMN(B9)),C9,NOW())),\"\")","v":"2022-11-10T10:40:50.700"}]

{"sheet":"Applying VBA Code","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Applying VBA Code",null,null,null,">>> Do Yourself >>>"]
[]
[null,"Employee","Entry Time",null,null,"Employee","Entry Time"]
[null,"John",{"$f":"Entry_Time(B5)","v":"10-11-22 11:15:05"}]
[null,"Adam",{"$f":"Entry_Time(B6)","v":"10-11-22 11:15:05"}]
[null,"Peter",{"$f":"Entry_Time(B7)","v":"10-11-22 11:15:05"}]
[null,"Sarah",{"$f":"Entry_Time(B8)","v":"10-11-22 11:15:05"}]
[null,"Jack",{"$f":"Entry_Time(B9)","v":"10-11-22 11:15:05"}]

{"sheet":"Using Keyboard Shortcut","index":3,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Using Keyboard Shortcut",null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Employee","Entry Date","Entry Time","Entry Date & Time",null,null,"Employee","Entry Date","Entry Time","Entry Date & Time"]
[null,"John","2022-11-10","10:11:00","2022-11-10T10:11:00",null,null,"John"]
[null,"Adam","2022-11-10","10:12:00","2022-11-10T10:12:00",null,null,"Adam"]
[null,"Peter","2022-11-10","10:13:00","2022-11-10T10:13:00",null,null,"Peter"]
[null,"Sarah","2022-11-10","10:14:00","2022-11-10T10:14:00",null,null,"Sarah"]
[null,"Jack","2022-11-10","10:16:00","2022-11-10T10:16:00",null,null,"Jack"]

{"sheet":"Using TODAY Function","index":4,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using TODAY Function",null,null,null,">>> Do Yourself >>>"]
[]
[null,"Employee","Entry Date",null,null,"Employee","Entry Date"]
[null,"John",{"$f":"TODAY()","v":"2022-11-10"},null,null,"John"]
[null,"Adam",{"$f":"TODAY()","v":"2022-11-10"},null,null,"Adam"]
[null,"Peter","2022-11-10",null,null,"Peter"]
[null,"Sarah","2022-11-10",null,null,"Sarah"]
[null,"Jack","2022-11-10",null,null,"Jack"]

{"sheet":"Using NOW Function","index":5,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using NOW Function",null,null,null,">>> Do Yourself >>>"]
[]
[null,"Employee","Entry Time",null,null,"Employee","Entry Time"]
[null,"John",{"$f":"NOW()","v":"2022-11-10T15:59:29.730"},null,null,"John"]
[null,"Adam",{"$f":"NOW()","v":"2022-11-10T15:59:29.730"},null,null,"Adam"]
[null,"Peter","2022-11-10T15:59:29.730",null,null,"Peter"]
[null,"Sarah","2022-11-10T15:59:29.730",null,null,"Sarah"]
[null,"Jack","2022-11-10T15:59:29.730",null,null,"Jack"]