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.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc