How to arrange the excel personnel on duty cycle. For example, three people go to work and two peopl

It can be divided into groups of first and second people, and groups of second and third people. The third and first person are in a group, so that the rotation is repeated so that everyone goes to work for four days and has two days off.

The staff duty schedule is arranged by the Personnel Administration Department, which is announced at the end of last month and the staff on duty are notified to be on duty on time. Employees on duty shall perform their tasks continuously in the designated place at the specified time, shall not stop or go out at will, and shall eat and stay in the place designated by the company.

Employees on duty can deal with it first and report it afterwards if something happens.

1, make duty ** formula 2, enter in cell f2: =today(), the cell format is displayed as shown in Figure 3, merge a1-c1, enter in the cell: =today(), the cell format is displayed as shown in Figure 4, create the duty schedule in the i-n, column, the purpose is to realize the automatic cycle of the duty table 5, you can generate the BCEF column.

This can be three people to work, two people to rest for eight hours, one lun or six hours a round,

Make a duty ** style.

Enter =today(),3. in cell f2

Merge a1-c1, enter =today(),4. in cells

Create a schedule of duty schedules in the i-n, column for the purpose of realizing the automatic cycle of duty schedules.

There is an unreasonable phenomenon in the scheduling according to the map, and there is no A on the day shift on the third day and the night shift, that is, a rest is arranged, but A is not arranged during the break.

Those direct sales managers who claim to be so successful, if they are really so successful, how much performance they have done every year, how much money they have earned, can they be exemplary, just ask them to show the income tax payment certificate of personal income earned in the past three years.

In order to make the staff on duty and the daily shift customizable, it is more troublesome to make the formula, but once and for all, I can use it myself and send it to you to see.

If the on-duty personnel increase, you can directly add the personnel below, adjust the schedule by yourself, if you want to increase the daily on-duty personnel, you need to increase the columns, and adjust the formula parameters.

Method Step 1 Make Duty ** Formula 2 Enter =today() in cell f2, and the cell format is displayed as follows. The purpose is to realize the automatic cycle of the duty schedule. Determine who is on duty on a particular day, and the order of duty, enter to.

As shown in the figure, how to achieve automatic sorting on excel for this kind of scheduling, as well as this regular repetition, how to find out the data that is duplicated from the beginning of ** to the beginning of ** (so that you don't have to arrange it every time, just copy the duplicate data directly).

If there are three shifts a day, three people per shift, nine people need to be on duty every day, so only one person is allowed to rest per day, that is, each person is only allowed to take one day off every ten days, and only three days off a month.

If you do that, you can only set it to two shifts, usually a 12-hour clock. 6 people in a class. The squad leader is responsible for the overall work (mobile + top shift) Regardless of day shift or night shift, as long as someone is resting, the squad leader will be on top.

1. Open an excel workbook, create a new table, named it "Alternate Duty Table", of course, you can also choose your own name, mainly because you can find it yourself.

:1, make duty ** formula 2, enter :=today() in cell f2, the cell format is displayed as shown in figure 3, merge a1-c1, enter :=today() in the cell

excel staff on duty how to shoot the cycle, for example, three people go to two shifts, two people rest, at this time you only need to insert automatic.

What is the best time to schedule personnel on duty? Each person is on duty for eight hours. There will be two people who will have a fixed time break.

You can use the deduplication operation in Excel to solve the above problems!

If you want to get rid of the glitz and glamour and virtual networks, and also want to get rid of the trivial things and troubles at home, the best way is to strengthen your own learning, at least the skills you have learned are your own, no one can take them away, and you can apply the knowledge you have learned to society and work.

You can look for the order in which the functions are cut or cut directly, and then start with the previous one, and then end with this one, and then you can go to sleep.

Do you want to follow a calendar list, or do you want to determine who is the day off today (or tomorrow).

Let's sort out the idea first, three shifts a day, three people per shift, then nine people need to be on duty every day, then only one person is allowed to rest every day, that is, everyone is only allowed to take one day off every ten days, and only three days off a month.

No need for Excel.

It is assumed that each of the four is replaced by ABCD.

Rest Work Time A BCD 1-8 B CDA 9-16C DAB 17-24D ABC 25 - A number of days in the next month.

And so on and so forth.

Fill it down like this.

Can this be done?

Calculated on a monthly basis of 30 days, if 3 people are arranged to work every day, 90 people are required.

And 4 people arrange 22 days a month and only 88 people. So you can't meet your requirements.

Can't drain it, there aren't enough people.

4 people, calculated on a small monthly basis, a total of 4*(30-8) 88 person-days per month.

3 people per day*30 days, a total of 90 person-days.

There are still 2 man-days left.