Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Time Picker custom format property ?
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Time Picker custom format property ?
Hi Ron,
Thanks for responding and for the consideration. I'll be watching for any further posts on the subject. Best Regards, Walt Weber "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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Time Picker custom format property ?
You hear from me Walt
-- Regards Ron de Bruin http://www.rondebruin.nl "Walt" wrote in message ... Hi Ron, Thanks for responding and for the consideration. I'll be watching for any further posts on the subject. Best Regards, Walt Weber "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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Time Picker custom format property ?
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" wrote in message ... Hi Ron, Thanks for responding and for the consideration. I'll be watching for any further posts on the subject. Best Regards, Walt Weber "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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Length of time from date/time custom format | Excel Discussion (Misc queries) | |||
pop up Date time picker | Excel Discussion (Misc queries) | |||
Custom Date & Time format | Excel Worksheet Functions | |||
Date/Time Picker | Excel Programming | |||
date time picker | Excel Programming |