Occurence happens w/i an hour on a day

Hello everyone,

I need help. I am trying to figure out how many times an occurrence happens within a given hour on a given day of the week. I have tried using the lookup formula, but I don’t think that’s the correct one.
The times I have are in cells P3:P300 and are in military time less the “:”
The days are in N3:N300 and are in number format, 1 for Sun, 2 for Mon, 3 for Tue and so on.

Example:
If cells N3:N300 = 6 or Fri, then I want it to look at the corresponding cells in P3:P300 and count if the value in P3:P300 is >=1700 - >1760 or between 5 and 6 pm. Can I do this?

Please help. I know you can.

Chris