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.