It is always better to use hours as well even if you don't enter any

hh:mm:ss.00

then enter 2 minutes 30 seconds and 2 10ths of a second like

00:02:30.2

works for me


--

Regards,

Peo Sjoblom






"John Boulton" <John wrote in message
...
I would like to be able to format columns/cells to read time inthe format
m:ss.00 or alternatively m:ss:00 (for determining beaten margins of
racehorses the finishing times are given in the above formats but excel
doesn't appear to want to mix or match them
any assistance would be appreciated
JB