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 like 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 a predetermined shift selection dropmenu per employee might work best (with 6 or 8 hr shifts displaying "10-630", "330-10", etc), with the appropriate hours worked being automatically displayed in D9 upon selection (either 6 or 8, reflecting a half hour being taken off for lunch).

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

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

Thanx very much in advance for any assistance...

Big M