See Chip Pearson's site for code and instructions on entering dates and times
without separators.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP

On 21 Oct 2006 18:53:41 -0700, "jk" wrote:

I direct a one-hour race walk event on a track and want to enter lap
times each athlete into an Excel spreadsheet. The times are in minutes
and second (MM:SS) and each athlete can complete as many 35 laps. I
calculate and display the cumulative and elapsed time for each lap.

Currently, I enter each time as 0:MM:SS. So, 54 minutes and 32 seconds
would be entered as 0:54:32. I'm not a very good typist and the extra
typing seems unnecessary. I would like to enter the time as 5432 and
have Excel convert my entry to the time format.

I'm a novice with Excel. What is the best way to use Excel to speed up
the data entry process?

Thank you. -- Justin