Scheduling - Automatic Selections..?
 

Hi everyone,

I'm trying to redesign a work schedule for a minimum of 60 employees.
I already have a layout designed on Excel, with a layout something lik
this:

A9=Name
B9=Dropmenu shift selection ("10-630", "330-10", etc)
D9=Hrs worked (either 6 or 8 hours)

Since I need to be able to do a week's worth of scheduling in a day
I'm looking for a fast way to input shifts into B9. I thought
predetermined shift selection dropmenu per employee might work bes
(with 6 or 8 hr shifts displaying "10-630", "330-10", etc), with th
appropriate hours worked being *automatically* displayed in D9 upo
selection (either 6 or 8, reflecting a half hour being taken off fo
lunch).

I'm open to other ideas on this, which is why B column is reall
combined with C column, so that I could break the two up if needed t
have "Start" & "End" Shift columns. My primary criteria would be (1)
*really* would like to have it so that I wouldn't need to enter a colo
into the time for speed reasons (hence, "10-630", etc), and (2) i
would need to be relatively fast to enter.

Unfortunately, all my experience (or inexperience ;) ) with Excel ha
been by trial & error & I'm not very familiar with Excel programming o
large formulas. Yeah, I've probably jumped in over my head her
:rolleyes: Hence, I very much appreciate any input or suggestion
anyone may have.

Thanx very much in advance for any assistance...

Big M ;

--
Big
-----------------------------------------------------------------------
Big M's Profile: http://www.excelforum.com/member.php...fo&userid=3299
View this thread: http://www.excelforum.com/showthread.php?threadid=52820