Hi Expert here,

In Cell A2 i have time 08:00 AM

I need to show if present time between 5am to 6.30 am then 3
If it's between 1pm to 2 pm 1 and
If it's between 9pm - 10 pm then 2

Hope you could understand and can help me sort out

Thanks