Scheduling formulas

[adavies]

Hi All,

I am doing a scheduling formula for work. The workbook has a spreadsheet for a two week period. The main one is the two week schedule itself with about 100 workers in my department. The second sheet is a sign in sheet. What I need is a formula that will make the sign in sheet have set start times for, let's say SUNDAY, and it will reference the schedule and insert peoples names that are working on sunday starting at a certain time and if no one is working at that time then it will be left blank.

Example:

Schedule
Sunday

Name Start:
John 06:00
Jack X
donna 06:30

==>

Sign In
Name: Time
John 06:00
Xblank 06:15
Donna 06:30


Is my explanation clear?

Any help would be appreciated as I have been working on this for months now with no working solution.

 

[venkat1926]

sheet 1 will be this

Name Start:
John 6:00
jack
donna 6:30


sheet2 will be

Name: Time start time formula for column c
John 6:00 6:00 =VLOOKUP(A3,Sheet1!$A$2:$B$5,2,FALSE)
6:15 #N/A =VLOOKUP(A4,Sheet1!$A$2:$B$5,2,FALSE)
Donna 6:30 6:30 =VLOOKUP(A5,Sheet1!$A$2:$B$5,2,FALSE)

 

[adavies]

Thanks,

I tried the formula and it kept on giving me #ref errors