J
Jorgen Bondesen
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
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