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

G

Guest

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!
 
T

T. Valko

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
 
H

Harlan Grove

T. Valko said:
Not sure I understand what that means. ....
=MIN(A1:A5) returns 12:00 AM
Click to expand...
....

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to return lowest value of 3 datapoints 3
find two (2) lowest values in a range (Excel) 3
I need Time Range to return Value 4
Trying to subtract the two lowest values from a row of numbers 4
Earliest time in a range 3
Find the lowest4 numbers of the last 6 in a range 8
SUMIF using value from MOD function 2
Return the value from one range that does not exist in another 0

Top