Hi again,
and thank you Frank for pointing out that excellent site. I do however not
feel comfortable with diving into VBA at this point.
I tried [hh]:mm as suggested to my "other" post (and sorry for the duplicate
BTW), and simplified the evaluation somewhat and this now works. However
users will be very uncomfortable seeing the date 1900.01.01 appear in front
ef every time recorded past the 24 "minute" mark in the entry line above the
sheet itself.
Can I format the time field as text and have excel split the contents aroud
the ":" character (e.g. 17:12 = 17*60+12= ) and evaluate this.
(sorry for the opaque nature of this post, if you look 7 threads down from
this one that twin thread may shed some light).

Cheers
LL



"Frank Kabel" wrote:

Hi
as a starting point:
http://www.cpearson.com/excel/DateTimeEntry.htm

--
Regards
Frank Kabel
Frankfurt, Germany
"Lady_luck" schrieb im Newsbeitrag
...
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?