Entering/Formatting Time in Cells
Hi,
I'm trying to enter numbers as running times. For example, when I enter
3:55, I want it recognized as 3 min. & 55 secs.; Not 3:55 a.m. It should be
simple, but I can't seem to find the right format function. Can anyone tell
me what I'm missing? I don't want to enter it as straight text, because I'll
need to use it later in time calcs.
Thanks in advance.
|