PDA

View Full Version : [SOLVED] Inserting Time in a cell



austenr
07-01-2005, 08:07 AM
I know that there is a pop up calendar, but is there a way for a user to pick a time to enter similar to the pop up calendar? Thanks :hi:

MOS MASTER
07-01-2005, 10:38 AM
Hi, :yes

Well yes there is. You talk about a calendar control. There are several but some of them you can use as a time picker.

DTPicker is one of them. (Microsoft Date & Time Picker control 6.0 (SP 4))
The Ocx that you need on your machine is: mscomctl2.ocx

You can set the custom properties so only time is shown.
You just select that bit of time you wish to change and use the toggle button to change it.

Included a simple sample for you. :whistle:

sheeeng
07-03-2005, 08:14 AM
Just in case you want to enter static data/time stamp without calender control...

If you want to enter a static date stamp on a cell, press Ctrl + ;
If you want to enter a static time stamp on a cell, press Ctrl + Shift + ;

HTH.

MOS MASTER
07-03-2005, 08:26 AM
Austen,

Did it work out with the DTPicker? :yes

sheeeng
07-03-2005, 08:29 AM
Austen,

Did it work out with the DTPicker? :yes

I tried it, Joost.
Nice code. :thumb

MOS MASTER
07-03-2005, 08:31 AM
I tried it, Joost.
Nice code. :thumb
Glad you liked it..let's hope it solves Austens query. :yes

austenr
07-03-2005, 10:44 AM
Yes that is what I needed. Great!! Thanks

MOS MASTER
07-03-2005, 10:53 AM
Yes that is what I needed. Great!! Thanks
You're welcome! :beerchug: (don't forget to mark the thread)

sheeeng
07-03-2005, 07:00 PM
Yes that is what I needed. Great!! Thanks

Hi austenr,
Please mark your thread solved by clicking Solved by hitting the Thread Tools dropdown at the top of the thread. (If you happy with all the help given) :thumb

Cyberdude
07-04-2005, 12:39 PM
Just in case you want to enter static data/time stamp without calender control...

If you want to enter a static date stamp on a cell, press Ctrl + ;
If you want to enter a static time stamp on a cell, press Ctrl + Shift + ;

HTH.

Hey, Sheeeng, maybe you typed something other than the plus sign, but on my computer I have to use the colon, not the "+" to get the date and/or time.

sheeeng
07-04-2005, 06:20 PM
Hey, Sheeeng, maybe you typed something other than the plus sign, but on my computer I have to use the colon, not the "+" to get the date and/or time.

Sorry, What I mean is the "+" meaning "press together".
Sorry for the misleading suggestions. :doh:

Cyberdude
07-05-2005, 12:08 PM
No problem, sheeeng, I was pretty sure you didn't mean the "+", but you never know. Have a nice day!

sheeeng
07-05-2005, 06:56 PM
No problem, sheeeng, I was pretty sure you didn't mean the "+", but you never know. Have a nice day!

Thank you for clarify everything....:friends:
If not, I'll be misleading the readers of this thread....:eek: