I have a sheet that has a few thousand rows of data. I am trying to find the percentage of occurrences by shift are logged between 04:30 and 06:10 or between 17:30 and 18:10.

I figured out how to count the occurrences between the 4 shifts in column B and show it in column D. My problem counting column A for the above time restrictions is the date being in the same cell. Any way to count these so I can find the percentage?


shifts.PNG