Hello Nigel

9 am to 9 pm
About 1400 calls
1 minute intervals

Thanks for your prompt response.

Regards
farid2001

"Nigel" wrote:

You need to decide the precision of your model, that is the smallest time
interval you wish to use when determining overlapping times. In this case
if you used seconds you need to count occurrence into 86400 intervals (24
hours * 3600 per hour), that is a lot of computation time and could be long
depending on how many calls you are analysing. But maybe that is too
precise, minute intervals would reduce this to 1440.

What precision do you require and how many calls are you typically
analysing?

--

Regards,
Nigel




"farid2001" wrote in message
...
Hello

What I need is a code that could tell me what is the maximum amount of
simultaneous phone calls for a 24 hour period, example:

call # Call started Duration Call ended
6 03/03/2009 09:44:57 00:00:40 09:45:37
5 03/03/2009 09:38:32 00:00:22 09:38:54
4 03/03/2009 09:37:13 00:02:46 09:39:59
3 03/03/2009 09:27:29 00:00:49 09:28:18
2 03/03/2009 09:26:29 00:00:31 09:27:00
1 03/03/2009 09:24:00 00:17:04 09:41:04

In this case, the maximum # of simultaneous calls is 3, since call #1
overlaps with call #4 which also overlaps with call #5

Is it possible to get such a code?

Your help will be appreciated

Thanks & regards
farid2001