title: Convert date e.g. Jun 05 2016 08:00:00 to dd/mm/yyyy hh:mm:ss
body: <p>Got input such as in the topic title.
  Trying to figure out how to convert this into UK date and time to be used in calculations.</p>
  
  <p>I've looked at some methods on Google such as using text to columns, but I don't think this is what I'm looking for...</p>
  
  <p>Thanks!</p>
  
  <p>Edit: month is always in abbreviated format.<br>
  Edit 2: I should mention that I'm in the UK, and it doesn't seem to convert US date automagically.<br>
  Edit 3: Data:</p>
  
  <p>Jun 05 2016 08:00:00 to dd/mm/yyyy hh:mm:ss</p>