Formula for calculating fastest time in row for Google Sheets

BBTMeek

New Member
Joined
Jun 19, 2023
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I have a file for a swimmers times over a few years, I'm trying to use the MIN function to locate the fastest time in a row range - I cannot get it to work for me. At first I thought it was taking into account the blank cells and when I try the formula with just the cells with values it still comes back 0. I've played around with the formatting of the cells between number and a custom format of mm:ss.000 but still coming back 00:00:00

I've copied the data here: Minimum Time Calculation

In cell A5 I am trying to calculate the fast times in cells D5:N5

I've been through a lot of forum results and have tried all the solutions available but coming up empty. Any help would be appreciated.

TIA
 

Attachments

  • MIN Time.png
    MIN Time.png
    64.5 KB · Views: 42
Last edited by a moderator:

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Those "times" are text & not numbers hence you get 0, try
Excel Formula:
=MIN(FILTER(--D5:N5,D5:N5<>""))
 
Upvote 0
Thank you for the above, tried that unfortunately I am getting a #VALUE error:
 

Attachments

  • VALUE error.png
    VALUE error.png
    11.4 KB · Views: 20
Upvote 0
In future when asking questions about Google Sheets you need to post it in the General Discussion & Other Applications section of the board & clearly state what app you are using.
I have done that for you this time.

I do not know enough about sheets to help any further.
 
Upvote 0

Forum statistics

Threads
1,216,503
Messages
6,131,020
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top