title: Elapsed Days Hours Minutes Excluding Weekends and Holidays Time
body: <p>This sounds simple but I have been pulling my hair out trying to figure out a solution. Any help before I go bald would be great. </p>
  
  <p>I need a formula which is able to</p>
  
  <ul>
  <li>calculate the duration in (days, hrs, mins) between two date\time values (eg <code>05/12/2012 5:30 PM</code> and say <code>07/12/2012 5:45 PM</code>); </li>
  <li>excluding weekends and holidays.</li>
  </ul>
  
  <p>I would like the result of the formula to read as follows "e.g <code>2 Days 0 Hrs and 15 Mins</code>".</p>
  
  <p>Thanks</p>
  
  <p>Link to <a href="http://www.excelforum.com/attachment.php?attachmentid=199111&amp;d=1355089580" rel="nofollow">sample workbook</a></p>