Give the cell a custom format:
Format|cells|Number format|custom category
mm:ss.000
or
[mm]:ss.000 if you need to sum them.

But enter your values as real times (include the hour, minute, second, and
hundredths.

00:12:05.001
(for 12 minutes, 5 seconds plus a little bit.)

teetime wrote:

I am trying to record times for swimming in the format of minute, seconds,
hundreths of a second mm:ss.hhh -- is there a format for this available? I
also need to do functions - add, subtract, max, min, etc. Is there an easy
way to do this without writing macros?

--

Dave Peterson