How to programme this in excel?

S

Sherees

This is what I want to know..
cell B1 & C1 is the cell to enter the duties of two staffs (namely X & Y).
B1 is for staff X, C1 is for staff Y. staff can chose any one of duty in B1
& C1 frm a dropdownlist of 10 different duties(like "Break shift", "10 - 6
PM", "10 - 2 PM"..and so on)..

We have another cell D1 E1 & F1 where we enter the staff strength in the
shop on three intervals of time (say 10 - 2PM, 2 - 6PM, & 6 - 10PM)
Assume D1 cell to show the staffs present in the shop during time interval
10 - 2PM, E1 for 2 - 6PM & F1 for 6 - 10PM.

Now for eg, staff X chose her duty as Break Shift in cell B1(assume cell B1
as Jan 1, B2 as Jan 2 and so on), now we enter in D1 & F1 digit 1. & the
other staff chose 2 -10pm duty in C1 now the staff strenght cells are as
follows...

D1 shows 1, E1 shows 1 &F1 shows 2... This is entered manually now checking
the staff duty.. Is it possible to automate it.. When the staff's select
their duty the staff strength column in the particular day must show up the
number of staffs as per the duty automatically.. Pls help me

rgds,
 
A

Arceedee

What are the 10 different duties? You can't just say "and so on" and expect
a full answer. We need all the facts please.

You state there are only three time periods in the day but we need to know
how the different duties are reflected in those periods.

In theory it doesn't seem too difficult but I would need to build a s/s
myself to prove it works.

Also ,why don't you have any titles at the tops of your columns?
 
S

Sherees

Could u pls give me ur e-mail id so that i can send u the excel sheet with
the mail, which wud make things much easier..
 
S

Sherees

Hi,

10 duties are as follows, 10 - 6PM, 2 - 10PM, BREAK SHIFT, 10 - 2/W.OFF, 10
- 2/P.OFF, 6 - 10/W.OFF, 6 -10/P.OFF, W.OFF, P. OFF, 10 - 10PM...

SHOP WORKS 10AM TO 10 PM, WHICH IS DIVIDED INTO 10 - 2PM, 2-6PM, 6-10PM

BREAK SHIFT= 10 - 2PM & 6 - 10 PM.. i TRUST THERE WONT BE ANY DOUBT WITH
OTHER DUTIES... 6 - 10/P.OFF means staff will work in the shop from 6pm to
10pm/4 hours is her pending off(P.OFF)...

if u give me the email id, i can send u the file that i made, and u can
suggest me better changes.. so please send me ur email id..

rgds
Sherees
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical 5
How to copy the function SUM but offseted in 7 columns 2
Different cells that need to sum in one 4
Split Cell Range into Multiple Cells 1
Nested IF statement 3
Dragging Series? 3
creating nested formulas from drop down box 5
Forcing User inputs 1

Top