title: MS Excel how to convert hours to days with only 8 hour period
body: <p>I have an internship with remaining hours of 136:35:00. I want to automatically calculate how many days will I need to consummate the hours in excel but with 8 hours a day period.</p>
  
  <p>I tried using this:</p>
  
  <pre><code>=INT((M10)) &amp;" Days " &amp; INT(MOD(M10,INT(M10))*24) &amp; " Hours and " &amp;
  MINUTE(A11) &amp; " Minutes"
  </code></pre>
  
  <p>but it gave me a literal 24-hour/day period, hence the output:</p>
  
  <pre><code>5 Days 16 Hours and 0 Minutes
  </code></pre>
  
  <p>what am I missing in the formula?</p>