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?

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?

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?

Hi
you can't do much against the formula bar appearance of such time entries
and personally I won't split the time information in separate cells (makes
your calculations much more complicated).

You could hide the formula bar if you want though ('Tools - Options - View')

--
Regards
Frank Kabel
Frankfurt, Germany

Lady_luck wrote:
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?