time measures and vlookup
Posted by brian o'farrell on December 14, 2000 2:34 PM
I am developing a spreadsheet for an athletics club that enables them to easily determine the points relevant to a particular performance. The times are measured to 100ths of a second and may involve minutes (or even hours for the adult events). I have arranged the data in two columns - TIMES and POINTS - and proposed to use a vlookup based upon TIME. The times are entered as mm:ss.ss format e.g. 2:40.35. Is there an easy way to achieve this without converting the data to seconds for the lookup?