Time and Date Selector

[trevolly]

Hi all.

Is there any way to have a time selector and a date selector in a cell in Excel without using add ins? My company won’t allow add ins to the system.

I’ve got a form where an engineer has to select a date and time for a high powered engine run to commence and for some reason they seem to struggle to enter the data correctly. I’ve done a data validation list for dates but times is an issue as it could be a request for any minute of the day. 00:00, 00:01, 00:02 etc.

I was hoping that if you clicked on the cell it would offer a select the time or date system

Thank you all.

 

[awoohaw]

The date time picker is available in 365, but probably only in the 32bit version.

Yes, that is discussed in the microsoft article I link to in post #5. But, the article that I have the image of in post #7 is more recent, but it doesn't discuss what ##-bit version is discussed.

 

[trevolly]

Thank you. Seems I have the same issue as others - it’s not listed, but thank you for the time and reply.

 

[awoohaw]

Thank you. Seems I have the same issue as others - it’s not listed, but thank you for the time and reply.

Best wishes.

 

[My Aswer Is This]

I'm using Excel 2021 Office and Student
And I have no option for a Time and Date Selector

 

[awoohaw]

I'm using Excel 2021 Office and Student
And I have no option for a Time and Date Selector

Look at the link in Post #5 and the page described in the image in Post #7. There is an add in you should be able to install.

 

[mumps]

I had a little time on my hands and I was a little frustrated by the lack of a time picker so I designed one myself. You can download the file by clicking here . There is a Worksheet_SelectionChange macro in the code module for Sheet1 which you can modify to suit your needs. Just click on any cell in column A. Any feedback is welcome. You can copy the userform into any file where you may need it.