View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
farid2001 farid2001 is offline
external usenet poster
 
Posts: 56
Default code for overlaping time

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