6 Replies Latest reply on Apr 22, 2014 8:19 AM by Prashant Sharma

    Weekend Calculation ** Urgent**

    Abhilash M

      Hi Experts,

       

      I am building a metrics on cycle time, which is focus on total time taken to close an SR.

      below is the example:

      Start DateEnd DateExpected result
      3/29/2014  10:52:00 AM4/3/2014  9:32:00 AMapprx 75 hrs
      3/27/2014  9:44:00 AM4/4/2014  9:15:00 AMapprx 138 hrs

       

      Assumption :

      24 hrs support,

      Cut off time on Friday mid-night 12 and re start the que monitoring on Monday 6.00 AM

       

      Regards,

      Abhilash..