0:3:55 or 3:55.0
--
David Biddulph

"GTifeld" wrote in message
...
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.