In which case it isn't a time, it's text. You'll need to cure that.
Exactly what format are you seeing for your "times"? If they look like a
genuine Excel time, you may need to check for extraneous spaces, or other
non-printing characters such as non-breaking spaces.
--
David Biddulph

"wynand" wrote in message
...
Thanks a mil this will work except my time shows the same format no matter
what I change it to (number, etc.)

"Mike H" wrote:

Hi,

In Excel times are decimal numbers formatted to look like a recognisable
times. So for example 0.4375 formated as time will display 10:30 or time
in
whatever format you choose.

Min and max will therefore work provided your times are properly
formatted.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"wynand" wrote:

Is there any function (or vba) to determine the earliest and latest
time
(00:00:00) in a range?Tried max, min, small to no avail.