Total time between intervals

[Japanila]

Hi,

I want to calculate how much services are produced during chosen intervals. I have only one service and start and end times (hours:minutes:seconds). There is multiple workers producing service during day. I want check how much service hours are produced between hours. So intervals are then for example 8:00-9:00, 9:00-10:00 and so on. I dont know how to do it or should I use functions or pivot. I put example sheet to attachments.

-J

[nigelbloomy]

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

[Japanila]

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

[Japanila]

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

[nigelbloomy]

I've tried this several different ways and haven't been able to figure it out. Hopefully someone else can answer this. I would like to see how they do it.

[Japanila]

Friend of my advised shortcut method. I wanted to count how much services are produced between different intervals in minutes. I also had total capacity (start and end times of labors). Now I had to use amount of labors to see how capacity was utilized. I'm really interested to see if someone can do same counting in minutes. I put "shorcut" solution to attachments.

-J