Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hey Biff,
So much for being clear. Let me try again. I need to enter a start time in the first column. Then when I enter the end time I would like to be lazy and not half to scroll from the top of my time list shown in the drop down to a time after the start time. Example: 1st column start time 3:15 pm 2nd column end time 3:30 pm or later "Biff" wrote: Hmmm.... 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 "Biff" wrote in message ... Hi! So, there is a particular end time that corresponds to a particular start time? If so, why not just use a lookup formula? Biff "Steve" wrote in message ... I have set up a time sheet in which e6:e14 has a drop down list of times in 15 minute increments. This is the start time. I have g6:g14 with the same 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
drop down lists | New Users to Excel | |||
Excel Used as a Time Sheet | Excel Discussion (Misc queries) | |||
CREATING MULTIPLE DROP DOWN LISTS IN SAME EXCELWORKBOOK | Excel Discussion (Misc queries) | |||
Drop Down Lists | Excel Worksheet Functions | |||
Time Sheet | Excel Discussion (Misc queries) |