New user needs help with a project

[eyeseeh39]

Hi everyone,

Im new to using excel but am interested in using it to help with my motorsport club activities.

I compile the results from our autocross events and would like to automate the calculation of the results.

Is it possible to get excel to work out the two fastest times from a list of three or four times and combine them to give a total time?

From these times is it possible to give an overall position, ie fastest time to slowest time?

These times will be in the format of minutes, seconds and tenths of seconds, can excel handle this?

I hope someone can answer these questions or atleast point me in the right direction to try and work them out for myself.

Cheers

Iain

[Maistrye]

I've attached a sample doing this.

The two key cells you should look at are:

Getting the total time for the fastest two races (if the person has raced twice)
F3: =IF(COUNTA(B3:E3)<2,"",SMALL(B3:E3,1)+SMALL(B3:E3,2))

Getting the rank of the person. (Returns blank for people who don't have enough races)
G3: =IF(F3<>"",RANK(F3,$F$3:$F$8,TRUE),"")

Also, you may find it necessary to set up a custom format if you want values to the hundredths of a second, as the defaults in the Time listing only go to the tenths of a second.

If you would like something explained, we'll try.

Scott

[eyeseeh39]

Hi Scott

Thanks very much for the quick reply and the attached file.

That was just what I needed

Merry Christmas to you!

Cheers

Iain

[VBA Noob]

Slightly shorter

=IF(COUNTA(B3:E3)<2,"",SUM(SMALL(B3:E3,{1,2})))

VBA Noob