View Single Post
Old March 17th, 2006, 12:01 AM posted to microsoft.public.excel.misc
external usenet poster
Posts: n/a
Default time sheet drop down lists


After re-reading your post about 10 more times, I think I misunderstood the
first time around.

Why not just create separate lists. One that only contains the possible
start times and another that only contains the possible end times.


"Biff" wrote in message

So, there is a particular end time that corresponds to a particular start
time? If so, why not just use a lookup formula?


"Steve" wrote in message
I have set up a time sheet in which e6:e14 has a drop down list of times
15 minute increments. This is the start time. I have g6:g14 with the
setup only this would be end time. Is there a way that when I enter the
start time I will be able to enter the end time from the drop down list
without having to scroll down from the begining?