Hi Del,

Try

=MIN(IF(A1:A100,A1:A10))

as an array formula, so commit with Ctrl-Shift-Enter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Del" wrote in message
...
Is it possible to use an Excel formula to return the lowest time value in
a
row or range, but exclude 00:00 ?

Thanks in advance.

Del.