You can format the cell(s) as mm:ss. I believe you'll still have to enter
0:45 to get 45 seconds. You won't need to enter 0:00:45.

Come back if you have more questions.

Barb Reinhardt

"burrowsybobs" wrote:


Can anyone please help before I go completely mad.

I am trying to enter minutes and seconds into a spreadsheet but even
though the cell is formatted as m:ss it still requires the user to type
in 0:01:10 for one minute ten seconds and I want to just type 1:10 for
one minute ten seconds, or just 45 for 45 seconds.

Please help.

Thanks.


--
burrowsybobs
------------------------------------------------------------------------
burrowsybobs's Profile: http://www.excelforum.com/member.php...o&userid=24327
View this thread: http://www.excelforum.com/showthread...hreadid=379298