Smallest value in range above criteria

I have a range of cells with time values like so:

15:01:10; 15:01:12; 15:01:13; 15:01:15; 15:01:16; 15:01:17; 15:01:21; 15:01:22; 15:01:23;

I need to find the smallest time value above my criteria 15:01:13 (in cell A11). So this would be 15:01:15.

I am using =SMALL(A1:A9,COUNTIF(A1:A9,"<"&A11)+1) but it just returns the smallest time value in the range, not the smallest time value above my criteria. It doesn't seem to like the value in A11, even though I have formatted the cell exactly as the cells in the range. Can anyone shed some light on this please?

Try:

=MIN(IF(A1:A9>A11,A1:A9))

confirmed with CTRL+SHIFT+ENTER not just ENTER

If they are all actual time values then I would expect your formula to work.....except you should use <= like

=SMALL(A1:A9,COUNTIF(A1:A9,"<="&A11)+1)

If that doesn't work you can check whether the cells are times (numbers), Try using

=ISNUMBER(A11)

how are the times generated/do they contain dates too?

I don't know what RTD is....

Does this work

=MIN(IF(MOD(A1:A9,1)>MOD(A11,1),MOD(A1:A9,1)))

confirmed with CTRL+SHIFT+ENTER

What formula are you using in A11?

=NOW() generates the current time and date so that means that A11 contains a date (whether you format the cells to show that date or not) so that's why all your times are deemed to be < A11, the date value makes A11 a much larger value than you expect.

I would expect the last formula I suggested, i.e.

=MIN(IF(MOD(A1:A9,1)>MOD(A11,1),MOD(A1:A9,1)))

to work because the MOD function extracts just the time from the time and date.......but you could do that in the A11 formula, e.g. make that

=MOD(A13-A14,1)

That should still show the same time as before but it won't now contain a date, so your original formula should work, presumably A1:A9 are just times?

Note: If you want it to be truly dynamic you probably need VBA to periodically update the current time, it won't update otherwise....

Unless all your times are 0 or they are less than the time in A11, then you should always get a result or you will get an error....

Can you show an example of what you mean?

with Large, it doesn't work the same way, that is why I liked my original suggestion of

=MIN(IF(A1:A9>=A11,A1:A9))

and now for largest

=MAX(IF(A1:A9>=A11,A1:A9))

both confirmed with CTRL+SHIFT+ENTER