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.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,631
Messages
5,832,768
Members
430,166
Latest member
Nige Leeming

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top