I want to enter a date as if I were denoting the minutes and seconds left in
a sporting event, i.e., 4:10 to represent 4 minutes and 10 seconds. I do NOT
want an hour to be applied to the time (ex: 3:04:10). I do not see a way to
do this with Excel time formatting options. Each one uses an
hour/minute/second format.

Help anyone?