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