8 Replies Latest reply: Jul 10, 2013 6:28 PM by Stefan Wühl RSS

    Calculate Working Hour Interval Between Two Dates

      Hi,

       

      I am trying to calculate the working hour interval between two dates (close date and open date).

       

      The requirement is to exclude Thursday and Friday (as weekends) from the duration and working hours should be

      7.30 AM to 6.00 PM. The interval should be calculated duration only for business hours and therefore also excluding weekends.

       

      I did calculate this in the script but the interval value seems to be more than a couple of hours against the desired value.

       

      Could somebody please tell me where I'm going wrong?

       

      Please see the attached files for a sample.

       

      Regards & Thanks,

       

      -Khaled.