Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Time overlap in excel or access
ok, In the example there is two concurrent calls 2009-5-29 4:04 PM 2009-5-29 4:04 PM 2009-6-1 3:01 PM 2009-6-1 3:01 PM 2009-6-9 11:54 AM 2009-6-9 11:57 AM 2009-6-9 12:07 PM 2009-6-9 12:08 PM 2009-6-9 12:08 PM 2009-6-9 12:08 PM 2009-6-9 12:22 PM 2009-6-9 12:22 PM 2009-6-9...- prldoyle
- Post #7
- Forum: Microsoft: Office
-
Time overlap in excel or access
sorry 30 was just an examle. The data in my first post is just a subet of a much large set of data. at a guess there will be about 4000 entries. Each entry is a single phone call, showing the start time/date and end time/date. This list comes stright form the PBX call detail server. I...- prldoyle
- Post #5
- Forum: Microsoft: Office
-
Time overlap in excel or access
Sorry, i need to know the maxium number of current calls for the whole list. (so over the who list there are 30 entries (30 calls) happen at the same time) I hope i'm explaining my self clearly. If not please let me know and i will try again. Cheers Pete- prldoyle
- Post #3
- Forum: Microsoft: Office
-
Time overlap in excel or access
Hello, I have a list in an access query (but happy to export to Excel for the needed result) of start time and end time (about 4000 of them). These are start time and end time of phone calls within a company. i need to find out the maxium concurrent calls at any one time. The list...- prldoyle
- Thread
- Replies: 9
- Forum: Microsoft: Office
