Hello Everyone,
I'm working on one dataset for a very long time and needs help. In the data we have start and stop time. There are different shift timing. I want to check whether a time is in between two time. I've used this formula (=IF($Q$1=MEDIAN(L2,M2,$Q$1),"Yes","No")) which is working fine. However it is giving accurate results when the given time is post 12 AM.
For example: The formula is not giving correct results when start time is 5 PM and end time is 2 AM and when I want to check whether 12:30 AM is in between 5 PM to 2 AM.
Requesting to help with this.
Thank you.
