{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Datasheet1","Datasheet2","less than 24","more than 24","TIME ","negative","date-time","TIME1","MOD,INT","VBA","Practice1","Practice2"],"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":"Datasheet1","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"ABC\" Company"]
[]
[null,"Employee","Entry Time","Time Period"]
[null,"Michael","11:30:00","09:00:00"]
[null,"Sheldon","09:00:00","10:00:00"]
[null,"Richard","10:00:00","10:00:00"]
[null,"Robin","08:45:00","12:00:00"]
[null,"Emily","09:45:00","09:00:00"]
[null,"Leonard","11:20:00","09:00:00"]
[null,"Jefferson","09:10:00","12:00:00"]
[null,"Lara","07:00:00","15:00:00"]
[null,"John","08:00:00","15:00:00"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Datasheet2","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"XYZ\" Company"]
[]
[null,"Product ID","Order Time","Duration"]
[null,1234568,"2019-01-09T06:30:00",15]
[null,1234569,"2019-01-12T05:00:00",16]
[null,1234570,"2019-01-27T06:45:00",17]
[null,1234571,"2020-02-25T07:30:00",18]
[null,1234572,"2020-02-27T07:40:00",19]
[null,1234573,"2021-03-05T08:30:00",20]
[null,1234574,"2021-03-10T09:30:00",21]

