This is my time value:
19:00 - 23:00

These are my time intervals:
Time interval A: 18:00 - 22:00
Time interval B: 22:00 - 00:00

I want to check if some (or all) hours within the time value occur in
the time intervals. If yes, then give me those hours. So the result
should be:

19:00 - 22:00 (A)
22:00 - 23:00 (B)

Another example.

time value:
07:00 - 15:30

Time interval:
Time interval C: 06:00 - 08:00

Check if some (or all) hours within the time value occur in the time
interval. Yes there's one hour overlapping so the result should be:

07:00 - 08:00 (C)

Question, is there a formula or a VBA solution wich can do that?
Please let me know.

--
With Kind Regards,
BBert

April 20, 1986
Celtics (135) - Bulls (131)
Larry Bird: "God disguised as Michael Jordan"