{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Subtraction","Hour","Minutes","Second","TEXT","MISC","MOD","IF","NOW","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":"Subtraction","index":0,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of Simple Subtraction Formula",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Start Time","Finish Time","Time Difference",null,null,null,null,null,null,null,"Start Time","Finish Time","Time Difference"]
[null,"09:30:00","17:00:00",{"$f":"C5-B5","v":"07:30:00"},null,null,null,null,null,null,null,"09:30:00","17:00:00"]
[null,"09:30:00","18:40:00",{"$f":"C6-B6","v":"09:10:00"},null,null,null,null,null,null,null,"09:30:00","18:40:00"]
[null,"10:50:00","19:30:00","08:40:00",null,null,null,null,null,null,null,"10:50:00","19:30:00"]
[null,"06:40:00","22:20:00","15:40:00",null,null,null,null,null,null,null,"06:40:00","22:20:00"]

{"sheet":"Hour","index":1,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of INT Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Start Time","Finish Time","Time Difference",null,null,null,null,null,null,null,"Start Time","Finish Time","Time Difference"]
[null,"09:30:00","17:00:00",{"$f":"INT((C5-B5)*24)","v":7},null,null,null,null,null,null,null,"09:30:00","17:00:00"]
[null,"09:30:00","18:40:00",{"$f":"INT((C6-B6)*24)","v":9},null,null,null,null,null,null,null,"09:30:00","18:40:00"]
[null,"10:50:00","19:30:00",8,null,null,null,null,null,null,null,"10:50:00","19:30:00"]
[null,"06:40:00","22:20:00",15,null,null,null,null,null,null,null,"06:40:00","22:20:00"]

{"sheet":"Minutes","index":2,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Time Difference in Minutes",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Start Time","Finish Time","Time Difference",null,null,null,null,null,null,null,"Start Time","Finish Time","Time Difference"]
[null,"09:30:00","17:00:00",{"$f":"(C5-B5)*24*60","v":450.00000000000011},null,null,null,null,null,null,null,"09:30:00","17:00:00"]
[null,"09:30:00","18:40:00",{"$f":"(C6-B6)*24*60","v":550.00000000000011},null,null,null,null,null,null,null,"09:30:00","18:40:00"]
[null,"10:50:00","19:30:00",520,null,null,null,null,null,null,null,"10:50:00","19:30:00"]
[null,"06:40:00","22:20:00",939.99999999999989,null,null,null,null,null,null,null,"06:40:00","22:20:00"]

{"sheet":"Second","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Time Difference in Seconds"]
[]
[null,"Start Time","Finish Time","Time Difference"]
[null,"09:30:00","17:00:00",{"$f":"(C5-B5)*24*60*60","v":27000.000000000007}]
[null,"09:30:00","18:40:00",{"$f":"(C6-B6)*24*60*60","v":33000.000000000007}]
[null,"10:50:00","19:30:00",31200]
[null,"06:40:00","22:20:00",56399.999999999993]

{"sheet":"TEXT","index":4,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of TEXT Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Start Time","Finish Time","Time Difference",null,null,null,null,null,null,null,"Start Time","Finish Time","Time Difference"]
[null,"09:30:00","17:00:00",{"$f":"TEXT(C5-B5,\"h:mm\")","v":"7:30"},null,null,null,null,null,null,null,"09:30:00","17:00:00"]
[null,"09:30:00","18:40:00",{"$f":"TEXT(C6-B6,\"h:mm\")","v":"9:10"},null,null,null,null,null,null,null,"09:30:00","18:40:00"]
[null,"10:50:00","19:30:00","8:40",null,null,null,null,null,null,null,"10:50:00","19:30:00"]
[null,"06:40:00","22:20:00","15:40",null,null,null,null,null,null,null,"06:40:00","22:20:00"]

{"sheet":"MISC","index":5,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Combination of HOUR, MINUTE & SECOND Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Start Time","Finish Time","Diff (Hours)","Diff (Minutes)","Diff (Seconds)",null,null,null,null,null,"Start Time","Finish Time","Diff (Hours)","Diff (Minutes)","Diff (Seconds)"]
[null,"09:30:00","17:00:03",{"$f":"HOUR(C5-B5)","v":7},{"$f":"MINUTE(C5-B5)","v":30},{"$f":"SECOND(C5-B5)","v":3},null,null,null,null,null,"09:30:00","17:00:03"]
[null,"09:30:00","18:40:00",{"$f":"HOUR(C6-B6)","v":9},{"$f":"MINUTE(C6-B6)","v":10},{"$f":"SECOND(C6-B6)","v":0},null,null,null,null,null,"09:30:00","18:40:00"]
[null,"10:50:00","19:30:00",8,40,0,null,null,null,null,null,"10:50:00","19:30:00"]
[null,"06:40:00","22:20:00",15,40,0,null,null,null,null,null,"06:40:00","22:20:00"]

{"sheet":"MOD","index":6,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of MOD Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Start Time","Finish Time","Time Difference",null,null,null,null,null,null,null,"Start Time","Finish Time","Time Difference"]
[null,"09:30:00","17:00:00",{"$f":"MOD(C5-B5,1)","v":"07:30:00"},null,null,null,null,null,null,null,"09:30:00","17:00:00"]
[null,"09:30:00","18:40:00",{"$f":"MOD(C6-B6,1)","v":"09:10:00"},null,null,null,null,null,null,null,"09:30:00","18:40:00"]
[null,"10:50:00","19:30:00","08:40:00",null,null,null,null,null,null,null,"10:50:00","19:30:00"]
[null,"06:40:00","22:20:00","15:40:00",null,null,null,null,null,null,null,"06:40:00","22:20:00"]

{"sheet":"IF","index":7,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of IF Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Start Time","Finish Time","Time Difference",null,null,null,null,null,null,null,"Start Time","Finish Time","Time Difference"]
[null,"21:00:00","05:00:00",{"$f":"IF(B5>C5,C5+1,C5)-B5","v":"08:00:00"},null,null,null,null,null,null,null,"21:00:00","05:00:00"]
[null,"21:30:00","06:00:00",{"$f":"IF(B6>C6,C6+1,C6)-B6","v":"08:30:00"},null,null,null,null,null,null,null,"21:30:00","06:00:00"]
[null,"22:00:00","07:30:00","09:30:00",null,null,null,null,null,null,null,"22:00:00","07:30:00"]
[null,"23:00:00","09:00:00","10:00:00",null,null,null,null,null,null,null,"23:00:00","09:00:00"]

{"sheet":"NOW","index":8,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of NOW Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Start Time","Time Difference",null,null,null,null,null,null,null,null,"Start Time","Time Difference"]
[null,"07:00:00",{"$f":"NOW()-B5","v":44703.754189930558},null,null,null,null,null,null,null,null,"07:00:00"]
[null,"09:30:00",{"$f":"NOW()-B6","v":44703.650023263886},null,null,null,null,null,null,null,null,"09:30:00"]
[null,"10:00:00",44703.629189930558,null,null,null,null,null,null,null,null,"10:00:00"]
[null,"2022-05-21T18:00:00",{"$f":"NOW()-B8","v":"1900-01-01T07:06:02.010"},null,null,null,null,null,null,null,null,"2022-05-21T18:00:00"]

{"sheet":"VBA","index":9,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Start Time","Finish Time","Time Difference",null,null,null,null,null,null,null,"Start Time","Finish Time","Time Difference"]
[null,"09:30:00","17:00:13"," 7: 30: 13",null,null,null,null,null,null,null,"09:30:00","17:00:13"]
[null,"09:30:00","18:40:15"," 9: 10: 15",null,null,null,null,null,null,null,"09:30:00","18:40:15"]
[null,"10:50:00","19:30:00"," 8: 40: 0",null,null,null,null,null,null,null,"10:50:00","19:30:00"]
[null,"06:40:00","22:20:20"," 15: 40: 20",null,null,null,null,null,null,null,"06:40:00","22:20:20"]