title: Excel TIME duration over 24 hours
body: <p>Data is:</p>
  
  <pre><code>A1 = 29. B1 = 30. C1 = 2. 
  
  D1 = TIME(A1, B1, C1).
  </code></pre>
  
  <p>How can I get D1 to return <code>29:30:02</code>?</p>
  
  <p>Formatting the D1 cell to [hh]:mm:ss does NOT work!</p>
  
  <p>If I ran for 29 hours in a month, Excel thinks I ran for only 5 hours.</p>
  
  <p>Thank you.</p>
  
  <p>Edit: Thank you!! I got it!!! <code>D1 = TIME(A1, B1, C1) + INT(A1 / 24)</code></p>