Use mm.sec.100ths format with formula

R

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
 
P

Paul

RichM said:
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
Click to expand...

Format the cell as mm:ss.00
 
P

Peo Sjoblom

Try to enter it as

0:1:17.25

and use a custom format like

mm:ss.00

works for me
 
Top