Time Picker

**TheBOSS** · 11-25-2009, 04:20 AM

Good morning all.

I am busy on a spreadsheet with drop-down lists, conditional formatting etc.
I have inserted the 'Microsoft Date and Time Picker' to select the date, ie you click on the down arrow, and a calendar pops up. This generally works great, except if the spreadsheet is saved on a sheet with the date picker on it... But that's another topic all together.

I want to insert/create/use a 'Time Picker', basically the same concept as with the 'date picker' but to select a time ie 10:19 AM.

Can anyone offer any advise, or a solution?

**Richard Buttrey** · 11-25-2009, 08:23 PM

Hi,

How about a couple of drop down boxes with the numbers 1-24 in 1 and 1-60 in the other, then use the selections to create a decimal time number.

HTH

**TheBOSS** · 11-26-2009, 01:12 AM

Thanks Richard, I actually ended up doing that two drop down boxes before you replied. How do you "use the selections to create a decimal time number" though?

**Paul** · 11-26-2009, 01:20 AM

If your two drop-downs are in F5 and G5, you could use the formula:

=TIMEVALUE(F5&":"&G5)

Format the cell with the formula as Time, of course. Also, your drop-downs should have 0-23 and 0-59, since you would normally not use 24 for the hour or 60 for the minute.

**Colin Smit** · 08-13-2014, 03:20 AM

Attachment 338667See sample I recently finished (With help from this Forum) I had to get a work-around as the "Date Time Picker" I could not use as it is not compatible on a 64bit Windows.