Hi! I have been using an if function to check if a time value is between two other times. The formula I've been using is =if(and(B4>=C5;B4<=C6);"true";"false") with C5 containing the start value, C6 the end value and B4 the time value that I want to check. So for example, if I want to know if the 00.10 (which is B4 in this case) falls between 23.40 (which is C5 in this case) and 01:00 (C6 in this case), it says false but I want it to say true. Anyone that knows an easy formula to fix this?
Bookmarks