8 Replies Latest reply: Aug 1, 2017 8:01 AM by Mangal Kamble RSS

    Calculate Date-Time Interval without considering weekend.

    pradnya nemade


      id

      Start Date

      End Date

      A13/07/2017  05:01:1514/07/2017 03:10:12
      B14/07/2017 02:12:40

      17/07/2017 01:10:30

      C18/07/2017 04:05:1220/07/2017 02:15:30

       

       

      In Above Scenario

       

      I want to calculate the interval between ID's,

      1) in case of ID "A" we can directly calculate date-time Interval as there's no weekend or holiday.

      2) but in case of ID "B" start date is 14/07/2017 i.e Friday and end date is 17/07/2017 i.e Monday so there's weekend between dates.

      so how to calculate date-time Interval without considering weekend.

      3) and In case of ID "C" suppose there is Holiday on 19/07/2017, so how to calculate date-time Interval without considering holiday.