{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Pulling Minutes","Time & Minute Function","Minute with IF ","Providing new time","Difference in Minutes","VBA code"],"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":"Pulling Minutes","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Pulling Minutes from Time Value Using MINUTE Function"]
[]
[null,"Time Value","Format","Minutes"]
[null,"10:30:00","hh:mm",{"$f":"MINUTE(B5)","v":30}]
[null,"10:40:00","hh:mm:ss",{"$f":"MINUTE(B6)","v":40}]
[null,"20:10:00","24-hour format",10]
[null,0.2225,"Decimal number",20]
[null,44409.4375,"Serial number",30]
[null,"2021-08-01","Date",0]
[null,"2021-08-01T10:30:00","Date-time",30]
[null,"10:30:00","Time as text",30]
[null,"Current Minute","Minute at moment",{"$f":"MINUTE(NOW())","v":27}]

{"sheet":"Time & Minute Function","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of TIME & MINUTE Functions"]
[]
[null,"Time Value","New Time"]
[null,44409.4375,{"$f":"TIME(7,MINUTE(B5),0)","v":"07:30:00"}]
[null,"10:30:00",{"$f":"TIME(7,MINUTE(B6),0)","v":"07:30:00"}]
[null,"10:40:00","07:40:00"]
[null,"20:10:00","07:10:00"]
[null,0.2225,"07:20:00"]

{"sheet":"Minute with IF ","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using MINUTE Function with IF Statements"]
[]
[null,"Time Value","New Time"]
[null,"10:25:00",{"$f":"IF(MINUTE(B5)<30,B5,0)","v":"10:25:00"}]
[null,"10:40:00",{"$f":"IF(MINUTE(B6)<30,B6,0)","v":"00:00:00"}]
[null,"10:55:00","00:00:00"]
[null,"11:10:00","11:10:00"]
[null,"11:25:00","11:25:00"]
[null,"11:40:00","00:00:00"]

{"sheet":"Providing new time","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Producing A New Time "]
[]
[null,"Time Starts","Required Minutes","Time Ends"]
[null,"2021-08-01T10:30:00",30,{"$f":"TIME(HOUR(B5),MINUTE(B5)+C5,SECOND(B5))","v":"11:00:00"}]
[null,"2021-08-02T11:30:00",40,{"$f":"TIME(HOUR(B6),MINUTE(B6)+C6,SECOND(B6))","v":"12:10:00"}]
[null,"2021-08-03T00:30:00",20,"00:50:00"]
[null,"2021-08-04T00:30:00",45,"01:15:00"]
[null,"2021-08-05T00:10:00",25,"00:35:00"]

{"sheet":"Difference in Minutes","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Computing DIfference in Minutes"]
[]
[null,"Time Starts","Time Ends","Minutes"]
[null,"07:10:50","12:10:29",{"$f":"MINUTE(C5-B5)","v":59}]
[null,"07:30:40","12:20:21",{"$f":"MINUTE(C6-B6)","v":49}]
[null,"07:50:30","12:30:13",39]
[null,"08:10:20","12:40:05",29]
[null,"08:30:10","12:49:57",19]

{"sheet":"VBA code","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Embedding VBA Code "]
[]
[null,"Time Value","Format","Minutes"]
[null,"10:30:00","hh:mm",30]
[null,"10:40:00","hh:mm:ss",40]
[null,"20:10:00","24-hour format",10]
[null,0.2225,"Decimal number",20]
[null,44409.4375,"Serial number",30]
[null,"2021-08-01","Date",0]
[null,"2021-08-01T10:30:00","Date-time",30]
[null,"10:30:00","Time as text",30]