Hi.
There are 2 tables Calendar and Facts.
The Calendar contains information of working hours in the date.
The Facts contains information about the opening and closing dates of the task. Accordingly, in order to get the working time spent on a task, it is necessary to add up the Working Time for the entire period from the opening date to the closing date.
Calendar:
Date Working Time
05.06.2019 8,25
06.06.2019 8,25
07.06.2019 7,00
08.06.2019 0,00
09.06.2019 0,00
10.06.2019 8,25
Facts:
Task ID Opened Date Closed Date
1 06.06.2019 10.06.2019
2 05.06.2019 06.06.2019
3 7.06.2019 07.06.2019
4 07.06.2019 10.06.2019
The result is have to be like this:
Task ID Opened Date Closed Date Working Time
1 06.06.2019 10.06.2019 23,5
2 05.06.2019 06.06.2019 16,5
3 7.06.2019 07.06.2019 7,00
4 07.06.2019 10.06.2019 15,25
How to make it in script ?
