Lowest and highest time in EXCEL

I have a columns with times (in miuntes) formatted to show me minutes only and at the bottom I would like to have
the time that took the longest =large(A2:A31,1) and it seams to work fine
but when I do =min(A2:A31) to find the time which took the shortest time to do - it will not show me the true answer

Please help me - this is the example in column A

0 - 12 Mins
0 - 14 Mins
0 - 14 Mins
0 - 15 Mins
0 - 13 Mins
0 - 13 Mins
0 - 10 Mins
0 - 11 Mins
0 - 12 Mins
0 - 07 Mins
0 - 11 Mins
0 - 14 Mins
0 - 13 Mins
0 - 13 Mins
0 - 16 Mins

0 - 12 Mins (this is the answer it comes up with as the shortest time!! when it should be 0 - 07 Mins)
0 - 16 Mins (this works with the "large" function)

Originally Posted by Ace_XL

With FDibbins suggestion use ..

=MID(H1,5,2)*1 just to enusre that text (if any) is converted to number.
You could then use the Large(Range,1) or Max(Range) & Small(Range,1) or Min(Range) formula

Hi FDibbins

The values that I have given are a result of a basis formula from two times on another sheet - starting time and finishing time. So to answer your question the values in this column are actually time based. I also thought that the Large function has coincidently worked, but was not sure why??

Any thoughts??

Hi There FDibbins

I have attached the file. Sheet one contains all the times, and sheet 2 contains the results, which are used to conditional format best times & longest time for each person (A-E).

I know I am close but just cannot seem to work it out.

Thank you again

Tried it and it did not work for me

On my attachment on SHEET 3 column D, the lowest time is 7 minutes and it still shows me 12 minutes. infact your method showed the same results as =MIN(D2:D31)

THANK YOU, THANK YOU, thank you, I feel like such a fool

IT WORKED!!!!!!!!