ExcelBanter - check if or not time lies between a time interval

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - check if or not time lies between a time interval (https://www.excelbanter.com/excel-worksheet-functions/445807-check-if-not-time-lies-between-time-interval.html)

Jaspreet281

check if or not time lies between a time interval

i have different entry times with me and i want to know whether they were between 10 pm to 7 am,

so if i have an entry time of 1.40 am, the formulla should return me "incorrect"
and
say if the ebtry time is 10.00am, the formulla should return me "correct"

Can anyone please help me with this!!!

All times are GMT +1. The time now is 10:22 AM.