Find minimum time value?

[bsacco]

I'm attempting to find the LOWEST time value in a ROW.

I have (3) times entered into (3) cells consecutively. They are A1, B1 and C1

2:04.22 1:59.69 2:02.00


I tried using =MINA(A1:C1) but it returns "0" because of the formatting the time issue.

Anyone have any work-arounds?

 

[barry houdini]

If the times are formatted as text you could get zero, try

=MIN(A1:C1+0)

confirmed with CTRL+SHIFT+ENTER

 

[bsacco]

entering =MIN(A1:C1+0) did not work

I got a value Error

 

[bsacco]

there seems to be a real weird problem when excel has to deal with TIME formats.

Does anyone have a suggestion as to what TIME format I should use in each CELL so that when I apply the formula I don't get errors?

 

[barry houdini]

entering =MIN(A1:C1+0) did not work

I got a value Error

That formula is an array formula, you need to confirm with CTRL+SHIFT+ENTER so that you get curly braces like { and } around the formula in the formula bar.

To do that select cell with formula then press F2 then hold down CTRL and SHIFT keys and press ENTER

 

[bsacco]

Sorry, I'm a newbie. I didn't work all I have now is =MIN{K74:M74+0}

I don't understand what you mean by "array" formula and all this F2 cntrl + Shift+enter stuff...

 

[Scott Huish]

Normally when you enter a formula in the formula bar, you just hit Enter, in this case you need to hold down the CTRL key, the SHIFT key and the ENTER key when you enter the formula instead of just Enter. Do not type the {}, Excel will put them in if you have entered the formula correctly.

Enter the formula exactly like this:

=MIN(K74:M74+0)

and then hit CTRL-SHIFT-ENTER as described above.

 

[bsacco]

ok, yes, but the formula still does not work.

 

[Scott Huish]

With the result cell formatted as mm:ss.00

It worked for me:

Excel Workbook
	A	B	C	D	E
1	2:04.22	1:59.69	2:02.00	*	01:59.69
Sheet1

ok, yes, but the formula still does not work.

That doesn't tell us anything, what did or didn't happen?

 

[bsacco]

I suppose my spreadsheet is corrupted with bad formats or something...is that possible?

How do you wipe clean and start over without losing the data?