Split intervalls and sum time frames

Hello forum,
I have this file with interval of postal codes and time frames that I need to split to single rows for each postal code and also sum up the time frames for each column.
The interval can be large or small and time frames can exist and not exist, normally the file contains + 1000 rows with intervals so the sample is just a small example.

First sheet is the data and the result are in the result sheet after process.
I need an vba that can run thru this data and get the result.
Please have a look at the file thank you.

Please Login or Register  to view this content.

Explain to me what is going on in Columns M:R. Where does this data come from?

The attached will get you the rest of the information.

Originally Posted by soreno

In the columns M:R is the time frame from each of the columns Van time 1, Van time 2, Evening time and Truck time.... Van time 1 for example has 10:00-12:00, means the sum of time frame is 2:00 hours. If there is no time frame info then = 0:00
Thanks

The code in post #2 does that.

Click the thread tools at the top of the post and select [SOLVED]. Thanks.