Lowest Value
 

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.

Lowest Value
 

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.

Lowest Value
 

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.

Lowest Value
 

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.