I need to return the lowest time value in a range of cells.
 

Have an Excel '03 sheet with time values (we track patient flow data) and I
need to find and return the earliest time over a range of cells. I have tried
MIN and MINA but since the values are times, the function only returns the
lowest number in the time. Looking for the simplest way to accomplich this
goal. Thank you for reading and your time!

I need to return the lowest time value in a range of cells.
 

the function only returns the lowest number in the time.

Not sure I understand what that means.

.............A.........
1.....3:20 PM
2.....1:15 AM
3.....12:00 AM
4.....10:17 AM
5.....6:40 PM

=MIN(A1:A5) returns 12:00 AM

You might have to format as TIME.

Biff

"al elkins" wrote in message
...
Have an Excel '03 sheet with time values (we track patient flow data) and
I
need to find and return the earliest time over a range of cells. I have
tried
MIN and MINA but since the values are times, the function only returns the
lowest number in the time. Looking for the simplest way to accomplich this
goal. Thank you for reading and your time!

I need to return the lowest time value in a range of cells.
 

"T. Valko" wrote...
the function only returns the lowest number in the time.
Not sure I understand what that means.
....
=MIN(A1:A5) returns 12:00 AM
....

Possible the OP meant the range contains dates and times, but OP wants
earliest time of day ignoring the date portion. If so, requires an
array formula.

=MIN(MOD(rng,1))