7 Replies Latest reply on May 15, 2012 10:17 AM by Alex Kerin

    Calculate Working minutes taking into account Week days, bank holidays, and Business Hours

    . Apnea

      Hello,

       

      Any help on how to calculate the working minutes, which is a time difference between two (02) date, taking into account the Week day (Monday-Friday), bank holidays, and working business hours (9:00 - 18:00)

       

      Date 1: X1, format: DD/MM/YYYY hh:mm:ss

      Date 2: X2, format: DD/MM/YYYY hh:mm:ss

      Business Hours: 8:00 - 18:00

      List of Bank Holidays: January 1st, May 1st, May 8th...etc

       

       

      Thanks for your help,

       

       

      Paul