Comp winner based on Time and penalty points

%3CLINGO-SUB%20id%3D%22lingo-sub-2784782%22%20slang%3D%22en-US%22%3EComp%20winner%20based%20on%20Time%20and%20penalty%20points%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2784782%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Afternoon%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20someone%20can%20help%2C%20I%20am%20looking%20to%20create%20a%20table%20so%20that%20we%20can%20input%20competitors%20they%20will%20run%20a%20show%20jump%20course%20then%20a%20cross%20country%20course%20for%20time%20but%20if%20they%20hit%20any%20obstacles%20in%20the%20show%20jump%20course%20then%20they%20are%20given%20a%20penalty%20point%20and%20if%20they%20stop%20at%20a%20jump%20in%20cross%20country%20a%2010%20seconds%20is%20added%20to%20their%20total%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethere%20will%20be%20an%20Optimum%20time%20of%20the%20run%20and%20then%20their%20run%20will%20be%20compared%20to%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebasically%2C%20we%20have%20a%20horse%20course%20that%20people%20run%20over%20a%20jump%20course%20first%20(Show%20Jumps)%20and%20every%20pole%20they%20knock%20down%20that%20is%20classed%20as%20a%20fault%20(1%20Point)%20%2C%20then%20they%20run%20into%20a%20cross%20country%20course%20where%20they%20are%20then%20timed%2C%20but%20if%20there%20horse%20stops%20at%20a%20jump%20then%20that%20is%20a%20time%20penalty%20(10%20seconds)%20added%20to%20their%20finish%20time.%20the%20time%20must%20show%20(Minutes.Seconds%20and%20Milliseconds)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efinally%2C%20%26nbsp%3BI%20would%20like%20it%20to%20rank%20the%20best%20riders%20with%20the%20lower%20time%20over%20the%20optimum%20time%20and%20the%20least%20penalty%20points%20in%20the%20show%20jumping.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2784782%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2811566%22%20slang%3D%22en-US%22%3ERe%3A%20Comp%20winner%20based%20on%20Time%20and%20penalty%20points%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2811566%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1166417%22%20target%3D%22_blank%22%3E%40Martin406%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20the%20worksheet%20ready%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Good Afternoon all,

 

hope someone can help, I am looking to create a table so that we can input competitors they will run a show jump course then a cross country course for time but if they hit any obstacles in the show jump course then they are given a penalty point and if they stop at a jump in cross country a 10 seconds is added to their total time.

 

there will be an Optimum time of the run and then their run will be compared to that.

 

basically, we have a horse course that people run over a jump course first (Show Jumps) and every pole they knock down that is classed as a fault (1 Point) , then they run into a cross country course where they are then timed, but if there horse stops at a jump then that is a time penalty (10 seconds) added to their finish time. the time must show (Minutes.Seconds and Milliseconds)

 

finally,  I would like it to rank the best riders with the lower time over the optimum time and the least penalty points in the show jumping.

1 Reply

@Martin406 

 

Do you have the worksheet ready?