7 Replies Latest reply on May 15, 2018 9:31 AM by steven huang

    How to calculate business hours/minutes between two dates?

    Jared Meakin

      I'm trying to understand how to go about calculating business hours between two dates.

       

      For example if I have a start date of 08/29/2013 15:00:00 and an end date of 08/30/2013 10:00:00. I'd expect that the calculation would return 3.00 hours if business hours are defined as 0900-1700.

       

      Has anyone had to tackle this before, or can someone point me in the right direction?

       

      Thanks! - Jared