{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Add Time Automatically","Using Nested-IF & NOW Functions","Use of Combined Functions","Use of Keyboard Shortcut","Applying User-Defined Function","Using VBA","Use of NOW and TODAY Functions"],"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":"Add Time Automatically","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Add Time Automatically"]
[]
[null,"Sales Person","Sales"]
[null,"Ron",450]
[null,"John",500]
[null,"Liam",378]
[null,"Henry",980]
[null,"Rose",575]
[null,"Edward",765]
[null,"Emma",340]

{"sheet":"Using Nested-IF & NOW Functions","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using Nested-IF and NOW Functions",null,null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Sales Person","Sales","Exit Time",null,null,null,null,null,null,null,"Sales Person","Sales","Exit Time"]
[null,"Ron",450,{"$f":"IF(C5<>\"\",IF(D5<>\"\",D5,NOW()),\"\")","v":"2022-09-01T17:38:17.280"},null,null,null,null,null,null,null,"Ron",450]
[null,"John",500,{"$f":"IF(C6<>\"\",IF(D6<>\"\",D6,NOW()),\"\")","v":"2022-09-01T17:38:22.870"},null,null,null,null,null,null,null,"John",500]
[null,"Liam",378,"2022-09-01T17:38:28.230",null,null,null,null,null,null,null,"Liam",378]
[null,"Henry",980,"2022-09-01T17:38:33.320",null,null,null,null,null,null,null,"Henry",980]
[null,"Rose",575,"2022-09-01T17:38:39.460",null,null,null,null,null,null,null,"Rose",575]
[null,"Edward",765,"2022-09-01T17:38:44.690",null,null,null,null,null,null,null,"Edward",765]
[null,"Emma",340,"2022-09-01T17:39:06.590",null,null,null,null,null,null,null,"Emma",340]

{"sheet":"Use of Combined Functions","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of Combined Functions",null,null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Sales Person","Sales","Exit Time",null,null,null,null,null,null,null,"Sales Person","Sales","Exit Time"]
[null,"Ron",450,{"$f":"IF(C5<>\"\",IF(AND(D5<>\"\",CELL(\"address\")=ADDRESS(ROW(C5),COLUMN(C5))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(C5),COLUMN(C5)),D5,NOW())),\"\")","v":"2022-09-01T12:27:20.450"},null,null,null,null,null,null,null,"Ron",450]
[null,"John",550,{"$f":"IF(C6<>\"\",IF(AND(D6<>\"\",CELL(\"address\")=ADDRESS(ROW(C6),COLUMN(C6))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(C6),COLUMN(C6)),D6,NOW())),\"\")","v":"2022-09-01T13:01:01.770"},null,null,null,null,null,null,null,"John",500]
[null,"Liam",378,{"$f":"IF(C7<>\"\",IF(AND(D7<>\"\",CELL(\"address\")=ADDRESS(ROW(C7),COLUMN(C7))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(C7),COLUMN(C7)),D7,NOW())),\"\")","v":"2022-09-01T12:29:44.640"},null,null,null,null,null,null,null,"Liam",378]
[null,"Henry",980,{"$f":"IF(C8<>\"\",IF(AND(D8<>\"\",CELL(\"address\")=ADDRESS(ROW(C8),COLUMN(C8))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(C8),COLUMN(C8)),D8,NOW())),\"\")","v":"2022-09-01T12:29:50.720"},null,null,null,null,null,null,null,"Henry",980]
[null,"Rose",575,{"$f":"IF(C9<>\"\",IF(AND(D9<>\"\",CELL(\"address\")=ADDRESS(ROW(C9),COLUMN(C9))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(C9),COLUMN(C9)),D9,NOW())),\"\")","v":"2022-09-01T12:29:57.430"},null,null,null,null,null,null,null,"Rose",575]
[null,"Edward",765,{"$f":"IF(C10<>\"\",IF(AND(D10<>\"\",CELL(\"address\")=ADDRESS(ROW(C10),COLUMN(C10))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(C10),COLUMN(C10)),D10,NOW())),\"\")","v":"2022-09-01T12:30:06.990"},null,null,null,null,null,null,null,"Edward",765]
[null,"Emma",340,{"$f":"IF(C11<>\"\",IF(AND(D11<>\"\",CELL(\"address\")=ADDRESS(ROW(C11),COLUMN(C11))),NOW(),IF(CELL(\"address\")<>ADDRESS(ROW(C11),COLUMN(C11)),D11,NOW())),\"\")","v":"2022-09-01T12:30:15.470"},null,null,null,null,null,null,null,"Emma",340]

{"sheet":"Use of Keyboard Shortcut","index":3,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of Keyboard Shortcut",null,null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Sales Person","Sales","Exit Time",null,null,null,null,null,null,null,"Sales Person","Sales","Exit Time"]
[null,"Ron",450,"12:37:00",null,null,null,null,null,null,null,"Ron",450]
[null,"John",500,"12:38:00",null,null,null,null,null,null,null,"John",500]
[null,"Liam",378,"12:38:00",null,null,null,null,null,null,null,"Liam",378]
[null,"Henry",980,"12:38:00",null,null,null,null,null,null,null,"Henry",980]
[null,"Rose",575,"12:38:00",null,null,null,null,null,null,null,"Rose",575]
[null,"Edward",765,"12:39:00",null,null,null,null,null,null,null,"Edward",765]
[null,"Emma",340,"12:39:00",null,null,null,null,null,null,null,"Emma",340]

{"sheet":"Applying User-Defined Function","index":4,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Applying User-Defined Function",null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Sales Person","Sales","Exit Time",null,null,null,null,null,null,"Sales Person","Sales","Exit Time"]
[null,"Ron",450,{"$f":"Add_Time(C5)","v":"01-09-2022 12:59:13"},null,null,null,null,null,null,"Ron",450]
[null,"John",500,{"$f":"Add_Time(C6)","v":"01-09-2022 12:59:27"},null,null,null,null,null,null,"John",500]
[null,"Liam",378,{"$f":"Add_Time(C7)","v":"01-09-2022 12:59:38"},null,null,null,null,null,null,"Liam",378]
[null,"Henry",980,{"$f":"Add_Time(C8)","v":"01-09-2022 12:59:44"},null,null,null,null,null,null,"Henry",980]
[null,"Rose",575,{"$f":"Add_Time(C9)","v":"01-09-2022 12:59:51"},null,null,null,null,null,null,"Rose",575]
[null,"Edward",765,{"$f":"Add_Time(C10)","v":"01-09-2022 12:59:59"},null,null,null,null,null,null,"Edward",765]
[null,"Emma",340,{"$f":"Add_Time(C11)","v":"01-09-2022 13:00:07"},null,null,null,null,null,null,"Emma",340]

{"sheet":"Using VBA","index":5,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Sales Person","Sales","Exit Time",null,null,null,null,null,null,null,"Sales Person","Sales","Exit Time"]
[null,"Ron",450,"2022-01-09T13:10:38",null,null,null,null,null,null,null,"Ron",450]
[null,"John",500,"2022-01-09T13:11:20",null,null,null,null,null,null,null,"John",500]
[null,"Liam",378,"2022-01-09T13:11:26",null,null,null,null,null,null,null,"Liam",378]
[null,"Henry",980,"2022-01-09T13:11:35",null,null,null,null,null,null,null,"Henry",980]
[null,"Rose",575,"2022-01-09T13:11:42",null,null,null,null,null,null,null,"Rose",575]
[null,"Edward",765,"2022-01-09T13:11:49",null,null,null,null,null,null,null,"Edward",765]
[null,"Emma",340,"2022-01-09T13:12:01",null,null,null,null,null,null,null,"Emma",340]

{"sheet":"Use of NOW and TODAY Functions","index":6,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of NOW and TODAY Functions",null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Sales Person","Sales","Exit Day","Exit Time",null,null,null,null,null,"Sales Person","Sales","Exit Day","Exit Time"]
[null,"Ron",450,{"$f":"TODAY()","v":"2022-09-03"},{"$f":"NOW()","v":"2022-09-03T23:32:15.700"},null,null,null,null,null,"Ron",450]
[null,"John",500,{"$f":"TODAY()","v":"2022-09-03"},{"$f":"NOW()","v":"2022-09-03T23:32:15.700"},null,null,null,null,null,"John",500]
[null,"Liam",378,"2022-09-03","2022-09-03T23:32:15.700",null,null,null,null,null,"Liam",378]
[null,"Henry",980,"2022-09-03","2022-09-03T23:32:15.700",null,null,null,null,null,"Henry",980]
[null,"Rose",575,"2022-09-03","2022-09-03T23:32:15.700",null,null,null,null,null,"Rose",575]
[null,"Edward",765,"2022-09-03","2022-09-03T23:32:15.700",null,null,null,null,null,"Edward",765]
[null,"Emma",340,"2022-09-03","2022-09-03T23:32:15.700",null,null,null,null,null,"Emma",340]