B
Big M
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
Hence, I very much appreciate any input or suggestion
anyone may have.
Thanx very much in advance for any assistance...
Big M ;
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 habeen by trial & error & I'm not very familiar with Excel programming o
large formulas. Yeah, I've probably jumped in over my head her
Hence, I very much appreciate any input or suggestionanyone may have.
Thanx very much in advance for any assistance...
Big M ;