View Single Post
  #1   Report Post  
LCpl Shaw
 
Posts: n/a
Default Multiple Formulas

Im creating a database for my school house and before i convert over to
Access..Im trying to figure out some ways to calculate some numbers. For
example, my hardest thing yet, if someone was to run an 18min:00sec 3mile
run...he'll get a max score of 100. But if he ran it in 20min:34sec he'll get
a score of 84. Being the longest run of 28min:00sec (failing). How do i
create a formula to calculate the mins and sec to result in the point score.