Quoted message said:
Hi,I'd like to be able to quickly enter split times in Excel using just the
numeric keypad. Ideally, i''d like to set it up so that the last two
digits are seconds, and any preceding digits would be minutes (i.e., all
split times less than an hour).I assume there is some way to "format" cells, or apply a mask to cells so
that entered data would be interpreted like this....I will want, of
course, to be able to perform arithmetic operations on the cells....Please help! Just setting a "mm:ss" format didn't work at all!
Lisa B.
Not sure if this will help, but...
I don't use excel, I use a proper database to store my data and then extract
it with SQL and format it using Perl just the way I want it. I store
time/splits/pace in seconds - and then format it for display purposes. So
4:23 would be stored as 263. Then when you want to do any calculations it
can be done with standard math and then formatted into mm:ss for your own
needs.
I don't know if you can do something like this in excel as I haven't had the
misfortune to use it for a few years, but it is very basic stuff so I'm
sure it can do something similar.
--
Brian Wakem