title: converting text date with am/pm time into 24 hour time in excel non VBA
body: <p>I am looking to convert a text time with a and p on the end into usable time in excel I have used the mid function and I does not seem to recognize the a/p and makes all the times am unless its 12--. Then it will return a PM time. I have used the Mid function and have searched the threads. </p>
  
  <p>Times in the database look like
  10/ 1/14  5:14P 
  These are text</p>
  
  <p>I have used the mid function
  =TIMEVALUE(MID(B6,9,6))
  Returning 
  5:14:00 AM
  when the time should be a Pm or 17:14</p>
  
  <p>Help would be appreciated
  Thanks</p>