{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Format Cells","CONVERT","TEXT","CHOOSE, MATCH, TEXT","INT, MOD, TIME","MOD, TEXT, TRUNC","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":"Dataset","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sudoko Competition - Completion Time"]
[]
[null,"ID","Participant Name","Completion Time (sec)"]
[null,"SC001","Robin",1250]
[null,"SC002","Mary",2020]
[null,"SC003","Jones",1564]
[null,"SC004","Susan",1026]
[null,"SC005","James",3720]
[null,"SC006","Frank",1350]
[null,"SC007","Jennifer",980]
[null,"SC008","Thomas",1069]
[null,"SC009","Mark",1845]
[null,"SC010","Sandra",3690]

{"sheet":"Format Cells","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Format Cells Option",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format",null,null,null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format"]
[null,"SC001","Robin",1250,{"$f":"D5/86400","v":"00:20:50"},null,null,null,"SC001","Robin",1250]
[null,"SC002","Mary",2020,{"$f":"D6/86400","v":"00:33:40"},null,null,null,"SC002","Mary",2020]
[null,"SC003","Jones",1564,"00:26:04",null,null,null,"SC003","Jones",1564]
[null,"SC004","Susan",1026,"00:17:06",null,null,null,"SC004","Susan",1026]
[null,"SC005","James",3720,"01:02:00",null,null,null,"SC005","James",3720]
[null,"SC006","Frank",1350,"00:22:30",null,null,null,"SC006","Frank",1350]
[null,"SC007","Jennifer",980,"00:16:20",null,null,null,"SC007","Jennifer",980]
[null,"SC008","Thomas",1069,"00:17:49",null,null,null,"SC008","Thomas",1069]
[null,"SC009","Mark",1845,"00:30:45",null,null,null,"SC009","Mark",1845]
[null,"SC010","Sandra",3690,"01:01:30",null,null,null,"SC010","Sandra",3690]

{"sheet":"CONVERT","index":2,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Inserting CONVERT Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format",null,null,null,null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format"]
[null,"SC001","Robin",1250,{"$f":"CONVERT(D5,\"sec\",\"day\")","v":"00:20:50"},null,null,null,null,"SC001","Robin",1250]
[null,"SC002","Mary",2020,{"$f":"CONVERT(D6,\"sec\",\"day\")","v":"00:33:40"},null,null,null,null,"SC002","Mary",2020]
[null,"SC003","Jones",1564,"00:26:04",null,null,null,null,"SC003","Jones",1564]
[null,"SC004","Susan",1026,"00:17:06",null,null,null,null,"SC004","Susan",1026]
[null,"SC005","James",3720,"01:02:00",null,null,null,null,"SC005","James",3720]
[null,"SC006","Frank",1350,"00:22:30",null,null,null,null,"SC006","Frank",1350]
[null,"SC007","Jennifer",980,"00:16:20",null,null,null,null,"SC007","Jennifer",980]
[null,"SC008","Thomas",1069,"00:17:49",null,null,null,null,"SC008","Thomas",1069]
[null,"SC009","Mark",1845,"00:30:45",null,null,null,null,"SC009","Mark",1845]
[null,"SC010","Sandra",3690,"01:01:30",null,null,null,null,"SC010","Sandra",3690]

{"sheet":"TEXT","index":3,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Applying TEXT Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format",null,null,null,null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format"]
[null,"SC001","Robin",1250,{"$f":"TEXT(D5/86400,\"hh:mm:ss\")","v":"00:20:50"},null,null,null,null,"SC001","Robin",1250]
[null,"SC002","Mary",2020,{"$f":"TEXT(D6/86400,\"hh:mm:ss\")","v":"00:33:40"},null,null,null,null,"SC002","Mary",2020]
[null,"SC003","Jones",1564,"00:26:04",null,null,null,null,"SC003","Jones",1564]
[null,"SC004","Susan",1026,"00:17:06",null,null,null,null,"SC004","Susan",1026]
[null,"SC005","James",3720,"01:02:00",null,null,null,null,"SC005","James",3720]
[null,"SC006","Frank",1350,"00:22:30",null,null,null,null,"SC006","Frank",1350]
[null,"SC007","Jennifer",980,"00:16:20",null,null,null,null,"SC007","Jennifer",980]
[null,"SC008","Thomas",1069,"00:17:49",null,null,null,null,"SC008","Thomas",1069]
[null,"SC009","Mark",1845,"00:30:45",null,null,null,null,"SC009","Mark",1845]
[null,"SC010","Sandra",3690,"01:01:30",null,null,null,null,"SC010","Sandra",3690]

{"sheet":"CHOOSE, MATCH, TEXT","index":4,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Utilizing CHOOSE, MATCH, TEXT Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format",null,null,null,null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format"]
[null,"SC001","Robin",1250,{"$f":"TEXT(D5/86400,CHOOSE(MATCH(D5,{0,60,3600},1),\":ss\",\"m:ss\",\"[h]:mm:ss\"))","v":"20:50"},null,null,null,null,"SC001","Robin",1250]
[null,"SC002","Mary",2020,{"$f":"TEXT(D6/86400,CHOOSE(MATCH(D6,{0,60,3600},1),\":ss\",\"m:ss\",\"[h]:mm:ss\"))","v":"33:40"},null,null,null,null,"SC002","Mary",2020]
[null,"SC003","Jones",1564,{"$f":"TEXT(D7/86400,CHOOSE(MATCH(D7,{0,60,3600},1),\":ss\",\"m:ss\",\"[h]:mm:ss\"))","v":"26:04"},null,null,null,null,"SC003","Jones",1564]
[null,"SC004","Susan",1026,{"$f":"TEXT(D8/86400,CHOOSE(MATCH(D8,{0,60,3600},1),\":ss\",\"m:ss\",\"[h]:mm:ss\"))","v":"17:06"},null,null,null,null,"SC004","Susan",1026]
[null,"SC005","James",3720,{"$f":"TEXT(D9/86400,CHOOSE(MATCH(D9,{0,60,3600},1),\":ss\",\"m:ss\",\"[h]:mm:ss\"))","v":"1:02:00"},null,null,null,null,"SC005","James",3720]
[null,"SC006","Frank",1350,{"$f":"TEXT(D10/86400,CHOOSE(MATCH(D10,{0,60,3600},1),\":ss\",\"m:ss\",\"[h]:mm:ss\"))","v":"22:30"},null,null,null,null,"SC006","Frank",1350]
[null,"SC007","Jennifer",980,{"$f":"TEXT(D11/86400,CHOOSE(MATCH(D11,{0,60,3600},1),\":ss\",\"m:ss\",\"[h]:mm:ss\"))","v":"16:20"},null,null,null,null,"SC007","Jennifer",980]
[null,"SC008","Thomas",1069,{"$f":"TEXT(D12/86400,CHOOSE(MATCH(D12,{0,60,3600},1),\":ss\",\"m:ss\",\"[h]:mm:ss\"))","v":"17:49"},null,null,null,null,"SC008","Thomas",1069]
[null,"SC009","Mark",1845,{"$f":"TEXT(D13/86400,CHOOSE(MATCH(D13,{0,60,3600},1),\":ss\",\"m:ss\",\"[h]:mm:ss\"))","v":"30:45"},null,null,null,null,"SC009","Mark",1845]
[null,"SC010","Sandra",3690,{"$f":"TEXT(D14/86400,CHOOSE(MATCH(D14,{0,60,3600},1),\":ss\",\"m:ss\",\"[h]:mm:ss\"))","v":"1:01:30"},null,null,null,null,"SC010","Sandra",3690]

{"sheet":"INT, MOD, TIME","index":5,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Employing INT, MOD, TIME Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format",null,null,null,null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format"]
[null,"SC001","Robin",1250,{"$f":"INT(D5/3600)&\":\"&INT(((D5/3600)-INT(D5/3600))*60)&\":\"&ROUND((((D5/3600)-INT(D5/3600))*60 - INT(((D5/3600)-INT(D5/3600))*60))*60,0)","v":"0:20:50"},null,null,null,null,"SC001","Robin",1250]
[null,"SC002","Mary",2020,{"$f":"INT(D6/3600)&\":\"&INT(((D6/3600)-INT(D6/3600))*60)&\":\"&ROUND((((D6/3600)-INT(D6/3600))*60 - INT(((D6/3600)-INT(D6/3600))*60))*60,0)","v":"0:33:40"},null,null,null,null,"SC002","Mary",2020]
[null,"SC003","Jones",1564,"0:26:4",null,null,null,null,"SC003","Jones",1564]
[null,"SC004","Susan",1026,"0:17:6",null,null,null,null,"SC004","Susan",1026]
[null,"SC005","James",3720,"1:2:0",null,null,null,null,"SC005","James",3720]
[null,"SC006","Frank",1350,"0:22:30",null,null,null,null,"SC006","Frank",1350]
[null,"SC007","Jennifer",980,"0:16:20",null,null,null,null,"SC007","Jennifer",980]
[null,"SC008","Thomas",1069,"0:17:49",null,null,null,null,"SC008","Thomas",1069]
[null,"SC009","Mark",1845,"0:30:45",null,null,null,null,"SC009","Mark",1845]
[null,"SC010","Sandra",3690,"1:1:30",null,null,null,null,"SC010","Sandra",3690]

{"sheet":"MOD, TEXT, TRUNC","index":6,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Implementing MOD, TEXT, TRUNC Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format",null,null,null,null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format"]
[null,"SC001","Robin",1250,{"$f":"TRUNC(D5/3600)&TEXT(MOD(D5/86400,1),\":mm:ss\")","v":"0:20:50"},null,null,null,null,"SC001","Robin",1250]
[null,"SC002","Mary",2020,{"$f":"TRUNC(D6/3600)&TEXT(MOD(D6/86400,1),\":mm:ss\")","v":"0:33:40"},null,null,null,null,"SC002","Mary",2020]
[null,"SC003","Jones",1564,"0:26:04",null,null,null,null,"SC003","Jones",1564]
[null,"SC004","Susan",1026,"0:17:06",null,null,null,null,"SC004","Susan",1026]
[null,"SC005","James",3720,"1:02:00",null,null,null,null,"SC005","James",3720]
[null,"SC006","Frank",1350,"0:22:30",null,null,null,null,"SC006","Frank",1350]
[null,"SC007","Jennifer",980,"0:16:20",null,null,null,null,"SC007","Jennifer",980]
[null,"SC008","Thomas",1069,"0:17:49",null,null,null,null,"SC008","Thomas",1069]
[null,"SC009","Mark",1845,"0:30:45",null,null,null,null,"SC009","Mark",1845]
[null,"SC010","Sandra",3690,"1:01:30",null,null,null,null,"SC010","Sandra",3690]

{"sheet":"VBA","index":7,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Engaging VBA Code",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format",null,null,null,null,"ID","Participant Name","Completion Time (sec)","Time in hh:mm:ss Format"]
[null,"SC001","Robin",1250,"00:20:50",null,null,null,null,"SC001","Robin",1250]
[null,"SC002","Mary",2020,"00:33:40",null,null,null,null,"SC002","Mary",2020]
[null,"SC003","Jones",1564,"00:26:04",null,null,null,null,"SC003","Jones",1564]
[null,"SC004","Susan",1026,"00:17:06",null,null,null,null,"SC004","Susan",1026]
[null,"SC005","James",3720,"01:02:00",null,null,null,null,"SC005","James",3720]
[null,"SC006","Frank",1350,"00:22:30",null,null,null,null,"SC006","Frank",1350]
[null,"SC007","Jennifer",980,"00:16:20",null,null,null,null,"SC007","Jennifer",980]
[null,"SC008","Thomas",1069,"00:17:49",null,null,null,null,"SC008","Thomas",1069]
[null,"SC009","Mark",1845,"00:30:45",null,null,null,null,"SC009","Mark",1845]
[null,"SC010","Sandra",3690,"01:01:30",null,null,null,null,"SC010","Sandra",3690]