Time Format

[PTB]

How can I format cells to contain Minutes, Seconds and Hundredths of seconds to be used in calculations eg 1.24.99 means 1 minute and 24.99 seconds.

Example calculation is:
1.24.99 - 1.24.90 =0.0.09

Thanks
PTB

[teylyn]

try custom format

h:mm:ss.00

[PTB]

Thank you teylyn.

I had tried that before but was using a full stop instead of a colon between the numbers.

This works perfectly.

Peter