+ Reply to Thread
Results 1 to 3 of 3

MS Date and Time Picker Control 6.0 (SP4)

  1. #1
    Registered User
    Join Date
    06-27-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2007
    Posts
    49

    Question MS Date and Time Picker Control 6.0 (SP4)

    Hi

    I have two questions regarding this Picker!

    First how i can change that the time h value is 0-24 instead of 0-12?

    Second is it possible that while pick up the date you can set also the time?
    It will show only the calendar not clock!

    Thanks in advance!
    Last edited by Reemet; 02-12-2014 at 04:44 AM.

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: MS Date and Time Picker Control 6.0 (SP4)

    Default time format should be 24 hour. It is not possible to choose date and time at once.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    06-27-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: MS Date and Time Picker Control 6.0 (SP4)

    Yes it is!

    I finally solved it by my self!

    I used coustom format as "dd.MM.yyyy HH:mm" Gives 10.02.2014 16:10
    I t is "dd.MM.yyyy hh:mm" then it gives 10.02.2014 04:10

    Best regards!
    Last edited by Reemet; 02-10-2014 at 02:46 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Monthview/Date time picker control? Help
    By jsabo in forum Excel General
    Replies: 0
    Last Post: 08-25-2013, 05:48 PM
  2. Date and Time Picker Control 6.0 (SP6)
    By jj554 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2013, 08:47 PM
  3. date and time picker control
    By Ashku in forum Excel General
    Replies: 0
    Last Post: 07-22-2006, 06:25 AM
  4. [SOLVED] [SOLVED] date time picker control
    By MacroCharlie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2005, 12:10 PM
  5. [SOLVED] Date and Time Picker Control
    By Andy T in forum Excel General
    Replies: 0
    Last Post: 01-06-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1