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.