Is there an Excel format foro time to hundreths of a second

[Guest]

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]

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.)

 

[Peo Sjoblom]

hh:mm:ss.00

--
Regards,

Peo Sjoblom

(No private emails please)