title: Libreoffice Calc: date string to date/time values
body: <p>I need to extract a 'date string' as separate columns representing date/time data.</p>
  
  <pre><code> | A                        | B                 | C
  -+--------------------------+-------------------+-----------------
  1| Datetime String          | Date Value        | Time Value
  2| Sat 09 Sep 2017 20:00 PM | =DATEVALUE(A2)    | =TIMEVALUE(A2)
  </code></pre>
  
  <p>The above functions <code>DATEVALUE</code> and <code>TIMEVALUE</code> return errors. I'm at a bit of a loss at the moment.</p>