DateTime picker is not include hours

[abdi1]

hi
am trying to use DateTime picker in excel 2007 but it's only show mm/dd/yyyy......without hours 00:00
how can we add hours to DateTime picker ? if it's possible

p.s: i dont know if this is the right section to post my thread or i should post it in VB section ...
sorry

[mikeava]

Hi - can you please attach your file so we can take a look? See yellow banner on top on how to include it.

[abdi1]

Hi - can you please attach your file so we can take a look? See yellow banner on top on how to include it.

hi and thanks....i tray to use the (Microsoft date and time picker control) in excel for quick and easy inserting of date and time in the sheet...but i discovered that this control contain only mm/dd/yyyy variables without hh:mm although this control is called(date and time picker )but it's not include hourly time ....my question is that (can we format this control to show or add HH:MM to it? its a known control for many...and i think no need to attach an excel sheet.....
thanks

[MarvinP]

Hi abdi1,

It looks like you need to set the ShowUpDown property as explained on this site, and set the format correctly.
https://docs.microsoft.com/en-us/dot...r?view=net-5.0

[abdi1]

MarvinP thanks for you.......but it seem that the link above is talking about C# programming language.....i dont know how to deal with this language
was looking for the answer in excel
thanks

[abdi1]

Hi - can you please attach your file so we can take a look? See yellow banner on top on how to include it.

a picture worth a 1000 word.s...

[torachan]

a workbook is worth a thousand pictures and would probably get you an instant answer without wasting time.
torachan.

[MarvinP]

Hi,

If you click on the object and look at the properties window of that control, you should see that you can set it. If not in the control then look at the object browser to see if the correct word is displayed for you to set using VBA.
I don't have that control to test it, for a better answer.

[MarvinP]

Instead of using the DTPicker that is now dead, see if you can use the attached example that I've collected from years on this site.
Self-contained calendar control.xlsm

[abdi1]

Instead of using the DTPicker that is now dead, see if you can use the attached example that I've collected from years on this site.
Attachment 733762

MarvinP thanks for your help.....i will tray to use your file to fit with my requirements in my sheet
thanks for you ....appreciate

[abdi1]

hi
i think i found the solution using the Date and time picker it self
after adding the Date and time picker control as usual
and before click on Design mode to activate the control and use it
we need to right click on it(i mean the date and time control which is on the excel sheet )
and choose DTpicker object ,,,, then choose properties and from the pop up windows go to format option and choose 3-dtpCustom....then check the UpDown box near it ....then on the last choice (CustomFormat ) we can iserte the date time format that we prefer like( m/dd/yyyy hh:mm)
and click ok....and that it's all

[abdi1]

a workbook is worth a thousand pictures and would probably get you an instant answer without wasting time.
torachan.

sorry ....i didnt notice your reply.until today morrning ..thanks very much next times i will insert a workbook but i thought my request is easy to be solved without the need of a workbook
big thanks and the problem SOLVED

[torachan]

Here is another approach.
It will follow the table, you must have an entry in the first column, double click the second column.
Click in the hours or mins to set then choose date.