Return the Cell Value if it falls between either of two times of day

[NYCTS]

I have a column with various times listed throughout the day that an event occured. I'm trying to separate out the times that fall between 11pm and 5am from this set. However, in the new column that will hold the formula I want it to display the actual times that it found (ie, return 1:03 AM instead of simply True or some other thing I would set). I want it to list all of the actual values that fall between these times.

Further information in case it helps:

So far I have tried creating a set of 2 rows labelled under a heading of "Time" like this, but I'm not sure how to use it properly in a formula to return the values in my other time column:

Time Time
>=11:00 PM <=11:59 PM
<5:00:00 AM >12:00 AM

That was done with the hope that it would cover 11p-5a without any errors or omissions and be used within a formula as some sort of criteria.

Please let me know if you can help out with a formula to return the actual values between 11p and 5a.

Also let me know if you need any other information that I may have left out.

Thanks!!!

[RobertMika]

Could you attached your spreadsheet?

[NYCTS]

Could you attached your spreadsheet?

The spreadsheet is attached - thanks!!Time Sheet.xlsx

[NYCTS]

Any insight now that this is attached?

Thanks,
NYCT

[Pepe Le Mokko]

Hi NYCT, everyone being a volunteer here and helping others for free on their spare time, a little more patience would be welcome