{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","ROUNDDOWN & MOD","CONCATENATE","TEXT","SUBSTITUTE & RIGHT","INT & MOD","Custom","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":"Dataset","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Converting 4 Digit Number to Time "]
[]
[null,"No's","Number","Time"]
[null,1,"0145"]
[null,2,"0256"]
[null,3,"1253"]
[null,4,"1625"]
[null,5,"2152"]
[null,6,"1245"]
[null,7,"1212"]

{"sheet":"ROUNDDOWN & MOD","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using ROUNDDOWN and MOD Function"]
[]
[null,"No's","Number","Time"]
[null,1,"0145",{"$f":"ROUNDDOWN(C5,-2)/2400 + MOD(C5,100)/1440","v":"01:45:00"}]
[null,2,"0256",{"$f":"ROUNDDOWN(C6,-2)/2400 + MOD(C6,100)/1440","v":"02:56:00"}]
[null,3,"1253","12:53:00"]
[null,4,"1625","16:25:00"]
[null,5,"2152","21:52:00"]
[null,6,"1245","12:45:00"]
[null,7,"1212","12:12:00"]

{"sheet":"CONCATENATE","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using CONCATENATE, RIGHT & LEFT Function"]
[]
[null,"No's","Number","Time"]
[null,1,"0145",{"$f":"TIMEVALUE(CONCATENATE(LEFT(C5,2),\":\",RIGHT(C5,2)))","v":"01:45:00"}]
[null,2,"0256",{"$f":"TIMEVALUE(CONCATENATE(LEFT(C6,2),\":\",RIGHT(C6,2)))","v":"02:56:00"}]
[null,3,"1253","12:53:00"]
[null,4,"1625","16:25:00"]
[null,5,"2152","21:52:00"]
[null,6,"1245","12:45:00"]
[null,7,"1212","12:12:00"]

{"sheet":"TEXT","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using TEXT Function"]
[]
[null,"No's","Number","Time"]
[null,1,"0145",{"$f":"--TEXT(C5,\"00\\:00\")","v":7.2916666666666671E-2}]
[null,2,"0256",{"$f":"--TEXT(C6,\"00\\:00\")","v":0.12222222222222223}]
[null,3,"1253",0.53680555555555554]
[null,4,"1625",0.68402777777777779]
[null,5,"2152",0.91111111111111109]
[null,6,"1245",0.53125]
[null,7,"1212",0.5083333333333333]

{"sheet":"SUBSTITUTE & RIGHT","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using SUBSTITUTE & RIGHT Function"]
[]
[null,"No's","Number","Time"]
[null,1,"0145",{"$f":"TIMEVALUE(SUBSTITUTE(C5,RIGHT(C5,2),\":\"&RIGHT(C5,2)))","v":"01:45:00"},null,{"$f":"SUBSTITUTE(C5,RIGHT(C5,2),\":\"&RIGHT(C5,2))","v":"01:45"}]
[null,2,"0256",{"$f":"TIMEVALUE(SUBSTITUTE(C6,RIGHT(C6,2),\":\"&RIGHT(C6,2)))","v":"02:56:00"}]
[null,3,"1253","12:53:00"]
[null,4,"1625","16:25:00"]
[null,5,"2152","21:52:00"]
[null,6,"1245","12:45:00"]
[null,7,"1213","12:13:00"]

{"sheet":"INT & MOD","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using INT & MOD Function"]
[]
[null,"No's","Number","Time"]
[null,1,"0145",{"$f":"TIME(INT(C5/100),MOD(C5,100),)","v":"01:45:00"}]
[null,2,"0256",{"$f":"TIME(INT(C6/100),MOD(C6,100),)","v":"02:56:00"}]
[null,3,"1253","12:53:00"]
[null,4,"1625","16:25:00"]
[null,5,"2152","21:52:00"]
[null,6,"1245","12:45:00"]
[null,7,"1212","12:12:00"]

{"sheet":"Custom","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Custom Formatting"]
[]
[null,"No's","Number","Time"]
[null,1,"0145",145]
[null,2,"0256",256]
[null,3,"1253",1253]
[null,4,"1625",1625]
[null,5,"2152",2152]
[null,6,"1245",1245]
[null,7,"1212",1212]

{"sheet":"VBA","index":7,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA Macro"]
[]
[null,"No's","Time"]
[null,1,"01:45:00"]
[null,2,"02:56:00"]
[null,3,"12:53:00"]
[null,4,"16:25:00"]
[null,5,"21:52:00"]
[null,6,"12:45:00"]
[null,7,"12:12:00"]