How do I create an Employee weekly scheduler

I am trying to create a weekly schedule in excel for approx 22 employees

What you have provided gives nothing about what you want. What do you want
this schedule to look like? What parameters do you want and where do you
want them? What have you done so far? HTH Otto

"jv" <jv@discussions.microsoft.com> wrote in message
news:080D271B-75C8-470B-896A-6751A5163813@microsoft.com...
>I am trying to create a weekly schedule in excel for approx 22 employees

"Otto Moehrbach" wrote:

> What you have provided gives nothing about what you want. What do you want
> this schedule to look like? What parameters do you want and where do you
> want them? What have you done so far? HTH Otto
>
> "jv" <jv@discussions.microsoft.com> wrote in message
> news:08I have Column A as the Employee Name and Columns b thru h as the days of the week. I want to be able to put in their work schedule (4:00 - 10:00) and have a foumula calculate the hours. 0D271B-75C8-470B-896A-6751A5163813@microsoft.com...
> >I am trying to create a weekly schedule in excel for approx 22 employees
>
>
>

Try this:

http://office.microsoft.com/en-us/te...CT011377091033

There are others here too.

-- Carlos

"jv" <jv@discussions.microsoft.com> wrote in message
news:080D271B-75C8-470B-896A-6751A5163813@microsoft.com...
|I am trying to create a weekly schedule in excel for approx 22 employees

ok, but i want to insert a pause into a woorksheet based on the formula from
the temlate, any good ideas ?

"CarlosAntenna" skrev:

> Try this:
>
> http://office.microsoft.com/en-us/te...CT011377091033
>
> There are others here too.
>
> -- Carlos
>
> "jv" <jv@discussions.microsoft.com> wrote in message
> news:080D271B-75C8-470B-896A-6751A5163813@microsoft.com...
> |I am trying to create a weekly schedule in excel for approx 22 employees
>
>
>

Hi There,

I am looking to create a shift scheduler in excel for about 20 person covering 3 shifts in a 24 hour period 7 days a week and the plan must be for a month period altogether (in one work sheet).

due to the preferences i need to be able to put in dates that they cannot work and the spreadsheet to automatically update the shift patterns with someone who is available.

Has anyone any ideas


thanks Conan