title: Have Excel sort by time?
body: <p>For some reason, when I try to sort excel data by time, Excel ignores me and does whatever it wants.  </p>
  
  <p>I have a column that shows millitary time (13:00 instead of 1:00 PM) and all the time stamps have the date 1/0/0.</p>
  
  <p>When I try to sort the column by value, Excel does not do that.<br>
  How Can I get the column to display:</p>
  
  <pre><code>10:00 
  13:24
  13:44
  </code></pre>
  
  <p>Instead of:</p>
  
  <pre><code>10:00
  13:44
  13:24 
  </code></pre>
  
  <p>(for example)  </p>
  
  <p>Thanks!</p>