Formatting Excel Entry Times

When entering a meet using the spreadsheet entry format, the format of the entry time is critical because Excel stores numbers internally in different formats depending on the cell formatting.

We recommend that the cell is formatted as Text prior to entering any information.

Times should be formatted as:

• Either mm.ss.hh
• or ss.hh
• or ss.t

Where:

• mm = minutes,
• ss = seconds and
• hh = hundredths
• t = tenths (the system will assume that any times have 0 for the hundredths)

The system will accept other formats, but this is the recommended approach.