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