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

Did you try formatting the cell as follows:

mm:ss.000

This should give you a cell that will read 15:25.254 as in 15 minutes,
25 seconds and 254 hundreths

Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=400715

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

That would be 254 thousandths...

In article ,
Jon Quixley
wrote:

Did you try formatting the cell as follows:

mm:ss.000

This should give you a cell that will read 15:25.254 as in 15 minutes,
25 seconds and 254 hundreths