Excel 2010 pick a time

Question

is there any way in excel that would allow me to pick a specific time in a format HH:MM. The
Date and Time picker allows to select only Calendar Day.

Desired result would be something like

Rad Time Picker

with a 1 minute sequence

Answer 1

You could set up 2 cells (one for hour, one for minutes), and set up corresponding spin buttons and have each cycle through the hours and minutes as you desire. then a button to grab the result and place it where you want.

Info on adding a spin button here