This is a problem that mathematicans have explored for 100 years. It is a
class project that many teacher assigned. The solution involves making that
divides a 24 hour time period into equal time periods like 1 minute, 2
minutes, 5 minutes, 10 minutes, 15 minutes. Lets say we use 5 minutes then
your worksheet will look like this

Column A

12:00 AM
12:05 AM
12:10 AM
12:15 AM

skip time - contiue like this until midnight

11:40 PM
11:45 PM
11:50 PM

11:55 PM


Next take each of your phone call and add 1 to column B for each time period
in the table above when they occur. A phone call can be placed in more than
one entry in the table. The time period with the largest number in column B
is the answer.

"farid2001" wrote:

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