If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
time sheet drop down lists
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? |
#2
|
|||
|
|||
time sheet drop down lists
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? |
#3
|
|||
|
|||
time sheet drop down lists
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? |
#4
|
|||
|
|||
time sheet drop down lists
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? |
#5
|
|||
|
|||
time sheet drop down lists
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? |
#6
|
|||
|
|||
time sheet drop down lists
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Time Zone suggestions for Outlook Calendar | Ben Knox | Calendar | 2 | October 20th, 2005 03:42 PM |
Excel formula for a time sheet | HRMSN | Worksheet Functions | 1 | August 10th, 2005 03:07 PM |
Please Help! Ref Article ID 210504 | Telobamipada | New Users | 8 | May 9th, 2005 01:09 PM |
Time Sheet Calcuations | ELL | Database Design | 3 | October 7th, 2004 02:26 PM |
Use first record found in expression? | CASJAS | Running & Setting Up Queries | 17 | July 22nd, 2004 09:21 PM |