title: Excel Convert text to timestamp
body: <p>I have the following text timestamp in cell A1. <code>22-OCT-13 03.40.00.000000000 AM</code>. In B1 I have the following formula: <code>=TIME(HOUR(MID(A1,11,2)),MIN(MID(A1,14,2)),SECOND(MID(A1,17,2)))</code>.</p>
  
  <p>It yields 12:40 AM. The hour function returns zero, but the minute function works fine. I can't figure out what's up with it.</p>