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



      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,