How do I tell if a time in one cell is within two times in other cells?
all three of the cells are formatted as time h:mm:ss
thanks for any help!
How do I tell if a time in one cell is within two times in other cells?
all three of the cells are formatted as time h:mm:ss
thanks for any help!
In A1:C1...
1:01:27 3:37:17 2:45:43
Check if C1 is between A1 and B1
=IF(AND(C1>=MIN(A1:B1),C1<=MAX(A1:B1)),"You betcha","Nope")