Merging Overlapping date ranges for each id

[motherindia]

Hello Sir,

I Have list of Start date and end Date for each custmer . Column A contains Cust ID and other 2 columns contain Start date and End Date. Basically I need to combine start date and end date if the dates are overlapping each otherand date are consecutive or dates are duplicated else it should remain same.

Following is the Data on SHeet1 and Output sheet should on another sheet.
Data on Sheet1

Cust no Start Date End Date
1111111 23-08-16 25-08-16
1111111 22-08-16 22-08-16
1111111 08-11-14 02-12-16
2222222 12-10-16 30-11-16
2222222 20-07-16 30-09-16
2222222 14-02-16 23-02-16
2222222 14-02-16 23-02-16


Output on Sheet2

Cust no Start Date End Date
1111111 08-11-14 02-12-16
2222222 12-10-16 30-11-16
2222222 20-07-16 30-09-16
2222222 14-02-16 23-02-16

Regards,
motherindia

 

[normverim]

You're welcome

After a more careful review I have found one more problem :P If the range is longer than a day it deducts it to one day. Let me show it in an example;


Original Data;
1111 05.01.2017 09:30 08.01.2017 17:30

After the macro;
1111 05.01.2017 09:30 05.01.2017 17:30

 

[MickG]

That's because the code was based on finding contiguous times, based on unique individual dates, not multiple dates.
If you would like me to amend the code, please supply some basic dates/times with expected results.
.