Time format

[Guest]

I have used Chips DateTimeEntry but i would like to have time format as
shorttime, ie "hh:mm" instead of "hh:mm:ss AM/PM".

How do I get there?

Tahnk in advance

 

[Dave Peterson]

Chip's routine (on http://www.cpearson.com/excel/DateTimeEntry.htm) doesn't set
the format.

You can set it manually (via Format|cells|number tab) or add it to the code:

Right after this line:
.Value = TimeValue(TimeStr)
add this
.NumberFormat = "hh:mm"