Date Time Picker custom format property ?

Hi,

I'm trying to use the Date Time Picker control as a time picker and only
want hours and minutes to show. Can this be done with its custom format
property (Example please if so)? The usual number formating string doesn't
seem to work and I'm having trouble finding guidance in the help system.

Thanks in advance.

Best Regards,
Walt Weber

Hi Walt

Strange

No help on this, I try it on a English and Dutch system.
I try to get a answer for you

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Walt" <xlsWalt@aol.com> wrote in message news:F4FF8186-72DF-4A6C-AFD5-9E502A330D9E@microsoft.com...
> Hi,
>
> I'm trying to use the Date Time Picker control as a time picker and only
> want hours and minutes to show. Can this be done with its custom format
> property (Example please if so)? The usual number formating string doesn't
> seem to work and I'm having trouble finding guidance in the help system.
>
> Thanks in advance.
>
> Best Regards,
> Walt Weber

Hi Ron,

Thanks for responding and for the consideration. I'll be watching for any
further posts on the subject.

Best Regards,
Walt Weber
xlswalt.dontspamplease@aol.com

"Ron de Bruin" wrote:

> Hi Walt
>
> Strange
>
> No help on this, I try it on a English and Dutch system.
> I try to get a answer for you
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Walt" <xlsWalt@aol.com> wrote in message news:F4FF8186-72DF-4A6C-AFD5-9E502A330D9E@microsoft.com...
> > Hi,
> >
> > I'm trying to use the Date Time Picker control as a time picker and only
> > want hours and minutes to show. Can this be done with its custom format
> > property (Example please if so)? The usual number formating string doesn't
> > seem to work and I'm having trouble finding guidance in the help system.
> >
> > Thanks in advance.
> >
> > Best Regards,
> > Walt Weber
>
>
>

You hear from me Walt

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Walt" <xlsWalt@aol.com> wrote in message news:6BB05597-3D14-4810-9CCD-A621ACE2E3CA@microsoft.com...
> Hi Ron,
>
> Thanks for responding and for the consideration. I'll be watching for any
> further posts on the subject.
>
> Best Regards,
> Walt Weber
> xlswalt.dontspamplease@aol.com
>
> "Ron de Bruin" wrote:
>
>> Hi Walt
>>
>> Strange
>>
>> No help on this, I try it on a English and Dutch system.
>> I try to get a answer for you
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Walt" <xlsWalt@aol.com> wrote in message news:F4FF8186-72DF-4A6C-AFD5-9E502A330D9E@microsoft.com...
>> > Hi,
>> >
>> > I'm trying to use the Date Time Picker control as a time picker and only
>> > want hours and minutes to show. Can this be done with its custom format
>> > property (Example please if so)? The usual number formating string doesn't
>> > seem to work and I'm having trouble finding guidance in the help system.
>> >
>> > Thanks in advance.
>> >
>> > Best Regards,
>> > Walt Weber
>>
>>
>>

Hi Walt

Set Custom to 3 - dtpCustom and CustomFormat to h:mm to display time
And Updown to True in the properties

More info on MSDN

http://msdn.microsoft.com/library/de...e/datetime.asp
and
http://msdn.microsoft.com/library/de...me/reflist.asp






--
Regards Ron de Bruin
http://www.rondebruin.nl



"Walt" <xlsWalt@aol.com> wrote in message news:6BB05597-3D14-4810-9CCD-A621ACE2E3CA@microsoft.com...
> Hi Ron,
>
> Thanks for responding and for the consideration. I'll be watching for any
> further posts on the subject.
>
> Best Regards,
> Walt Weber
> xlswalt.dontspamplease@aol.com
>
> "Ron de Bruin" wrote:
>
>> Hi Walt
>>
>> Strange
>>
>> No help on this, I try it on a English and Dutch system.
>> I try to get a answer for you
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Walt" <xlsWalt@aol.com> wrote in message news:F4FF8186-72DF-4A6C-AFD5-9E502A330D9E@microsoft.com...
>> > Hi,
>> >
>> > I'm trying to use the Date Time Picker control as a time picker and only
>> > want hours and minutes to show. Can this be done with its custom format
>> > property (Example please if so)? The usual number formating string doesn't
>> > seem to work and I'm having trouble finding guidance in the help system.
>> >
>> > Thanks in advance.
>> >
>> > Best Regards,
>> > Walt Weber
>>
>>
>>

Hi Ron,

It works perfectly. Thank you. It was especially good of you to
include the MSDN URL's since, in reading through those, I learned I
could use h:mm tt to have it also show the AM or PM.

Best Regards,
Walt Weber

Ron de Bruin wrote:
> Hi Walt
>
> Set Custom to 3 - dtpCustom and CustomFormat to h:mm to display time
> And Updown to True in the properties
>
> More info on MSDN
>
>
http://msdn.microsoft.com/library/de...e/datetime.asp
> and
>
http://msdn.microsoft.com/library/de...me/reflist.asp
>
>
>
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Walt" <xlsWalt@aol.com> wrote in message
news:6BB05597-3D14-4810-9CCD-A621ACE2E3CA@microsoft.com...
> > Hi Ron,
> >
> > Thanks for responding and for the consideration. I'll be watching
for any
> > further posts on the subject.
> >
> > Best Regards,
> > Walt Weber
> > xlswalt.dontspamplease@aol.com
> >
> > "Ron de Bruin" wrote:
> >
> >> Hi Walt
> >>
> >> Strange
> >>
> >> No help on this, I try it on a English and Dutch system.
> >> I try to get a answer for you
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >>
> >> "Walt" <xlsWalt@aol.com> wrote in message
news:F4FF8186-72DF-4A6C-AFD5-9E502A330D9E@microsoft.com...
> >> > Hi,
> >> >
> >> > I'm trying to use the Date Time Picker control as a time picker
and only
> >> > want hours and minutes to show. Can this be done with its
custom format
> >> > property (Example please if so)? The usual number formating
string doesn't
> >> > seem to work and I'm having trouble finding guidance in the help
system.
> >> >
> >> > Thanks in advance.
> >> >
> >> > Best Regards,
> >> > Walt Weber
> >>
> >>
> >>

If you are using the Excel MS Control in then it is quite simple. The Following code example will do this
if you have a user form(FrmDate) with the DTPicker Control (called 'Cal_Float' in the Example) on it!

FrmDate.Cal_Float.Value="10-Feb-14"


Try it,

Kurt