Del wrote:

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


=SMALL(IF(E9:E13<0,E9:E13,1000000),1)

If the range is E9:E13. This is an Array Formula, so enter it with
Ctrl+Shift+Enter.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

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.

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.

Thanks Bob, works like a charm!


"Bob Phillips" wrote in message
...
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.