Thread
:
Excel should format time down to the hundredth/sec.
View Single Post
#
2
Posted to microsoft.public.excel.misc
Peo Sjoblom
Posts: n/a
Excel should format time down to the hundredth/sec.
How would excel know how to do that compared if you meant to type in the
number 153268 since formatting never changes the underlying value
just the display, for people that find it too hard to type in colons there
are VBA solutions like in here
http://www.cpearson.com/excel/DateTimeEntry.htm
--
Regards,
Peo Sjoblom
"John Krick" <John
wrote in message
...
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
Reply With Quote