Schedule in Excel

[seanvaughan]

I have created a 24hr 7day work schedule in excel with over 155 employees. I
am trying to make a daily work schedule on a worksheet that will return a
list of emplyees and their start times.

The columns are headed with the start times 4am-12am
The rows will have the names.
I want to create a statements that will reflect if the employee starts at
4am, then it pulls that employees name from the master worksheet and places
it in the 4am column.

Any help would be greatly appreciated as I am new to Excel and working with
"major" formulas like this one. The math is easy - but I'm not sure how to
the the "if" statements.

 

[Myrna Larson]

What is the layout of the weekly schedule? Do you have more than one person
starting at the same time (I expect so...)?

Why do you want the name in the 4AM column? I thought you have it in the rows,
e.g. A1:A155.