overlap time

Hi, Below is the data. Is there any formula that define the specific hour or specific period that overlap 3 times. Overlap 2 times is fine. I tried to separate the date and time then try Sum product but not work. I also tried to design the hour for each date it was used however unsure how to...

Hi. I have a spreadsheet with two sheets, Sheet1 holds my main data set which is an audit trail of incident assignments each row representing an assignment to a support group. The key columns are Incident Number (column A), Assignment Start Date/Time (column B) and Assignment End Date/Time...

Hi, I have a spreadsheet that contains multiple entries each with a start and end time. I want to be able to identify overlapping time entries and then be able to group the overlapping entries by perhaps assigning a Overlap Group ID to pairs of overlapping entries. Start and End Times can be...

Hi folks, I have been having problem with some overlapping events and I hope I can find a solution here maybe a guru helps: I would like to calculate each even’ts non-overlap minutes from a time series of downtime events. A generic formula supposed to work for any duration of a time event...