Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem 1
Question... 7
Query 3
years-months-days-hours 5
Cell showing date and time - precision error 2
Extracting just the time portion 5
SAVEDATE Format dd/mm/yyyy hh:mm:ss 4
Macro for Copying pasting between different spreadsheets 4

Back
Top