0 Replies Latest reply on Nov 4, 2014 12:14 PM by Thomas Scaccabarozzi

    SLM: How to handle the calculation of due dates with weighing segments

    Thomas Scaccabarozzi
      Share This:

      I need to handle the calculation of due dates with weighing segments

      I try to explain better:

       

      I have two time periods:

      Day Time: 9AM-6PM

      Night Time: 0AM-9AM and 6PM-0AM, plus all holidays

       

      The service targets is: 9hrs

      Service avalability: H24 without Pending periods.

       

      Formula to build Due Date:

      "Day Time" + 0.5 "Night Time"

       

      Seconds spent during the night time hours must be weighed 0.5.

       

      Example:

      Issue Opened: 6PM

      Due Date OOB= 5PM+ 9hr = (1hr Daytime) + (8hr NightTime) = 2AM (next day)

      Custom Due Date:  (1hr Daytime) + [(8hr remaining)] --> (7.5hr Night Time + 0.5 DayTime) = 9.30 AM (next day)

       

      Have you got advice, how to manage this custom calculation? Regards