Forum Discussion
Finding the time
JoeEason92 Something like this perhaps?
First you need to enter the times in C so that Excel recognizes them as a time value "hh:mm".
Then, be aware that NOW() returns a date and time value. You only want to use the time portion. That's done by MOD(A3,1)
Using the > operator will find 13:00 as the first time greater than 12:39. since you want the latest time that is NOT greater than the current time, just deduct 1 at the end.
=INDEX(B1:B4, MATCH(TRUE, C1:C4 > MOD(A3,1), 0)-1)
JoeEason92 Something like this perhaps?
First you need to enter the times in C so that Excel recognizes them as a time value "hh:mm".
Then, be aware that NOW() returns a date and time value. You only want to use the time portion. That's done by MOD(A3,1)
Using the > operator will find 13:00 as the first time greater than 12:39. since you want the latest time that is NOT greater than the current time, just deduct 1 at the end.
=INDEX(B1:B4, MATCH(TRUE, C1:C4 > MOD(A3,1), 0)-1)
