i forgot to mention the first column of the table must remain sorted ascending

"Mike H" wrote:

Steve,

Somewhere out of the way build yourself a table like the one below with time
thresholds and points. Note that ive include an impossible time of zero
because you need that but you can put realistic thresholds in, use the formula

=VLOOKUP(A1,G1:H8,2,TRUE)

Where G1 - H8 refers to the table

00:00 150
14:00 120
14:10 100
14:20 80
14:30 60
15:30 40
16:30 20
17:30 0

Mike


"Steve" wrote:

I have a range of times for a 2 mile run and a and a score for each time
group but do not know how i can include this in excel. For example if a
runner finishes his run in 14 min 10 sec (14:10) and my scale is from 14:00
to 14:30 is a 90 how do I go about doing this?