If you format your cell with Format/Cell/Number/Custom

mm:ss.00

you can display 15:32.68, and you can always use that value to add and
subtract. It won't necessarily show up that way in the formula bar, but
it will in the cell.



In article ,
"John Krick" <John wrote:

I would like to be able to format the cells within Excel so that if I typed
in my athlete's time from a race as 153268 or 3245, it would show up in the
cell as 15:32.68 or :32.45 respectively. I would also like to be able to
then add or subtract time in that same format. Right now I can only format
the cell to display those times as 15:32.6 or 00:00.0 (nothing at all). I do
race time analysis with excel but I have to convert the time into all seconds
if I want to add/subtract/divide or whatever. Can you add a format that
would recognize time not in the sense of how a clock on the wall is read but
how a stop watch is recognized?

I'm currently using the MIcrosoft Office Excel 2003 version.