overlapping dates

I am really stuck. I have a data model in PowerPivot 2013 with clients and entry dates and exit dates for specific programs. I need to find the overall length of time between entry and exit assuming that a client cannot physically be in more than one program concurrently and may leave for a...

Hello, This is my first post to this site. Most of what I have learned about Excel has come from Bill Jelen’s books, podcast and information from this site. For that , I thank everyone here! Here is my issue which I would deeply appreciate any assistance which you could kindly offer: I...

Hi all, I'm working on a large dataset (85 K obs), for each observation I have a start date, start time, end date, end time, a field defining whether the observation is a commercial or a show and channel. I want to calculate the amount of overlap time between observations such that they are both...

Hey Everyone, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Got a bit of a head scratcher. I have the following two columns in a spreadsheet that I would like to calculate total elapsed time, however as you see below some of the “timers” that I am...

Hey, I've got a real head scratcher and I hope someone out there can help me. Here is the situation: I have 4 dates -- Budgeted Possession Date, Actual Possession Date, Budgeted Commencement Date, Actual Commencement Date. Budgeted Possession always comes before Budgeted Commencement and...