Results 1 to 27 of 27

Figure out occurence of overlapping date & time

Threaded View

Yonkers Figure out occurence of... 05-18-2009, 10:25 PM
teylyn Re: Figure out occurence of... 05-18-2009, 11:55 PM
Yonkers Re: Figure out occurence of... 05-19-2009, 07:26 PM
teylyn Re: Figure out occurence of... 05-19-2009, 10:04 PM
Yonkers Re: Figure out occurence of... 05-19-2009, 11:47 PM
teylyn Re: Figure out occurence of... 05-20-2009, 11:22 PM
Yonkers Re: Figure out occurence of... 05-21-2009, 02:02 AM
teylyn Re: Figure out occurence of... 05-21-2009, 07:15 PM
Yonkers Re: Figure out occurence of... 05-21-2009, 11:59 PM
teylyn Re: Figure out occurence of... 05-22-2009, 04:41 AM
Yonkers Re: Figure out occurence of... 05-22-2009, 05:23 PM
teylyn Re: Figure out occurence of... 05-25-2009, 06:49 PM
Yonkers Re: Figure out occurence of... 05-26-2009, 05:49 PM
JazzMak Re: Figure out occurence of... 03-04-2013, 10:25 PM
teylyn Re: Figure out occurence of... 05-26-2009, 07:32 PM
Yonkers Re: Figure out occurence of... 05-26-2009, 08:03 PM
Yonkers Re: Figure out occurence of... 05-26-2009, 09:38 PM
Yonkers Re: Figure out occurence of... 05-26-2009, 09:57 PM
nicoleemily Re: Figure out occurence of... 11-15-2012, 01:00 PM
arlu1201 Re: Figure out occurence of... 11-15-2012, 01:04 PM
eamo628 Re: Figure out occurence of... 07-30-2013, 12:06 PM
kevp913 Re: Figure out occurence of... 01-15-2014, 01:51 PM
jonathan.page Re: Figure out occurence of... 04-10-2014, 09:14 AM
desaia Re: Figure out occurence of... 12-04-2019, 12:19 PM
surjer Re: Figure out occurence of... 01-27-2020, 05:45 PM
FPEPRO Re: Figure out occurence of... 04-28-2020, 02:00 AM
AliGW Re: Figure out occurence of... 04-28-2020, 02:09 AM
  1. #17
    Registered User
    Join Date
    05-18-2009
    Location
    Houston
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Figure out occurence of overlapping date & time

    Well, it seems like you've done it again. Your theory seems to bear it out. I ran that simple formula through all 30k calls and it looks like it gives me what I need.
    What I couldn't wrap my head around was why I didn't need to check if a call overlapped with other calls beyond the initial start. Meaning... a call might only overlap with 2 calls when it first starts but because it lasts 2 hours it ends up overlapping with more calls.
    But then I realized it didn't really matter. I just need to check when the initial call attempt is made. Because if I don't show that specific call as overlapping then the calls below it will capture the fact that was still ongoing, 2 hours later.
    I'm still working the logic through my head but it's beginning to make sense. And it ends up being so simple. Just like we suspected it would be.
    Thanks so very much.

    Edit: I just went back and read through your post and you basically said the same thing I just did. lol. Well, I never said I wasn't dense. I had to go through the logic myself before I could truly understand it.
    Last edited by Yonkers; 05-26-2009 at 09:43 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1