Excel should let me enter time in one hundreds of a second.

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
Jon Quixley <[email protected]>
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