# Formula to show a personal best!

#### ctomblin

##### New Member
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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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
...

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

For a Personal best you might want to use a
MIN function not MAX

Sorry 'n all

DaveA

For a Personal best you might want to use a
MIN function not MAX

Sorry 'n all

DaveA

For a Personal best you might want to use a
MIN function not MAX

Sorry 'n all

DaveA

OOOpps

Well I now know that a time out doesn't mean it hasn't posted!!

Sorry All.

DaveA

=(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.

=(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.

This message was edited by Dave Patton on 2002-08-28 10:56

Thanks guys - done it !!

Replies
4
Views
179
Replies
2
Views
208
Replies
5
Views
463
Replies
0
Views
355
Replies
13
Views
528

1,219,578
Messages
6,149,095
Members
450,859
Latest member
njaitley

### 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.

### Which adblocker are you using?

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

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