Try formatting as Custom Type: [mm]:ss
(with square brackets [ ] around the minutes part: mm)
This'll allow rollover of minutes
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"bob" wrote in message
...
I want to enter a date as if I were denoting the minutes and seconds left
in
a sporting event, i.e., 4:10 to represent 4 minutes and 10 seconds. I do
NOT
want an hour to be applied to the time (ex: 3:04:10). I do not see a way
to
do this with Excel time formatting options. Each one uses an
hour/minute/second format.

Help anyone?