Scheduling formulas

adavies

Board Regular
Joined
Nov 15, 2005
Messages
61
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.
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
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

Board Regular
Joined
Nov 15, 2005
Messages
61
Thanks,

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

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,326
Members
412,716
Latest member
thviid
Top