Formula for calculating fastest time in row for Google Sheets

B

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.
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

S
  • Question
Seeking Help with Complex Date-Time Calculations in Google Sheets
Replies
0
Views
254
shlomek12
S
T
  • Question
Golf Simulator League - Calculating Golf Handicaps for Google Sheets
2
Replies
12
Views
2K
Fluff
Fluff
A
  • Question
Importhtml on google sheet converted data to a different format
Replies
4
Views
435
Fluff
Fluff
A
  • Locked
  • Question
Importhtml() on google sheet converted data to a different format
Replies
1
Views
292
Fluff
Fluff
M
  • Question
google sheets time/date stamp query
Replies
0
Views
136
Mattlake
M

Forum statistics

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

Share this page

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