MIN function - ignore blanks

[kdtunstall]

Well....I had the following formula to grab (in the referenced cells) the time that is provided by the user.

=MIN(E6,E36,E72,E108,E153,E193,E233,E253)

Then upon the last update, MIN no longer ignores blank cells and returns 12:00 a.m.

I have tried this one as well (as a test) by bringing the result(s) into a single column.

=MIN(IF(ISNUMBER(M6:M253),IF(M6:M253>0,M6:M253)))

I'm kind of at a loss on this one. All of these cells are hidden and blank, unless the user physically enters a value (Ctrl+shift+

Any insight would be appreciated.

[TMS]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[MrShorty]

In a scenario where MIN() is returning midnight, what are the actual values in E6, E36, ...? What do you see in the MIN() cell if you format as general or other non-date/time format? What do you see if you format the MIN() cell as its full date/time (mm/dd/yyyy hh:mm:ss)?

I've never seen a case where MIN() fails to ignore blanks. Without seeing the data, we cannot debug for you. My guess is that one of those input cells contains a non-zero integer. Any integer formatted as time of day will display midnight. My second guess is that all of the cells contain dates/time/numbers stored as text strings. Since MIN() also ignores text, when all of its inputs are ignored text strings, it returns 0 (which will display as midnight).

Look carefully at the values in your input cells and see what you have in those cells. See what that tells you about the result you are getting from your MIN() function.

[kdtunstall]

In a scenario where MIN() is returning midnight, what are the actual values in E6, E36, ...? What do you see in the MIN() cell if you format as general or other non-date/time format? What do you see if you format the MIN() cell as its full date/time (mm/dd/yyyy hh:mm:ss)?

I went through and deleted all cells and I still got midnight when using MIN.
I then focussed on the user input cell and just double-clicked and it worked.
So this was user error and I appologize for wasting everyone's time. (pun intended)
Y'all have a good weekend and thanks.