{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cell Reference","MROUND function","IF and TIME ","In Seconds and Hour","VLOOKUP ","XLOOKUP","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":"Cell Reference","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing IF Function"]
[]
[null,"Time ","Remark",null,"Time Limit"]
[null,"00:45:00",{"$f":"IF(B5>$E$5, \"Yes\",\"No\")","v":"No"},null,"01:00:00"]
[null,"00:55:00","No"]
[null,"00:14:00","No"]
[null,"00:29:00","No"]
[null,"01:58:00","Yes"]
[null,"02:45:00","Yes"]

{"sheet":"MROUND function","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying  MROUND Function"]
[]
[null,"Start Time ","End Time","Remark"]
[null,3.125E-2,"01:35:00",{"$f":"MROUND(C5-B5, 1/86400) >= \"1:00:00\" * 1","v":false}]
[null,3.8194444444444441E-2,"01:55:00",true]
[null,9.7222222222222224E-3,"02:34:00",true]
[null,2.013888888888889E-2,"00:59:00",false]
[null,8.1944444444444445E-2,"02:38:00",false]
[null,0.11458333333333333,"03:58:00",true]

{"sheet":"IF and TIME ","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining IF with TIME Function"]
[]
[null,"Start Time","Submission Time","Remark"]
[null,"00:45:00","03:45:00",{"$f":"IF(C5 > B5 + TIME(1,0,0),\"FAIL\",\"PASS\")","v":"FAIL"}]
[null,"00:55:00","01:55:00","PASS"]
[null,"00:14:00","02:34:00","FAIL"]
[null,"00:29:00","00:59:00","PASS"]
[null,"01:58:00","02:38:00","PASS"]
[null,"02:45:00","03:58:00","FAIL"]

{"sheet":"In Seconds and Hour","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"CalculatIng Difference in Hours "]
[]
[null,"Start Time","Submission Time","Difference in Seconds","Difference in Hours","Remark"]
[null,"00:45:00","03:45:00",{"$f":"(C5-B5)*86400","v":10800},{"$f":"D5/3600","v":3},{"$f":"IF(E5>1,\"Fail\",\"Pass\")","v":"Fail"}]
[null,"00:55:00","01:55:00",{"$f":"(C6-B6)*86400","v":3600},1,{"$f":"IF(E6>1,\"Fail\",\"Pass\")","v":"Pass"}]
[null,"00:14:00","02:34:00",8399.9999999999982,2.333333333333333,{"$f":"IF(E7>1,\"Fail\",\"Pass\")","v":"Fail"}]
[null,"00:29:00","00:59:00",1800,0.5,{"$f":"IF(E8>1,\"Fail\",\"Pass\")","v":"Pass"}]
[null,"01:58:00","02:38:00",2400,0.66666666666666663,{"$f":"IF(E9>1,\"Fail\",\"Pass\")","v":"Pass"}]
[null,"02:45:00","03:58:00",4380,1.2166666666666666,{"$f":"IF(E10>1,\"Fail\",\"Pass\")","v":"Fail"}]

{"sheet":"VLOOKUP ","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Utilizing VLOOKUP Function"]
[]
[null,"Time ","Remark",null,"Time Limit","Comment"]
[null,"00:55:00",{"$f":"VLOOKUP(B5,$E$5:$F$6,2,TRUE)","v":"On time"},null,0,"On time"]
[null,"00:55:00","On time",null,4.1666666666666664E-2,"Late"]
[null,"00:14:00","On time"]
[null,"00:29:00","On time"]
[null,"01:58:00","Late"]
[null,"02:45:00","Late"]

{"sheet":"XLOOKUP","index":5,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using XLOOKUP Function"]
[]
[null,"Time ","Remark",null,"Time Limit","Comment"]
[null,"00:55:00",{"$f":"_xlfn.XLOOKUP(B5,$E$5:$E$6,$F$5:$F$6,,-1)","v":"On time"},null,"00:00:00","On time"]
[null,"00:55:00","On time",null,"01:00:00","Late"]
[null,"00:14:00","On time"]
[null,"00:29:00","On time"]
[null,"01:58:00","Late"]
[null,"02:45:00","Late"]

{"sheet":"VBA","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Embedding VBA Code"]
[]
[null,"Time ","Remark",null,"Time Limit","Comment"]
[null,"00:45:00","On time",null,"00:00:00","On time"]
[null,"00:55:00","On time",null,"01:00:00","Late"]
[null,"00:14:00","On time"]
[null,"00:29:00","On time"]
[null,"01:58:00","Late"]
[null,"02:45:00","Late"]