Time Intervals

[sr71aa]

Hi everyone!

I need some help. Here is my table:

NAME START TIME STOP TIME
J SMITH 12:00:00 AM 6:00:00 AM
S SMITH 3:00:00 AM 7:00:00 AM
Z SMITH 5:00:00 AM 1:00:00 PM

I want to calculate how many people work per interval of half an hour. From this example, the results should be:

12:00:00 AM 1
12:30:00 AM 1
1:00:00 AM 1
1:30:00 AM 1
2:00:00 AM 1
2:30:00 AM 1
3:00:00 AM 2
3:30:00 AM 2
...................
5:00:00 AM 3
5:30:00 AM 3
6:00:00 AM 2

I'm looking for a way to do this. Ultimately, I'm trying to automate scheduled hours in a way that I can produce an IDP (Intra-Day Performance Report). I work in a call center, but unfortunately, we do not have any Workforce Software as of yet. If anyone has any suggestions, I would greatly appreciate it.

Regards.

 

[RuralGuy]

Hi sr71aa,

This is not exactly on point but I believe it involves the same logic and should give you some ideas.
Clashing Events/Appointments

 

[sr71aa]

The theory is sound. Thank you so much. It is greatly appreciated.