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 |
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 |
All times are GMT +1. The time now is 11:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com