Formula to determine if time is within range

[odonovanc]

Let's say I have a cell that has the following value in cell A1: 8/31/2023 11:54:00 PM. The cell is in mm/dd/yyyy hh:mm format.

I want to write a formula that will tell me if the time in that cell is between 23:00 (11:00 PM) and 7:00 (7:00 AM). I need the date to be ignored altogether.

Help!!

 

[odonovanc]

Oops won't work for the morning, try

=IF(OR(MOD(A1,1)>=11/24,MOD(A1,1)<=7/24),"y","n")

=IF(OR(MOD(A51,1)>=23/24,MOD(A51,1)<=7/24),"y","n")

Replace the 11 with a 23. Seems to be working now. Thank you so much for the help.

 

[Fluff]

Oops missed that as well.
Glad you sorted it Thanks for the feedback.