title: Formatting issues and abbreviated data entries with time series data in Pandas
body: <p>I am working with time series data that I collected. For example, the time column has entries that look like 10/16/2018 11:55:57 AM when I open the CSV on Excel, but when I open the CSV on pandas doing pd.read_csv(filename) and look at the time column, it gives me '55:57.1' for the same entry. When I do df['time'] = pd.to_datetime(df['time']), it is not recognizing the current entries at times and gives the following error: <code>ValueError: hour must be in 0..23</code>.</p>
  
  <p>Do you know why this difference occurs and how to fix it? Do I have to specify when opening the csv that I am working with time series data? </p>