Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem
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 "Skc" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |