worked time between 2 datetimes with custom weekends and / or periods

Copper Contributor

I need a solution and I have no idea how to do it

 

see the below with normal weekends

 

startendhours (should be)
02/07/2024 07:4302/07/2024 09:432
13/07/2024 07:4313/07/2024 10:430
19/07/2024 07:4319/07/2024 17:4310
22/07/2024 06:0026/07/2024 06:00120
19/07/2024 00:0022/07/2024 00:0024
23/07/2024 00:0031/07/2024 00:00144
1 Reply

@SirPickles 

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?