LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sum formula with overlaping references RBall Excel Discussion (Misc queries) 2 October 2nd 08 07:13 PM
bar chart with two Y axis not overlaping Melissa Charts and Charting in Excel 1 March 15th 08 03:05 AM
Overlaping conditions....may be Gaurav[_2_] Excel Worksheet Functions 9 November 27th 07 06:52 PM
How to get rid of overlaping cells Chaz Excel Discussion (Misc queries) 1 January 11th 06 09:23 PM
How to prevent datalabels overlaping each other? Cool Sport Excel Programming 1 September 26th 05 10:31 PM


All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"