Hi There,

I need help to create a weekly staff rota. As supervisor open the worksheet the dialogue should appear asking to put number of Shifts (1 or 2) and number of People working (1-6). Based up the user input data the excel creates a staff rota.

Criteria to look

Shift 1 = 8:AM - 8:PM (12 hrs Straight)
Shift 2 = 8:AM to 12 PM & 4:PM to 8:PM ( 8 Hrs)
No. of Hours staff required to work per day = 8 Hrs.
No. of days staff need to work in one week= 6 days

Output should be

Staff 1 Hours need to work in week days and day off
Staff 2 Hours need to work in week days and day off
Staff 3 Hours need to work in week days and day off and so on...

I really don't know how to start please help me to create how do i set formulas in excel sheet. Appreciate your thoughts in these matter.