time list box

[-Brian-H-]

is it possible to make a list box which opens w/ 1st shift , 2nd shift,
3rd shift. and upon selecting one of these, would open a 2nd box
containing an hourly list w/ the hours of the day in 15 min
increments?

 

[Dave Peterson]

Debra Dalgleish has a technique for doing this with Data|Validation:
http://www.contextures.com/xlDataVal02.html

(you'll have to make those lists yourself, though.)