Calculating Max Simultaneous Records

[Persio Pucci]

Folks,

Can anybody help me on this? I have a table with records that have a date
field (dd/mm/yyyy hh:mm:ss) and a field with duration (hh:mm:ss). I would
like to calculate, on a report, what was the maximum number of records that
occurred simultaneously in a specific timespan, lets say, one hour.

Regards,

Persio

 

[John Vinson]

Folks,

Can anybody help me on this? I have a table with records that have a date
field (dd/mm/yyyy hh:mm:ss) and a field with duration (hh:mm:ss). I would
like to calculate, on a report, what was the maximum number of records that
occurred simultaneously in a specific timespan, lets say, one hour.

How does the duration figure in? What does it mean that two records
"occurred simultaneously"? If one duration ended ten seconds after
the hour started, and another began a minute before the end of the
hour, they both occurred "within" that hour, just not simultaneously;
does that count?

 

[Persio Pucci]

John,

two records occur simultaneusly when, per example, one starts at 09:00 and
ends at 10:00, and another one started 09:15 and ended 10:15. During one
record's start and stop, if another records is ocurring.

Below some mor examples

#1: Start 09:15 Stop 10:12
#2: Start 08:45 Stop 09:25

They were simultaneous for about 10 minutes.

You see, these records are phone calls to a call center facility, and what I
am trying to find out is, in the peak hour (the hour that had most calls in
a day) what was the maximum number of calls ocurring at the same time
(regardless of they start time and stop time) to measure the numebr of
people to work on this call center facility, for each of the phone numbers
answered there.

Regards,

Persio