title: Convert hhmmss to time in Excel
body: <p>I have a column of times in <code>hhmmss</code> format.  What is a formula to convert them to an Excel Time value?</p>
  
  <p>Note that they will not necessarily be zero-padded.  E.g., <code>09:21:34</code> might appear as <code>92134</code> instead of <code>092134</code>.</p>