title: Excel: Converting mm/dd/yy hh:mm:ss Am/PM to dd/mm/yyy hh:mm:ss in 24 Hrs format
body: <p>I am using spreadsheet and not microsoft excel. I need help in converting below format which should be able to use below formulae in spreadsheet </p>
  
  <pre><code>A1-TRUNC(A1) : to retrieve TIME for this.
  
  8/16/2017 5:15:00 PM
  to 
  8/16/2017 17:15:00
  </code></pre>
  
  <p>I tried using format option, Data/Text to Columns/MDY also used formulae like</p>
  
  <blockquote>
    <p>=SUBSTITUTE(SUBSTITUTE(A1,".pm",""),".",":")+(12/24) but of no help.</p>
  </blockquote>