I'm not 100% sure what you mean, but this is what I think could be the
problem.

If you format a cell mm:ss it is only the display of the data that is
mm:ss, not the data itself. The data is stored in date format
(something like 38888.32432532434). You can't just enter minutes and
seconds and ignore the date and hours.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553495