2 Replies Latest reply on Dec 17, 2015 7:52 PM by KK Molugu

    How to calculate hours between two dates excluding e.g. saturdays

    Anton Gustafsson

      Hi!

       

      I want to calculate the lead time for a process with a start date-time and an end date-time. The problem is that I want to exclude hours during particular days of the week, the typical case being weekends. However, I would like to be able to exclude other days of the week as well.

       

      Example:

      The process starts at 2015-09-18 10:00 and ends at 2015-09-20 16:00 and I want to exclude weekend time --> The result should be 14 hours.

       

      I'm also thinking about the possbility to exclude certain hours of the day, e.g. only taking into account time between 08:00-16:00. The goal really is to sum lead time in the process that occurs during my customers' business hours.

       

      I hope that someone has encountered and solved a similiar problem earlier

       

      Best regards,

      Anton