This is my time scale and the grade that is represented in each range.

DC Time Scale
59:00-60:00 70
58:00-58:59 72
57:00-57:59 74
56:00-56:59 76
55:00-55:59 78
54:00-54:59 80
53:00-53:59 82
52:00-52:59 84
51:00-51:59 86
50:00-50:59 88
49:00-49:59 90
48:00-48:59 92
47:00-47:59 94
46:00-46:59 96
45:00-45:59 98
44:00-44:59 100


"T. Valko" wrote:

How many time groups are there? Tell us what all the groups are.

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
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?