Total time between intervals

Originally Posted by nigelbloomy

Attachment 394717
I used Countifs() on the attached file. The if statement assumes the work has to end between the intervals you listed.

I tried that method already, but problem is that it doens't include those services, which have started before beginning of interval. For example:

Start: 10:00
End: 16:00

In this situation there is worker producing service during all that time and time should be include every interval during that time. And sorry, I have MISTAKE in my previous post. I'm trying to calculate time in MINUTES!

-J