Formula to show a personal best!

ctomblin

New Member
Joined
Apr 25, 2002
Messages
49
I am a racing cyclist and I keep a record of my race performances over standard distances. I record my times in 2 columns, minutes in one and seconds in the other. I would like a formula that marks the shortest time with PB. So, from times like 22.54, 22.31 and 22.12 the 22.12 would have PB next to it. Thanks
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
I think you have to make another column for total time, then try this:
Book2
ABCD
1MinutesSecondsTotal Time
2223022.50 
3201520.25 
4241024.17PB
5211821.30 
...


And yes, absolutely right about Min() instead of max()

Brain fart...sorry

HTH,
Corticus
This message was edited by Corticus on 2002-08-28 07:37
This message was edited by Corticus on 2002-08-28 08:08
 
Upvote 0
In an adjacent column enter

=(A2&"."&B2)*1

In a cell such as D1 =MIN(C2:C6)

put a formula like in an adjacent column and
copy it down
=IF(C2=$D$1,"Best time","")


Adjust ranges as necessary. Note D1 is absolute.

For amount it should not matter whether you use time seconds or decimal part of minutes.

I cannot seem to post this; your question may be answered already.
 
Upvote 0
In an adjacent column enter

=(A2&"."&B2)*1

In a cell such as D1 =MIN(C2:C6)

put a formula like the following in an adjacent column and copy it down
=IF(C2=$D$1,"Best time","")


Adjust ranges as necessary. Note D1 is absolute.

For amount it should not matter whether you use time seconds or decimal part of minutes.

I cannot seem to post this; your question may be answered already.
This message was edited by Dave Patton on 2002-08-28 10:56
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

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