Hi NG


I need help.

1 day = 24 h

Start time A1: 8 h
Using time A2: 3 h
Or
Using time A2: 5 h


Break1 start B1: 9
Break1 end B2: 9:15

Break2 start C1: 12
Break2 end C2: 12:3

I want to know when Break1 and/or Break2 are a intersect in time range: 8 to
8+3=11 / 8+5=13

Is there a function like (I know this is for Range):
Set isect = Application.Intersect(Range("rg1"), Range("rg2"))

Both a solution for VBA and formula will be fine, but i prefere VBA

--
Best regards
Joergen Bondesen