enter your time, a2 "06:18.92", it will show "6:18.9" Now format your
cell, it should allready be "time: 30:55.7" in the left hand column,
choose custom, it now should show "mm.ss.0" in the text column add one
more "0" it should look like "mm.ss.00" Then you can do the sub
formulas as normal and get the right answers.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472787