Task/Ticket Duration

[Anonymous]

I am facing the challenge to calculate the duration of Tasks/tickets Duration and exclude times outside working hours and exclude breaks.

Currently working hours and breaks are defined in a table (to make it more flexible). In script I run through all data (using peek) and calculate the duration by subtracting breaks. Unfortunatley this is very slow (e.g. 20000 rows need about 3 minutes).

Is there a Chance to calculate this on surface?

e.g. Working hour 8:00 - 17:00

       Break1: 9:00-9:15

       Break2: 12:00-12:30

       Break3: 14:00-14.45

Taskevent might be

08:30-13:00    - which should result in 3h 45 Duration

09:10-09:30   - which should result in 15 minutes

10:00-10:10  - which should result in 10 minutes

Task can occur at any time and be ended at any time

I prefer a solution with is able to handle flexible times (working hours, breaks, no of breaks etc.) so I can use it for other Projects as well

Any idea? Is

[Anonymous]

I tested your script and tried to adapt it to my data

your solution is very fast!!

the data is not yet correct, but that is due to the Adaption of my data

I Need to continue on thursday, so meanwhile thank for your solution

If I get your solution working with my data, I give you a feedback

and I may document the final solution (I have additional calculations to do)