title: Calculate Expected End Time In SQL Server
body: <p>I have a SLA Policy as follow:
  Working Days: Monday To Friday.
  Working Hours: 9 AM To 6 PM.</p>
  
  <p>Apart from them, other working hours are considered as After Business Hours.
  Saturday, Sunday and Holidays are excluded from all calculations.</p>
  
  <p>Scenario 1: Ticket is create as Friday, June 29, 2018, 17:30 (5:30 PM). After Working Hours duration is 12 Hours (OR 720 Minute).
  I want to calculate, expected end date, Which would be approximately Monday, July 02, 2018 6 AM, because after 6 pm from June 29 upto 11:59 PM, it's after Business Hours and on Monday from 12 AM to 6 AM, it's after Business Hours.</p>
  
  <p>Scenario 2: If it would be 18 hours for after Business Hours, then approximately end date would be Monday, July 02, 21:00 Hrs (9 PM). 6 hours (of June 29) + 9 Hours (July 02 Morning) + 3 Hours (July 2 Night).</p>
  
  <p>How do I calculate after business hours in calculation for expected end date and time in SQL Server 2008?</p>