{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet2","Sheet1","Sheet2 (2)"],"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":"Sheet2","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Nested IF Function"]
[]
[null,"Task","Submission Time","Remarks",null,"Start","End","Status"]
[null,1,"10:00:00",{"$f":"IF(C5>$F$5,IF(C5<$G$5,$H$5),$H$6)","v":"On time"},null,"06:00:00","17:59:00","On time"]
[null,2,"02:00:00",{"$f":"IF(C6>$F$5,IF(C6<$G$5,$H$5),$H$6)","v":"Late"},null,"18:00:00","05:59:00","Late"]
[null,3,"00:30:00","Late"]
[null,4,"13:00:00","On time"]
[null,5,"01:10:00","Late"]
[null,6,"15:00:00","On time"]
[null,7,"16:00:00","On time"]
[null,8,"17:00:00","On time"]

{"sheet":"Sheet1","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Combining IF, IFERROR and IFS Functions"]
[]
[null,"Task","Submission Time","Remarks",null,"Start","End","Status"]
[null,1,"10:00:00",{"$f":"IFERROR(_xlfn.IFS(C5>=$F$5,IF(C5<=$G$5,$H$5),C5>=$F$6,IF(C5<=$G$6,$H$6)),$H$6)","v":"On time"},null,"06:00:00","17:59:00","On time"]
[null,2,"02:00:00",{"$f":"IFERROR(_xlfn.IFS(C6>=$F$5,IF(C6<=$G$5,$H$5),C6>=$F$6,IF(C6<=$G$6,$H$6)),$H$6)","v":"Late"},null,"18:00:00","05:59:00","Late"]
[null,3,"00:30:00",{"$f":"IFERROR(_xlfn.IFS(C7>=$F$5,IF(C7<=$G$5,$H$5),C7>=$F$6,IF(C7<=$G$6,$H$6)),$H$6)","v":"Late"}]
[null,4,"13:00:00",{"$f":"IFERROR(_xlfn.IFS(C8>=$F$5,IF(C8<=$G$5,$H$5),C8>=$F$6,IF(C8<=$G$6,$H$6)),$H$6)","v":"On time"}]
[null,5,"01:10:00",{"$f":"IFERROR(_xlfn.IFS(C9>=$F$5,IF(C9<=$G$5,$H$5),C9>=$F$6,IF(C9<=$G$6,$H$6)),$H$6)","v":"Late"}]
[null,6,"15:00:00",{"$f":"IFERROR(_xlfn.IFS(C10>=$F$5,IF(C10<=$G$5,$H$5),C10>=$F$6,IF(C10<=$G$6,$H$6)),$H$6)","v":"On time"}]
[null,7,"16:00:00",{"$f":"IFERROR(_xlfn.IFS(C11>=$F$5,IF(C11<=$G$5,$H$5),C11>=$F$6,IF(C11<=$G$6,$H$6)),$H$6)","v":"On time"}]
[null,8,"17:00:00",{"$f":"IFERROR(_xlfn.IFS(C12>=$F$5,IF(C12<=$G$5,$H$5),C12>=$F$6,IF(C12<=$G$6,$H$6)),$H$6)","v":"On time"}]

{"sheet":"Sheet2 (2)","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using VBA Code"]
[]
[null,"Task","Submission Time","Remarks",null,"Start","End","Status"]
[null,1,"10:00:00","On time",null,"06:00:00","17:59:00","On time"]
[null,2,"02:00:00","Late",null,"18:00:00","05:59:00","Late"]
[null,3,"00:30:00","Late"]
[null,4,"13:00:00","On time"]
[null,5,"01:10:00","Late"]
[null,6,"15:00:00","On time"]
[null,7,"16:00:00","On time"]
[null,8,"17:00:00","On time"]