{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["FullData","sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"FullData","index":0,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["CustNo","CustId","Date","Time","heading1","heading2","heading3","heading4","heading5","heading6","heading7","heading8","heading9","Max","Min"]
["data","data","2014-10-08","08:10:23",1,"data","data","data","data","data","data","data","data",{"$f":"D2=MAX(IF(C2=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D2=MIN(IF(C2=$C$2:$C$3000,$D$2:$D$300))","v":true},null,"First copy these two formulas which will answer the lowest and highest time value on particular date. And then run the macro"]
["data","data","2014-10-08","08:10:27",2,"data","data","data","data","data","data","data","data",{"$f":"D3=MAX(IF(C3=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D3=MIN(IF(C3=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-08","08:10:31",3,"data","data","data","data","data","data","data","data",{"$f":"D4=MAX(IF(C4=$C$2:$C$3000,$D$2:$D$300))","v":true},{"$f":"D4=MIN(IF(C4=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-09","08:10:34",4,"data","data","data","data","data","data","data","data",{"$f":"D5=MAX(IF(C5=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D5=MIN(IF(C5=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-09","07:58:27",5,"data","data","data","data","data","data","data","data",{"$f":"D6=MAX(IF(C6=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D6=MIN(IF(C6=$C$2:$C$3000,$D$2:$D$300))","v":true}]
["data","data","2014-10-09","08:01:05",6,"data","data","data","data","data","data","data","data",{"$f":"D7=MAX(IF(C7=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D7=MIN(IF(C7=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-09","09:12:33",7,"data","data","data","data","data","data","data","data",{"$f":"D8=MAX(IF(C8=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D8=MIN(IF(C8=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-09","09:39:53",8,"data","data","data","data","data","data","data","data",{"$f":"D9=MAX(IF(C9=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D9=MIN(IF(C9=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-09","09:48:04",9,"data","data","data","data","data","data","data","data",{"$f":"D10=MAX(IF(C10=$C$2:$C$3000,$D$2:$D$300))","v":true},{"$f":"D10=MIN(IF(C10=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-10","07:33:42",21,"data","data","data","data","data","data","data","data",{"$f":"D11=MAX(IF(C11=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D11=MIN(IF(C11=$C$2:$C$3000,$D$2:$D$300))","v":true}]
["data","data","2014-10-10","19:06:30",25,"data","data","data","data","data","data","data","data",{"$f":"D12=MAX(IF(C12=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D12=MIN(IF(C12=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-10","19:13:27",29,"data","data","data","data","data","data","data","data",{"$f":"D13=MAX(IF(C13=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D13=MIN(IF(C13=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-10","19:25:36",33,"data","data","data","data","data","data","data","data",{"$f":"D14=MAX(IF(C14=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D14=MIN(IF(C14=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-10","19:42:52",37,"data","data","data","data","data","data","data","data",{"$f":"D15=MAX(IF(C15=$C$2:$C$3000,$D$2:$D$300))","v":true},{"$f":"D15=MIN(IF(C15=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-11","07:22:15",41,"data","data","data","data","data","data","data","data",{"$f":"D16=MAX(IF(C16=$C$2:$C$3000,$D$2:$D$300))","v":true},{"$f":"D16=MIN(IF(C16=$C$2:$C$3000,$D$2:$D$300))","v":true}]
["data","data","2014-10-12","10:20:31",45,"data","data","data","data","data","data","data","data",{"$f":"D17=MAX(IF(C17=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D17=MIN(IF(C17=$C$2:$C$3000,$D$2:$D$300))","v":true}]
["data","data","2014-10-12","11:26:36",49,"data","data","data","data","data","data","data","data",{"$f":"D18=MAX(IF(C18=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D18=MIN(IF(C18=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-12","15:21:02",53,"data","data","data","data","data","data","data","data",{"$f":"D19=MAX(IF(C19=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D19=MIN(IF(C19=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-12","18:05:39",57,"data","data","data","data","data","data","data","data",{"$f":"D20=MAX(IF(C20=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D20=MIN(IF(C20=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-12","18:05:54",61,"data","data","data","data","data","data","data","data",{"$f":"D21=MAX(IF(C21=$C$2:$C$3000,$D$2:$D$300))","v":true},{"$f":"D21=MIN(IF(C21=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-13","08:08:28",65,"data","data","data","data","data","data","data","data",{"$f":"D22=MAX(IF(C22=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D22=MIN(IF(C22=$C$2:$C$3000,$D$2:$D$300))","v":true}]
["data","data","2014-10-13","08:31:59",69,"data","data","data","data","data","data","data","data",{"$f":"D23=MAX(IF(C23=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D23=MIN(IF(C23=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-13","14:08:54",101,"data","data","data","data","data","data","data","data",{"$f":"D24=MAX(IF(C24=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D24=MIN(IF(C24=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-13","14:11:30",105,"data","data","data","data","data","data","data","data",{"$f":"D25=MAX(IF(C25=$C$2:$C$3000,$D$2:$D$300))","v":false},{"$f":"D25=MIN(IF(C25=$C$2:$C$3000,$D$2:$D$300))","v":false}]
["data","data","2014-10-13","14:18:19",105,"data","data","data","data","data","data","data","data",{"$f":"D26=MAX(IF(C26=$C$2:$C$3000,$D$2:$D$300))","v":true},{"$f":"D26=MIN(IF(C26=$C$2:$C$3000,$D$2:$D$300))","v":false}]

{"sheet":"sheet2","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["CustNo","CustId","Date","Time","heading1","heading2","heading3","heading4","heading5","heading6","heading7","heading8","heading9"]
["data","data","2014-10-08","08:10:31",3,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-09","09:48:04",9,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-10","19:42:52",37,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-11","07:22:15",41,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-12","18:05:54",61,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-13","14:18:19",105,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-08","08:10:23",1,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-09","07:58:27",5,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-10","07:33:42",21,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-11","07:22:15",41,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-12","10:20:31",45,"data","data","data","data","data","data","data","data"]
["data","data","2014-10-13","08:08:28",65,"data","data","data","data","data","data","data","data"]