I executed your suggestion again from scratch with the same result (with the difference that I truncated the data file to make things easier to handle):
In[1]:= path = "C:\\Users\\User\\Desktop\\ShortTestDataNov2013.csv"
Out[1]= "C:\\Users\\User\\Desktop\\ShortTestDataNov2013.csv"
In[2]:= data = Rest@Import[path]
Out[2]= {{"11/4/2013", "9:05:45", 80.75, 9.4}, {"11/4/2013",
"11:06:21", 78.09, 9.4}, {"11/4/2013", "12:40:52", 76.9,
9.7}, {"11/4/2013", "15:02:47", 74.27, 9.6}, {"11/4/2013",
"15:43:46", 75.16, 10}, {"11/4/2013", "17:24:29", 73.66, 11.4}, {""}}
In[3]:= data =
data /. {d_String, t_String, z_} :> {DateList[d <> ":" t], z}
Out[3]= {{"11/4/2013", "9:05:45", 80.75, 9.4}, {"11/4/2013",
"11:06:21", 78.09, 9.4}, {"11/4/2013", "12:40:52", 76.9,
9.7}, {"11/4/2013", "15:02:47", 74.27, 9.6}, {"11/4/2013",
"15:43:46", 75.16, 10}, {"11/4/2013", "17:24:29", 73.66,
11.4}, {""}}
I don't see what I'm doing wrong.
Attachments: