Add into a formula Right & Len

[Beh162]

My current formula is =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 having an issue because when I copy data in the range C25:C72 and B25:B72 the time now has a date in front of it. I've tried reformatting the cells, but the date won't disappear. So I was thinking of using the Right & Len function to move 8 or 9 places to the right so that it will see the time only. The formula above isn't counting the entries that now have the date.

Thanks for any help in this!

 

[jtakw]

Cross posted here: https://www.excelforum.com/excel-formulas-and-functions/1237286-removing-a-date-from-a-cell.html

 

[Beh162]

Cross posted here: https://www.excelforum.com/excel-formulas-and-functions/1237286-removing-a-date-from-a-cell.html

No problem seeking help from different places. As many people have many different approaches and it’s a great learning tool

 

[jtakw]

#13 - https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

& https://www.excelguru.ca/content.php?184

 

[Beh162]

I was speaking from my own opinion, I'm aware of the rules now.

 

[Beh162]

This post is pending being deleted - Request sent to moderator

 

[Macropod]

I was speaking from my own opinion, I'm aware of the rules now.

Kindly don't report others for bringing your disregard for the rules, claiming 'harrasment'. Doing so is out of order and reflects poorly on your attitude... We also don't delete threads just because you don't like the responses received.