title: Excel Convert Time HH:MM:SS to Time elapsed MM:SS
body: <p>The data I have is formated as HH:MM:SS where the seconds are all 00, so a time like </p>
  
  <pre><code>     12:22:00
  </code></pre>
  
  <p>Should be </p>
  
  <pre><code>     00:12:22  
  </code></pre>
  
  <p>Is there a way I can convert this over in excel?</p>
  
  <p><strong>EDIT:</strong> </p>
  
  <p>Probably a better example.</p>
  
  <p>A time of zero.  So that means no time was elapsed shows up as </p>
  
  <pre><code> 12:00:00 AM
  </code></pre>
  
  <p>Instead OF</p>
  
  <pre><code>  00:00 (MM:SS)
  </code></pre>
  
  <p>Thanks!</p>