Tips for using employee duty schedule
Preparation of employee duty schedule:
1. Clean areas include: office areas, bathrooms, conference rooms, floors and other included areas.
2. According to the shift arrangement, cleaning will be carried out in turns, and the personnel of the administrative and human resources department will be responsible for the health inspection.
3. Cleanliness and sanitation implement a sanitation responsibility system. Office managers are responsible for managing the cleanliness and sanitation of all areas of the office. On-duty students will do all the cleaning on time, and supervisors will conduct corresponding inspections in a timely manner.
4. The office administrator will maintain cleanliness and hygiene from time to time to ensure the cleanliness of the floor, the supply of tea, the cleanliness of the bathroom and the supply of toilet paper.
5. On-duty students should complete all cleaning projects within the specified time and fill in the "Cleaning and Hygiene Duty Form". The supervisor will carefully verify and fill in the "Cleaning and Hygiene Supervision Form".
6. Those who fail to clean as required will be punished in accordance with regulations.
General tips for employee duty schedule forms 1: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
2: Conditional counting
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
3. Change number format
Excel’s shortcut keys are not chaotic, but follow a certain logic.
For example, if you want to quickly change the format of a number, you can immediately add a dollar sign to the number, because the $ symbol and the number 4 share the same key.
In the same way, "Ctrl+shift+5" can quickly change the number into the form of percentage (%).
Recommended by the editor of Huajun Software Park
Employee duty scheduleIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the employee duty schedule, download it quickly. also,Medical treatment information registration form,Registration form for making up missed classes for studentsIt is also a good form template. Welcome to click to download and experience it!
it works
it works
it works