Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sum formula with overlaping references | Excel Discussion (Misc queries) | |||
bar chart with two Y axis not overlaping | Charts and Charting in Excel | |||
Overlaping conditions....may be | Excel Worksheet Functions | |||
How to get rid of overlaping cells | Excel Discussion (Misc queries) | |||
How to prevent datalabels overlaping each other? | Excel Programming |