{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Dates","temp column"]
["2011-05-22",{"$f":"TIME(HOUR(A2),MINUTE(A2),SECOND(0))","v":"00:00:00"}]
["2011-05-22T00:30:00",{"$f":"TIME(HOUR(A3),MINUTE(A3),SECOND(0))","v":"00:30:00"},null,null,null,"add temp col and click on the "]
["2011-05-22T01:00:00","01:00:00"]
["2011-05-22T01:30:00","01:30:00"]
["2011-05-22T02:00:00","02:00:00"]
["2011-05-22T02:30:00","02:30:00"]
["2011-05-22T03:00:00","03:00:00"]
["2011-05-22T03:30:00","03:30:00"]
["2011-05-22T04:00:00","04:00:00"]
["2011-05-22T04:30:00","04:30:00"]
["2011-05-22T05:00:00","05:00:00"]
["2011-05-22T05:30:00","05:30:00"]
["2011-05-22T06:00:00","06:00:00"]
["2011-05-22T06:30:00","06:30:00"]
["2011-05-22T07:00:00","07:00:00"]
["2011-05-22T07:30:00","07:30:00"]
["2011-05-22T08:00:00","08:00:00"]
["2011-05-22T08:30:00","08:30:00"]
["2011-05-22T09:00:00","09:00:00"]
["2011-05-22T09:30:00","09:30:00"]
["2011-05-22T10:00:00","10:00:00"]
["2011-05-22T10:30:00","10:30:00"]
["2011-05-22T11:00:00","11:00:00"]
["2011-05-22T11:00:00","11:00:00"]
["2011-05-22T11:00:00","11:00:00"]
["2011-05-22T11:00:00","11:00:00"]
["2011-05-22T11:00:00","11:00:00"]
["2011-05-22T11:00:00","11:00:00"]
["2011-05-22T11:00:00","11:00:00"]
["2011-05-22T11:00:00","11:00:00"]
["2011-05-22T11:00:00","11:00:00"]
["2011-05-22T15:30:00","15:30:00"]
["2011-05-22T16:00:00","16:00:00"]
["2011-05-22T16:30:00","16:30:00"]
["2011-05-22T17:00:00","17:00:00"]
["2011-05-22T17:30:00","17:30:00"]
["2011-05-22T18:00:00","18:00:00"]
["2011-05-22T18:30:00","18:30:00"]
["2011-05-22T19:00:00","19:00:00"]
["2011-05-22T19:30:00","19:30:00"]
["2011-05-22T20:00:00","20:00:00"]
["2011-05-22T20:30:00","20:30:00"]
["2011-05-22T21:00:00","21:00:00"]
["2011-05-22T21:30:00","21:30:00"]
["2011-05-22T22:00:00","22:00:00"]
["2011-05-22T22:30:00","22:30:00"]
["2011-05-22T23:00:00","23:00:00"]
["2011-05-22T23:30:00","23:30:00"]

{"sheet":"Sheet2","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["temp column"]
["11:00:00"]
["11:30:00"]
["19:00:00"]
["19:30:00"]
[null,null,"paste all time vlaues here"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}