You can do that, format as hh:mm:ss.00, and enter such as

0:0:5.25

This adds up correctly, you can average it and so.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mrvw" wrote in message
...
I am a volunteer Track & Field coach for 13 years, and would like to use
Excel to keep my team's satistics. But am unable to enter time as
minutes,
seconds, tenth of seconds, or hundreth of seconds. Probably because I
don't
know how to do it without converting minutes to seconds. Sure would be
nice
to be able to enter exact times and query for totals and averages.
Hopefully
the newer version of Excel/Office will have this capability, and that I
can
afford it. I would rather use Office then have to purchase a seperate
program called "Team Manager"

----------------
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