In the format cells, go to Custom, choose mm:ss.0 (at least that is what I
do). I can do all necessary calculations that I have tried.
Another option would be to set up the left most cell as minutes and the cell
to the right of it as seconds.
<[email hidden]> wrote in message
news:[email hidden]...
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
Quoted message said: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,
Quoted message said: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.