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

We are getting close. This formula works great unless there is a drop down
list, which I still need. When this formula is entered into a cell with a
drop down list I get a #value error. Any suggestions?

"Biff" wrote:

OK, try this:

Assume you have a list of times in 15m increments in the range G1:G20. This
list is the source for your drop downs in A2 (start time) and B2 (end time).

As the source for the drop down in B2 use this:

=OFFSET(G1,MATCH(A2,G1:G20,0),,COUNT(G1:G20)-MATCH(A2,G1:G20,0))

So, if you select 9:00 AM as the start time from the drop down in cell A2
the drop down for cell B2 will start at 9:15 AM.

Biff

"Biff" wrote in message
...
I would like to be lazy and not half to scroll from the top


I understood that much!

Let me play around with an idea I have.

Biff

"Steve" wrote in message
...
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?