outsider2832
Thread Starter
- Joined
- Oct 28, 2007
- Messages
- 9
Hi,
I use Excel at my sailing club to record the times for the sailed laps.
Some boats are faster than others, maximum number of laps are 6.
I need to write a formula or macro (never made a macro before!) that will provide the time for boats that have done all six laps, only three, or four or five.
My spread sheet has a total time column in sceonds, calculated for the six individual time columns recording the time for each boat.
Currently I have to "adjust" the total column by hand by specifing the column with the last time in it.
I would like to be able to write something that will give the following result:
If (f6<g6 then g6) If (g6<h6 then h6) If (h6<i6 then i6) If (i6<j6 then j6) If (j6<k6 then k6)
Column f6 is first lap time, column g6 is second lap time, column h6 is third lap time etc.
If a boat only completes three laps the remaing three laps will be shown as 0:00:00 time.
Total column is written in seconds for handicap calculations.
Any help gratefully received
Outsider2832
I use Excel at my sailing club to record the times for the sailed laps.
Some boats are faster than others, maximum number of laps are 6.
I need to write a formula or macro (never made a macro before!) that will provide the time for boats that have done all six laps, only three, or four or five.
My spread sheet has a total time column in sceonds, calculated for the six individual time columns recording the time for each boat.
Currently I have to "adjust" the total column by hand by specifing the column with the last time in it.
I would like to be able to write something that will give the following result:
If (f6<g6 then g6) If (g6<h6 then h6) If (h6<i6 then i6) If (i6<j6 then j6) If (j6<k6 then k6)
Column f6 is first lap time, column g6 is second lap time, column h6 is third lap time etc.
If a boat only completes three laps the remaing three laps will be shown as 0:00:00 time.
Total column is written in seconds for handicap calculations.
Any help gratefully received
Outsider2832