Hi! I'm having serious issues with this one and if someone could help me that would be very appriciated!
I'm trying to do an excel function to say if a current time falls between two times. The problem I'm having is if the end time runs after midnight. If I have the current time in B4, start time in B5 and end time in B6, I have been using =if(and(B4>=min(B5:B6);B4<=max(B5:B6))) which is not working if for example B4=00:30, B5=23:30 and B6=02:00. I know it's because Excel doesn't understand it's 02:00 the day after and I've been trying with if-functions to add an extra 24 hours to the end time if the end time is smaller than the start time, but nothing works.
If anyone has an answer to this it would be soo appriciated!
Bookmarks