Use mm.sec.100ths format with formula

[RichM]

Hi, I 'm trying to create lap times record sheet with averages etc, but
cannot get Excel to recognise this format:
mm:secs.1ooths of a sec.
Ie John Smith Lap time 1:17.25

Well, I can type it in as general text, but then I cannot use formula
to autosum, etc.
Any ideas?
Thankyou
RM

 

[Paul]

Hi, I 'm trying to create lap times record sheet with averages etc, but
cannot get Excel to recognise this format:
mm:secs.1ooths of a sec.
Ie John Smith Lap time 1:17.25

Well, I can type it in as general text, but then I cannot use formula
to autosum, etc.
Any ideas?
Thankyou
RM

Format the cell as mm:ss.00

 

[Peo Sjoblom]

Try to enter it as

0:1:17.25

and use a custom format like

mm:ss.00

works for me