Question School teacher looking for formula

[greearnl]

NEED FORMULA TO CONVERT TIME TO A SCORE (GRADE)
EXAMPLE:
RUN TIME OF 12.00 = 100 POINTS
12.01 = 99 POINTS
12.02 = 98 POINTS etc..............

CAN ANYONE HELP ME OUT ???

 

[Steve R.]

100/12*Run_Time= Point_Score OR 25/3*Run_Time= Point_Score

 

[Poppa Smurf]

Steve
Check your formula I do not get 99, 98, 97 etc. I get between 99.9 to 99.5

greearn
Try this
Points= (1 - (Run Time - Reference time)) * 100
Run Time is the actual time taken, Reference time is the run time required for 100 points

Using 12.01
Points =(1 - (12.01- 12.00)) * 100 gives 99

12.02
Points =(1 - (12.02- 12.00)) * 100 gives 98

13.00 gives 90
etc

 

[Steve R.]

Steve
Check your formula I do not get 99, 98, 97 etc. I get between 99.9 to 99.5

OOPs, I missed the "fine" print. I overlooked the fact that the number was moving up rather than down. I guess I need to think a bit more before responding.