{"sheet":"less than 24","index":2,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Adding Hours for less than 24 Hours"]
[]
[null,"Employee","Entry Time","Time Period","Exit Time"]
[null,"Michael","11:30:00","09:00:00",{"$f":"C5+D5","v":"20:30:00"}]
[null,"Sheldon","09:00:00","10:00:00",{"$f":"C6+D6","v":"19:00:00"}]
[null,"Richard","10:00:00","10:00:00","20:00:00"]
[null,"Robin","08:45:00","12:00:00","20:45:00"]
[null,"Emily","09:45:00","09:00:00","18:45:00"]
[null,"Leonard","11:20:00","09:00:00","20:20:00"]
[null,"Jefferson","09:10:00","12:00:00","21:10:00"]
[null,"Lara","07:00:00","15:00:00","22:00:00"]
[null,"John","08:00:00","15:00:00","23:00:00"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"more than 24","index":3,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Adding Hours for more than 24 Hours"]
[]
[null,"Employee","Entry Time","Time Period","Exit Time"]
[null,"Michael","11:30:00","13:00:00",{"$f":"C5+D5","v":1.0208333333333333}]
[null,"Sheldon","09:00:00","16:00:00",{"$f":"C6+D6","v":1.0416666666666665}]
[null,"Richard","10:00:00","15:00:00",1.0416666666666667]
[null,"Robin","08:45:00","16:00:00",1.0312500000000002]
[null,"Emily","09:45:00","17:00:00",1.114583333333333]
[null,"Leonard","11:20:00","18:00:00",1.2222222222222223]
[null,"Jefferson","09:10:00","19:00:00",1.1736111111111114]
[null,"Lara","07:00:00","17:00:00",1]
[null,"John","08:00:00","18:00:00",1.0833333333333333]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"TIME ","index":4,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using TIME Function"]
[]
[null,"Employee","Entry Time","Time Period","Exit Time"]
[null,"Michael","11:30:00",9,{"$f":"TIME(HOUR(C5)+D5,MINUTE(C5),SECOND(C5))","v":"20:30:00"}]
[null,"Sheldon","09:00:00",10,{"$f":"TIME(HOUR(C6)+D6,MINUTE(C6),SECOND(C6))","v":"19:00:00"}]
[null,"Richard","10:00:00",10,"20:00:00"]
[null,"Robin","08:45:00",12,"20:45:00"]
[null,"Emily","09:45:00",9,"18:45:00"]
[null,"Leonard","11:20:00",9,"20:20:00"]
[null,"Jefferson","09:10:00",12,"21:10:00"]
[null,"Lara","07:00:00",15,"22:00:00"]
[null,"John","08:00:00",15,"23:00:00"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"negative","index":5,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Negative Hour Addition"]
[]
[null,"Employee","Entry Time","Time Period","Exit Time"]
[null,"Michael","11:30:00",-9,{"$f":"TIME(IF(HOUR(C5)+D5<0,24+HOUR(C5)+D5,HOUR(C5)+D5),MINUTE(C5),SECOND(C5))","v":"02:30:00"}]
[null,"Sheldon","09:00:00",-10,{"$f":"TIME(IF(HOUR(C6)+D6<0,24+HOUR(C6)+D6,HOUR(C6)+D6),MINUTE(C6),SECOND(C6))","v":"23:00:00"}]
[null,"Richard","10:00:00",-10,"00:00:00"]
[null,"Robin","08:45:00",-12,"20:45:00"]
[null,"Emily","09:45:00",-9,"00:45:00"]
[null,"Leonard","11:20:00",-9,"02:20:00"]
[null,"Jefferson","09:10:00",-12,"21:10:00"]
[null,"Lara","07:00:00",-15,"16:00:00"]
[null,"John","08:00:00",-15,"17:00:00"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]

{"sheet":"date-time","index":6,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Adding Hours to Date Time"]
[]
[null,"Product ID","Order Time","Duration","Delivery Time"]
[null,1234568,"2019-01-09T06:30:00",15,{"$f":"C5+D5/24","v":"2019-01-09T21:30:00"}]
[null,1234569,"2019-01-12T05:00:00",16,{"$f":"C6+D6/24","v":"2019-01-12T21:00:00"}]
[null,1234570,"2019-01-27T06:45:00",17,"2019-01-27T23:45:00"]
[null,1234571,"2020-02-25T07:30:00",18,"2020-02-26T01:30:00"]
[null,1234572,"2020-02-27T07:40:00",19,"2020-02-28T02:40:00"]
[null,1234573,"2021-03-05T08:30:00",20,"2021-03-06T04:30:00"]
[null,1234574,"2021-03-10T09:30:00",21,"2021-03-11T06:30:00"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"TIME1","index":7,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using TIME Function for Date Time"]
[]
[null,"Product ID","Order Time","Duration","Delivery Time"]
[null,1234568,"2019-01-09T06:30:00",15,{"$f":"C5+TIME(D5,0,0)","v":"2019-01-09T21:30:00"}]
[null,1234569,"2019-01-12T05:00:00",16,{"$f":"C6+TIME(D6,0,0)","v":"2019-01-12T21:00:00"}]
[null,1234570,"2019-01-27T06:45:00",17,"2019-01-27T23:45:00"]
[null,1234571,"2020-02-25T07:30:00",18,"2020-02-26T01:30:00"]
[null,1234572,"2020-02-27T07:40:00",19,"2020-02-28T02:40:00"]
[null,1234573,"2021-03-05T08:30:00",20,"2021-03-06T04:30:00"]
[null,1234574,"2021-03-10T09:30:00",21,"2021-03-11T06:30:00"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"MOD,INT","index":8,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using TIME Function for Date Time"]
[]
[null,"Product ID","Order Time","Duration","Delivery Time"]
[null,1234568,"2019-01-09T06:30:00",15,{"$f":"TIME(MOD(D5,24),0,0)+C5+INT(D5/24)","v":"2019-01-09T21:30:00"}]
[null,1234569,"2019-01-12T05:00:00",16,{"$f":"TIME(MOD(D6,24),0,0)+C6+INT(D6/24)","v":"2019-01-12T21:00:00"}]
[null,1234570,"2019-01-27T06:45:00",17,"2019-01-27T23:45:00"]
[null,1234571,"2020-02-25T07:30:00",18,"2020-02-26T01:30:00"]
[null,1234572,"2020-02-27T07:40:00",19,"2020-02-28T02:40:00"]
[null,1234573,"2021-03-05T08:30:00",20,"2021-03-06T04:30:00"]
[null,1234574,"2021-03-10T09:30:00",21,"2021-03-11T06:30:00"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

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

{"sheet":"Practice1","index":10,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice"]
[]
[null,"Employee","Entry Time","Time Period"]
[null,"Michael","11:30:00","09:00:00"]
[null,"Sheldon","09:00:00","10:00:00"]
[null,"Richard","10:00:00","10:00:00"]
[null,"Robin","08:45:00","12:00:00"]
[null,"Emily","09:45:00","09:00:00"]
[null,"Leonard","11:20:00","09:00:00"]
[null,"Jefferson","09:10:00","12:00:00"]
[null,"Lara","07:00:00","15:00:00"]
[null,"John","08:00:00","15:00:00"]

{"sheet":"Practice2","index":11,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice"]
[]
[null,"Product ID","Order Time","Duration"]
[null,1234568,"2019-01-09T06:30:00",15]
[null,1234569,"2019-01-12T05:00:00",16]
[null,1234570,"2019-01-27T06:45:00",17]
[null,1234571,"2020-02-25T07:30:00",18]
[null,1234572,"2020-02-27T07:40:00",19]
[null,1234573,"2021-03-05T08:30:00",20]
[null,1234574,"2021-03-10T09:30:00",21]