{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Order Details","Apply Formula","time Function","timevalue Function","add 30 min","add 30 min (2)","Applying VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Order Details","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Order Details of Shop X"]
[]
[null,"Order ID","Product","Order Time","Add Hours"]
[null,"41S","Shirt","06:00:00",8]
[null,"1TR","Trousers","07:00:00",8]
[null,"2TR","Trousers","08:00:00",8]
[null,"42S","Shirt","09:00:00",8]
[null,"1TS","T-Shirt","10:00:00",8]
[null,"3TR","Trousers","11:00:00",8]
[null,"43S","Shirt","12:00:00",8]
[null,"1SH","Shorts","13:00:00",8]
[null,"2SH","Shorts","14:00:00",8]
[null,"2TS","T-Shirt","15:00:00",8]
[null,"3TS","T-Shirt","16:00:00",8]
[null,"44S","Shirt","17:00:00",8]

{"sheet":"Apply Formula","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Order Details of Shop X"]
[]
[null,"Order ID","Product","Order Time","Add Hours","Delivery Time"]
[null,"41S","Shirt","06:00:00",8,{"$f":"D5+E5/24","v":"14:00:00"}]
[null,"1TR","Trousers","07:00:00",8,{"$f":"D6+E6/24","v":"15:00:00"}]
[null,"2TR","Trousers","08:00:00",8,"16:00:00"]
[null,"42S","Shirt","09:00:00",8,"17:00:00"]
[null,"1TS","T-Shirt","10:00:00",8,"18:00:00"]
[null,"3TR","Trousers","11:00:00",8,"19:00:00"]
[null,"43S","Shirt","12:00:00",8,"20:00:00"]
[null,"1SH","Shorts","13:00:00",8,"21:00:00"]
[null,"2SH","Shorts","14:00:00",8,"22:00:00"]
[null,"2TS","T-Shirt","15:00:00",8,"23:00:00"]
[null,"3TS","T-Shirt","16:00:00",8,1.0000000000000002]
[null,"44S","Shirt","17:00:00",8,1.0416666666666674]

{"sheet":"time Function","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Adding 8 Hours by Function"]
[]
[null,"Order ID","Product","Order Time","Delivery Time"]
[null,"41S","Shirt","06:00:00",{"$f":"D5+TIME(8,0,0)","v":"14:00:00"}]
[null,"1TR","Trousers","07:00:00",{"$f":"D6+TIME(8,0,0)","v":"15:00:00"}]
[null,"2TR","Trousers","08:00:00","16:00:00"]
[null,"42S","Shirt","09:00:00","17:00:00"]
[null,"1TS","T-Shirt","10:00:00","18:00:00"]
[null,"3TR","Trousers","11:00:00","19:00:00"]
[null,"43S","Shirt","12:00:00","20:00:00"]
[null,"1SH","Shorts","13:00:00","21:00:00"]
[null,"2SH","Shorts","14:00:00","22:00:00"]
[null,"2TS","T-Shirt","15:00:00","23:00:00"]
[null,"3TS","T-Shirt","16:00:00",1.0000000000000002]
[null,"44S","Shirt","17:00:00",1.0416666666666674]

{"sheet":"timevalue Function","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Adding 8 Hours by Time Value Function"]
[]
[null,"Order ID","Product","Order Time","Delivery Time"]
[null,"41S","Shirt","06:00:00",{"$f":"D5+TIMEVALUE(\"8:0:0\")","v":"14:00:00"}]
[null,"1TR","Trousers","07:00:00",{"$f":"D6+TIMEVALUE(\"8:0:0\")","v":"15:00:00"}]
[null,"2TR","Trousers","08:00:00","16:00:00"]
[null,"42S","Shirt","09:00:00","17:00:00"]
[null,"1TS","T-Shirt","10:00:00","18:00:00"]
[null,"3TR","Trousers","11:00:00","19:00:00"]
[null,"43S","Shirt","12:00:00","20:00:00"]
[null,"1SH","Shorts","13:00:00","21:00:00"]
[null,"2SH","Shorts","14:00:00","22:00:00"]
[null,"2TS","T-Shirt","15:00:00","23:00:00"]
[null,"3TS","T-Shirt","16:00:00",1.0000000000000002]
[null,"44S","Shirt","17:00:00",1.0416666666666674]

{"sheet":"add 30 min","index":4,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Adding 30 Minutes or Half an Hour to 8 Hours in Excel"]
[]
[null,"08:00:00",30,{"$f":"B4+C4/1440","v":"08:30:00"}]

{"sheet":"add 30 min (2)","index":5,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Adding  8 Hours Time Over 24 Hours in Excel"]
[]
[null,"08:00:00",30,{"$f":"B4+C4/24","v":1.5833333333333333}]

{"sheet":"Applying VBA","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA Code"]
[]
[null,"Order ID","Product","Order Time","Add Hours","Delivery Time"]
[null,"41S","Shirt","2019-01-09T06:30:00",8,{"$f":"Houraddition(D5,E5)","v":"1/9/19 02:30 PM"}]
[null,"1TR","Trousers","2019-01-12T05:00:00",8]
[null,"2TR","Trousers","2019-01-27T06:45:00",8]
[null,"42S","Shirt","2020-02-25T07:30:00",8]
[null,"1TS","T-Shirt","2020-02-27T07:40:00",8]
[null,"3TR","Trousers","2021-03-05T08:30:00",8]
[null,"43S","Shirt","2021-03-10T09:30:00",8]
[null,"1SH","Shorts","2019-01-09T06:30:00",8]
[null,"2SH","Shorts","2019-01-12T05:00:00",8]
[null,"2TS","T-Shirt","2019-01-27T06:45:00",8]
[null,"3TS","T-Shirt","2020-02-25T07:30:00",8]
[null,"44S","Shirt","2020-02-27T07:40:00",8]