[Solved] Using MIN to find lowest value of time!

[Hagar Delest]

Greetings to all,
So I have run into an issue of using Min or Max to return a value of time! Example: Driver A ran his fastest lap at '2:50.345 and Driver B had his fastest lap at '2:53.066 and Driver C had a fastest lap at '2:58.553 yet Drivers D and E were disqualified before the race for tech issues. (there are many more drivers but for example purposes I will be using the above only), So, I want to return in a single cell with the lowest lap time during the race. I have tried using many different formulas like MIN, MINIFS, VLOOKUP(MIN()) etc. What are your thoughts?

On the sheet (Race Results Template) Column K is the fastest lap times. In K3 I would like to reflect the Lowest time from the array K5:K99

Thanks in advance,
RevengerXXL

[Zizi64]

Why you use the .csv file format when you want to use the formulas MIN, MINIFS, VLOOKUP(MIN()) etc.?
Always use the native, international standard ODF file formats (.ods for spreadsheets.)

[RevengerXXL]

I just kept the original formatting from the Downloaded csv file of the race results! Easy enough to convert to odf if that would make a difference!

[Zizi64]

Your laptime-like values are strings (textual contents) really, but they are not numerical values.
I just inported the .csv file into a spreadsheet document with the default settings of the import filter, and the laptimes appeared as strings.

[Zizi64]

Check the type of the laptimes in your .ods document, and please upload it in .ods format.

[RevengerXXL]

Also when it is in the ods format it only returns a 0 as lowest time and would an if statement reflect the lowest time for drivers who did return a time and not a 0 for the driver who were disconnected or disqualified?

[RevengerXXL]

ods file as requested

[RevengerXXL]

BTW thanks for your help! How would I convert the time format to something that would work? I am fairly new to this and I have very basic knowledge of spreadsheets

[Zizi64]

Also when it is in the odf format it only returns a 0 as lowest time.

Because the 0 is the lowest time value in the table. You must use a helper column with conditional formulas =IF(...), what eliminate the 0 values (it substitutes the with empty strings).

[Zizi64]

How would I convert the time format to something that would work?

When the import filter is appeared at the opening the .csv file, you must adjust the filter properties. Just select the US English (or other locale setting) for the laptime columns - instead of the Standard option. Then the values will be imported as numeric values. The unit of the appeared numeric values are DAYS. You must format them or convert them into Minutes unit.

[Zizi64]

Adjusting of the Import filter

[RevengerXXL]

Okay Perfect! on the formating! Now to figure out if I need to nest a IF statement in the MIN statement or vice versa! I will get back to you with the results! Thanks again!

[RevengerXXL]

Thank you so much Zizi64! Your Amazing! Here is what I did to fix it! I was able to maintain the minute second format through the ods format. I also created a hidden column to with and if statement that gave a lap time of 59:59.59 to the no timed drivers then just used that column to use the MIN statement here is a copy for you to see it!!!