TOTAL HOURS START OVERLAP 1 END OVERLAP 1
6:15 0:00 6:15
13:00 6:15 3:00
8:15 3:00 0:15
6:15 0:15 0:15
6:15 0:15 0:15
14:30 0:15 11:00
8:45 11:00
6:15 0:15
6:15 0:15 0:15
Here is my formula: =SUMPRODUCT(($Q$2:$Q$9>=AF2)*($R$2:$R9<=AL2)*($R$2:$R$9>=AL3))
Q=total hours
R=start overlap 1
AF2=4:00
AL2=0:30
AL3=0:00
V=end overlap 1
My formula works but what I need to do is do the same formula for column V (end overlap1) but I don't want it to count the row twice if someone has a start overlap AND an end overlap of <=0:30 and >=0:00.
I hope my explanation is understandable.
Bookmarks