Forum Discussion
worked time between 2 datetimes with custom weekends and / or periods
I need a solution and I have no idea how to do it
see the below with normal weekends
| start | end | hours (should be) |
| 02/07/2024 07:43 | 02/07/2024 09:43 | 2 |
| 13/07/2024 07:43 | 13/07/2024 10:43 | 0 |
| 19/07/2024 07:43 | 19/07/2024 17:43 | 10 |
| 22/07/2024 06:00 | 26/07/2024 06:00 | 120 |
| 19/07/2024 00:00 | 22/07/2024 00:00 | 24 |
| 23/07/2024 00:00 | 31/07/2024 00:00 | 144 |
From 22/07 to 26/07 is at most 4 days, less if weekend days are involved, so 120 hours is impossible.
Which weekend days/working periods do you want to apply?
