Calculate duration of work, according to date range

[thoe0059]

Hello everyone,

I have an objective to calculate the time in hours, on different dates. 

I doesn't matter what activities happen on that day, and if there is an overlap it should not be accounted for. I simply need to know how many hours went from starting working that day until the work stopped. 

Also it is important that the work is sorted into categories of the work location. 

A visual representation of this is added in my example workflow, along with the desired output.

I hope you guys can help me in the right direction.

Kind regards,

Thøger

[thoe0059]

Hey Emil, thanks for the help. I also found a similar solution myself, but it's great to have it verified 🙂