Avoid user having to enter hours when using [mm]:ss format
I am formatting a spreadsheet to enter sports-score from a particular event.
I format cells to display mm:ss using "custom" format [mm]:ss. However the
user, it appears, has to enter 00 for hh to get the display correct. How can
I avoid this?
|