the format should be [mm]:ss

if you entere 30:24, that is 30 hours 24 minutes. to enter 30 minutes and
24 seconds you must enter

0:30:34 or 00:30:24

Look at Data=Validation if you want to restrict entry. the is a Time
option with parameters you can specify.

--
Regards,
Tom Ogilvy


"G Henry" wrote:

I need to format a column to show only minutes and seconds in the 31:12
format. It must force the data to conform so the interns will not screw up
the table. I have tried all the options with none working. The format [h]:mm
works but the formula bar shows
1/1/1900 6:24:00 AM for the time 30:24
Please help.