Using time entered in a cell with the cell used in a formula

[ecorf]

I am trying to count the number of times the word "HPCR" appears in Column B that appear before the time of 17:58:00 - more precisely before the time displayed in cell F3.

The code below works (It returns the value of 31, which is correct):

Please Login or Register  to view this content.

However, I want the time to be able to change based on what appears in cell F3. I have 17:58:00 entered in cell F3.
When I use the code below, it returns an incorrect value of 0.

Please Login or Register  to view this content.

Cell F3 has this function:

Please Login or Register  to view this content.

This adds a time in F2 to a time entered in Timing_SheetJ3. When these two times are added it gives me 17:58:00 in F3


Any thoughts on how I can get the COUNTIFS formula to acknowledge the value in cell F3?

Thanks!

[FlameRetired]

Try

Please Login or Register  to view this content.

[ecorf]

Awesome! Thanks FlameRetired for the quick response. I had not tried the &. That works. Really appreciate it.

[FlameRetired]

Good deal. You're welcome, and thanks for the feedback and for marking this thread Solved. It helps.