Hello,

I would greatly appreciate if you could help me witht the following problem.

I have two adjacent length intervals:

Interval 1 goes from 237 Km to 356 Km.
Interval 2 goes from 356 Km to 491 Km.

I also have a table with the daily start and end points of the work done for
that day:

Work on day 1: from 313 Km to 377 Km.
Work on day 2: from 289 Km to 357 Km.
(etc.)

Is there a formula that can calculate what is the daily length that falls
within each interval?

For example:

On day 1:
Work done on interval 1 = 43 Km (356 - 313);
Work done on interval 2 = 21 Km (377 - 356).

On day 2:
Work done on interval 1 = 67 Km (356 - 289);
Work done on interval 2 = 1 Km (357 - 356).

Thank you very much for the help!

--
igor