Problem

[Guest]

I have an sheet(Excel 2000) 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 do these stats using programming please?

skc

 

[Nikos Yannacopoulos]

Skc,

I posted an answer to the same question in the Access NG for you. Have a
look at it. In theory you can replicate that logic in Excel, but I'll bet
you it's a lot more efficient in Access.

Nikos