{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Conventional Formula","TIME Function","TIME and MOD Functions"," List of Date Time","Less Than 24 Hours","Over 24 Hours","Embedding 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":"Dataset","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Adding 1 Hour to Time"]
[]
[null,"Product ID","Order Time","Delivery Time"]
[null,1234568,"2019-01-09T06:30:00"]
[null,1234569,"2019-01-12T05:00:00"]
[null,1234570,"2019-01-27T18:45:00"]
[null,1234571,"2020-02-25T07:30:00"]
[null,1234572,"2020-02-27T19:40:00"]
[null,1234573,"2021-03-05T08:30:00"]
[null,1234574,"2021-03-10T21:30:00"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Conventional Formula","index":1,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying Conventional Formula"]
[]
[null,"Product ID","Order Time","Delivery Time"]
[null,1234568,43474.270833333336,1]
[null,1234569,43477.208333333336,{"$f":"C6+(1/24)","v":43477.25}]
[null,1234570,43492.78125,43492.822916666664]
[null,1234571,43886.3125,43886.354166666664]
[null,1234572,43888.819444444445,43888.861111111109]
[null,1234573,44260.354166666664,44260.395833333328]
[null,1234574,44265.895833333336,44265.9375]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"TIME Function","index":2,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using TIME Function"]
[]
[null,"Product ID","Order Time","Delivery Time"]
[null,1234568,43474.270833333336,{"$f":"C5+TIME(1,0,0)","v":43474.3125}]
[null,1234569,43477.208333333336,{"$f":"C6+TIME(1,0,0)","v":43477.25}]
[null,1234570,43492.78125,43492.822916666664]
[null,1234571,43886.3125,43886.354166666664]
[null,1234572,43888.819444444445,43888.861111111109]
[null,1234573,44260.354166666664,44260.395833333328]
[null,1234574,44265.895833333336,44265.9375]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"TIME and MOD Functions","index":3,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining TIME and MOD Functions"]
[]
[null,"Product ID","Order Time","Delivery Time"]
[null,1234568,43474.270833333336,{"$f":"TIME(MOD(1,24),0,0)+C5","v":43474.3125}]
[null,1234569,43477.208333333336,{"$f":"TIME(MOD(1,24),0,0)+C6","v":43477.25}]
[null,1234570,43492.78125,43492.822916666664]
[null,1234571,43886.3125,43886.354166666664]
[null,1234572,43888.819444444445,43888.861111111109]
[null,1234573,44260.354166666664,44260.395833333328]
[null,1234574,44265.895833333336,44265.9375]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":" List of Date Time","index":4,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Adding 1 Hour for a List of Date Time"]
[]
[null,"Product ID","Order Time","Delivery Time"]
[null,1234568,"2019-01-09T06:30:00",{"$f":"C5+(1/24)","v":"2019-01-09T07:30:00"}]
[null,1234569,"2019-01-12T05:00:00",{"$f":"C6+(1/24)","v":"2019-01-12T06:00:00"}]
[null,1234570,"2019-01-27T18:45:00","2019-01-27T19:45:00"]
[null,1234571,"2020-02-25T07:30:00","2020-02-25T08:30:00"]
[null,1234572,"2020-02-27T19:40:00","2020-02-27T20:40:00"]
[null,1234573,"2021-03-05T08:30:00","2021-03-05T09:30:00"]
[null,1234574,"2021-03-10T21:30:00","2021-03-10T22:30:00"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Less Than 24 Hours","index":5,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Adding 1 Hour for Less Than 24 Hours"]
[]
[null,"Product ID","Order Time","Delivery Time"]
[null,1234568,"06:30:00",{"$f":"C5+(1/24)","v":"07:30:00"}]
[null,1234569,43477.208333333336,{"$f":"C6+(1/24)","v":43477.25}]
[null,1234570,43492.78125,43492.822916666664]
[null,1234571,43886.3125,43886.354166666664]
[null,1234572,43888.819444444445,43888.861111111109]
[null,1234573,44260.354166666664,44260.395833333328]
[null,1234574,44265.895833333336,44265.9375]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Over 24 Hours","index":6,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Adding 1 Hour for Over 24 Hours"]
[]
[null,"Product ID","Order Time","Delivery Time"]
[null,1234568,"23:30:00",{"$f":"C5+(1/24)","v":1.0208333333333333}]
[null,1234569,"23:15:00",{"$f":"C6+(1/24)","v":1.0104166666666667}]
[null,1234570,"23:45:00",1.03125]
[null,1234571,"23:17:00",1.0118055555555556]
[null,1234572,"23:57:00",1.0395833333333333]
[null,1234573,"23:31:00",1.0215277777777778]
[null,1234574,"23:08:00",1.0055555555555555]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Embedding VBA Code","index":7,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Embedding VBA Code"]
[]
[null,"Product ID","Order Time","Duration","Delivery Time"]
[null,1234568,"2019-01-09T06:30:00",1,{"$f":"Houraddition(C5,D5)","v":"1/9/19 07:30 AM"}]
[null,1234569,"2019-01-12T05:00:00",1,{"$f":"Houraddition(C6,D6)","v":"1/12/19 06:00 AM"}]
[null,1234570,"2019-01-27T18:45:00",1,{"$f":"Houraddition(C7,D7)","v":"1/27/19 07:45 PM"}]
[null,1234571,"2020-02-25T07:30:00",1,{"$f":"Houraddition(C8,D8)","v":"2/25/20 08:30 AM"}]
[null,1234572,"2020-02-27T19:40:00",1,{"$f":"Houraddition(C9,D9)","v":"2/27/20 08:40 PM"}]
[null,1234573,"2021-03-05T08:30:00",1,{"$f":"Houraddition(C10,D10)","v":"3/5/21 09:30 AM"}]
[null,1234574,"2021-03-10T21:30:00",1,{"$f":"Houraddition(C11,D11)","v":"3/10/21 10:30 PM"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]