I have a sheet that I'm using to calculate work experience. For this problem, I'm looking at 3 columns: Start Date (Column B), End Date (Column C), and Hours per Week (D).
I have Excel currently highlighting overlapping dates (where a person worked more than one job) using this in conditional formatting: =SUMPRODUCT(($B6<=$C$6:$C$50)*($C6>=$B$6:$B$50))>1
However, I want to know if it's possible to only highlight when a person is working more than full time (>40 hours per week). Excel would need to find overlapping date ranges like it is now, but then add up the Column D hours for those overlapping periods and only apply the formatting if the total hours were over 40.
I can't figure out how to do this, but I'm a novice. Any experts out there who can help me?
I have Excel currently highlighting overlapping dates (where a person worked more than one job) using this in conditional formatting: =SUMPRODUCT(($B6<=$C$6:$C$50)*($C6>=$B$6:$B$50))>1
However, I want to know if it's possible to only highlight when a person is working more than full time (>40 hours per week). Excel would need to find overlapping date ranges like it is now, but then add up the Column D hours for those overlapping periods and only apply the formatting if the total hours were over 40.
I can't figure out how to do this, but I'm a novice. Any experts out there who can help me?
