I'm having a bit of an issue where my formula won't work because their is a date appearing in front of the time. For some reason when I copy times from another excel worksheet it through the same date in front of the time. I've tried to custom adjust the formatting of the number, but the date still remains. MY formula is being effected by this because it disregards it because of the date.
Just incase this is my formula: =SUMPRODUCT(--(A11>='Front End'!B$25:B$72),--('Front End'!C$25:C$72>=A11+"00:15"))+SUMPRODUCT(--(A11>='Combo EE'!B$36:B$69),--('Combo EE'!C$36:C$69>=A11+"00:15"))
I'm not sure if there is a way to remove the date, or if I should adjust the formula
Excel3.png
Bookmarks