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