Question

S

Skc

I have a Excel 2000 sheet that contains phonelogs. These logs are compiled
with Date (dd/mm/yyyy), Time of Day (hh:mm:ss), Start of conversation
(dd/mm/yyyy hh:mm:ss), Duration (hh:mm:ss).

I want to know how many lines (we have 10) are occupied in a particular
timeslot. For instance, if PersonA started his conversation at 27/10/2004
09:01:00 to 09:02:33 and PersonB at 27/10/2004 09:02:00 to 09:10:22 then they
occupied 2 lines for a brief moment as they times clashed.

How can I compile these stats using Excel or a Macro please?

skc
 
R

Rita Palazzi

It would be helpful to me to know how your data is organized. Briefly,
you would compare whether the start date/time of one line is less than
the end time of any of the previous lines. If it is, you can go further
from there by doing time difference calculations to determine how much
overlap there was. If you want to give me an example of how the data is
organized, I can try to be more specific for you.

Rita
 
Top