I have formatted a column of cells to collect elapsed times using the custom
format mm:ss. I plan to keep a running total of the elapsed times in another
column.

When I type in elapsed time data of 30 minutes and 15 seconds (30:15), it
converts it to 15:00, short for 1/1/1900 6:15:00 AM.

What am I doing wrong?

Thanks