Correct completion of the working time schedule for May. The importance of scheduling monthly shifts: a template. Shift method of work

When staff work in shifts or flex, it's easy to overlook overtime or oversight. Learn how to plan your working hours in advance and ensure that each worker achieves the set hours.

In the article:

Use samples from experts in your work:

The work schedule does not have a unified form. The employer has the right to develop a document independently. The schedule includes a list of all employees with an indication of the position. Each surname is followed by a table indicating the calendar days and notes with the days of work, rest, being on sick leave, on vacation, and so on.

It is rational to include a separate column or column in the sample work schedule, in which employees will put their signatures and the date they read the completed document. If such a column is not provided, a separate familiarization sheet is drawn up, where signatures and the date will be affixed.

A sample employee work schedule for a month is filled in by the head of the structural unit or a responsible person appointed by order. The document can be approved by the immediate head of the organization by issuing a separate order.

If the work is shift work, it must be taken into account that, in accordance with Part 3 of Article 103 of the Labor Code of the Russian Federation, the shift schedule is drawn up and approved taking into account the opinion of the trade union organization or the representative body of workers (if any).

Order on approval of the vacation schedule

Download Sample

Note! A sample work schedule is filled out and approved, taking into account a special procedure - this is regulated by Article 103 only for shift schedules. These rules do not apply to other modes of operation.

★ Do not confuse the work schedule (you can download a sample in Word in the "Personnel System") with the time sheet. These are two completely different documents. The first is provided for by Article 103 of the Labor Code of the Russian Federation, undergoes preliminary agreement with the trade union and establishes a certain work schedule at the enterprise. It is carried out, as a rule, only at enterprises with a shift mode of operation. The time sheet is mandatory for all employers, is maintained in accordance with the requirements of Article 91 of the Labor Code of the Russian Federation and simply records the number of hours and days worked by each employee. It is impossible to fill out a time sheet on the basis of a shift schedule, since only the planned, and not actually worked time is reflected in the schedule! How to schedule shift work, whether to allocate night shifts with a separate code, and read in the Kadrovoe Delo magazine.

A hint from the experts of the magazine "Personnel Business". 7 rules about shift work

How should the employee work schedule look like (sample)

Since a unified form is not provided, the employer himself decides how the sample work schedule of employees for a month, week, decade, quarter and any other period (up to a year) should look like.

But there are still certain design rules.

• when compiling a document, adhere to the general requirements of GOST R 7.0.97-2016;
• it is optimal to make a graph in the form of a table with columns for different types of information;
• the table should be of such volume that the names of all employees included in the schedule fit;
• do not forget to provide fields for certification details (signatures, seals).

★ If the company's staff works in shifts or in a flexible mode, use the smart work schedule of employees for planning and accounting (all Kadra system subscribers can download a sample). By using this handy document From the experts of System Kadra, you can easily plan work within any calendar period, record all shortcomings and overwork, calculate and adjust the hourly rate for each employee in advance.

When the completed sample work schedule is approved

When scheduling work or shifts, the summarized accounting of working hours is mainly used. A sample work schedule is filled out for the entire accounting period. This allows you to avoid overtime and comply with the norms of working hours. If the organization takes one year for the accounting period, the document is drawn up immediately for the entire calendar year.

Note! A sample work schedule is filled out and approved in advance. Employees must be familiarized with the document before the start of the next accounting period. In shift mode, the schedule is brought to the attention of employees no later than one month before its entry into force (Article 103 of the Labor Code of the Russian Federation). The employer must take into account that familiarization takes place with a ready-made schedule, and not with a project created in advance.

Example

In the organization, the quarter is taken as the accounting period. The third reporting period starts on July 1, 2019. This means that the responsible person or the head of the structural unit fills in the schedule, approval is carried out. Familiarization of employees with the document must occur in advance, it is recommended no later than June 1, 2019.

How to make a work schedule in Excel: sample + instruction

As a rule, it is the personnel officer or secretary who draws up the official work schedule for the entire enterprise or for its individual divisions: you will learn how to draw up a sample correctly from the step-by-step instructions.

1. Fill in the header. Any working time schedule (sample) must contain information about the employer. It is enough to indicate the name of the organization and the structural unit - the workshop, branch, brigade or department for which the document was drawn up. Below, under the heading, indicate the registration number and the date of the schedule, as well as the period of its validity (set by the employer).
2. Arrange the main part in the form of a table. You can develop it from scratch, but it’s much easier when you have a ready-made work schedule table for a month at hand (sample, empty). All that is needed is to download the basic form and transfer information on a specific enterprise into it. Each column of the table is intended for a separate type of information.

Specify:

• serial number of the record (number the lines according to the number of employees in the department);
• the surname, initials and position of the employee: as a rule, the head of the department or service, the head of the shop, etc., are indicated first, then leading specialists and ordinary personnel;
• personnel number of each employee;
• distribution of shifts by day of the week and day of the month;
• the total number of days and hours that each employee must work during the accounting period;
• the total number of hours worked by each employee during the night.

Shift schedule template: employees work in two shifts

Download Sample

The content of the table is determined by the length of the accounting period, the number of employees in the unit and its mode of operation(two-shift, three-shift, etc.), the presence or absence of night shifts in the schedule. Since night shifts, by law, must be one hour shorter than day shifts, and an additional payment is required for the time worked at night, it is taken into account separately. If no one works at night at the enterprise, this column is not needed.

1. Add general information and explanations. Indicate the total number of employees included in the schedule, briefly describe the mode of their work - the number of shifts, the start and end times of each shift, the duration of work breaks. Here you can also give a decoding of the symbols used when filling out the table. There is no single system of codes, therefore, generally accepted and intuitive designations are most often used: shifts are marked with Roman numerals, the letter "B" - days off, etc.

1. Certify the document. The stamp of approval, which the head of the company must sign, is placed in the "header" or at the bottom of the form.

★ When scheduling, observe the labor rights of workers. Remember: the labor code prohibits work for two shifts in a row, shifts before a non-working holiday should be reduced by one hour, and the duration of an uninterrupted weekly rest should be at least 42 hours. The expert of "System Kadra" will tell, how to organize work in several shifts without breaking the law and without causing complaints from the GIT .

Only after the employees get acquainted with the approved version of the schedule under the signature, they will be obliged to comply with it. The information should be brought to the attention of the personnel no later than a month before it comes into force (Article 103 of the Labor Code of the Russian Federation). A familiarization sheet will help confirm that employees are familiar with the new schedule and agree to adhere to it. Make it a separate document or as an attachment to the schedule. As an option, you can start a separate journal for familiarization marks.

A sample of the design of the sheet of familiarization with the shift schedule

Download Sample

Completed shift schedules are kept for 5 years. But if they were compiled for positions and work associated with difficult, harmful and dangerous working conditions, the storage period is extended to 75 years (see the list approved by order of the Ministry of Culture of Russia No. 558 of 08/25/2010). It is counted from January 1 of the year following the year of the end of the accounting period, which is reflected in the schedule (instructions approved by the Main Archive of the USSR on August 15, 1988). In other words, if the schedule was drawn up for October, November or any other month of 2018, count its storage period from January 1, 2019. And if the accounting period began in December 2018, but ended in January 2019, start counting from January 1, 2020.

How to write a sample shift work schedule

A sample work schedule for employees in shift mode is filled out when the duration of the production process exceeds the allowable length of the working day. This forces the introduction of work in two, three, four shifts, which makes it possible to use equipment more efficiently, produce more products or provide services.

A sample work schedule form is filled out taking into account the internal regulations of the organization. If the duration of the day shift is from 9 am to 9 pm, and the night shift is from 9 pm to 9.00 am, the shift schedule will be as follows:

Organizations that use a round-the-clock technological process can set an individual shift schedule. Personnel serving railway, air transport, 24-hour supermarkets, working in customer support services and other companies, go to work according to the developed shift schedule.

When filling out a sample work schedule form for a month, it is necessary to take into account the current legislation. The rest time after the shift should be twice the duration of the shift itself. Based on article 99 of the Labor Code of the Russian Federation, overtime work cannot exceed the established maximum amount of 120 hours during the year. When filling out the document, it is worth considering this and involving such a number of people in the work so that the total amount of processing does not exceed the legally established norms.

How to draw up a work schedule for employees in other work modes, sample

The work schedule must be drawn up and filled out in any mode of work. If the work shift of the employees is the same, but there is a need to involve them in work on different days of the week, it is rational to draw up a schedule using a regime that provides days off on a rolling schedule.

A sample work schedule of 12 hours, when employees work for two days and rest for two days, does not apply to shift work. However, in many organizations, in internal regulations, such a mode is defined as a shift mode. This allows state supervision and control authorities to require the introduction of additional restrictions provided for in shift work:

take into account the opinion of the trade union committee or other representative body of employees when drawing up and approving the schedule;

familiarize employees with the schedule no later than one month before the start of its action (Article 103 of the Labor Code of the Russian Federation, part 4);

strictly observe the established duration of the rest between shifts (in this case, the rest must be at least 24 hours).

Note! If the organization has one shift of employees during the working day, work after three days does not apply to the shift mode.

The correct definition of the operating mode, included in the internal regulations, will avoid additional restrictions. For employees working in accordance with the internal regulations, two days for 12 hours, followed by the provision of two days of rest, an appropriate schedule is drawn up.

Work schedule 2/2 sample download

Shift method of work

The shift work schedule is drawn up separately, since this type of work refers to special cases. When drawing up a document, it is worth considering the recommendations specified in Chapter 47 of the Labor Code of the Russian Federation, the resolution of the USSR State Labor Committee, the secretariat of the All-Union Central Council of Trade Unions and the Ministry of Health of the USSR No. 794 / 33-82 of December 31, 1987. Article 301, part 1 states that the shift work schedule is approved taking into account the reasoned opinion of the trade union committee or authorized representatives of employees.

Note! When forming the work schedule of shift workers, it must be remembered that the duration of a daily work shift cannot exceed 12 hours. Inter-shift rest, taking into account breaks for meals and rest, can be reduced to 12 hours.

Days off when working on a rotational basis can fall on any day of the week. The number of days off is set not less than the number of full weeks in a month. The time of delivery of workers to the shift and back is taken into account when drawing up the schedule of the special regime of work on the basis of Article 301, Part 2 of the Labor Code of the Russian Federation. Shift workers should be familiarized with the drawn up and approved schedule no later than two months before the start of its action (Article 301, part 1).

Download Sample

Note! If the contract with the employee does not indicate that the performance of labor duties will be carried out in shifts, it is necessary to draw up an additional agreement, where this condition should be included as a separate clause.

The shift work order is considered an important document. It is equally important to introduce the conditions for establishing an appropriate work schedule in the internal regulations of the enterprise, internal regulations and the collective agreement. All documents indicate the duration of the work shift, the start and end time of work, the total number of shifts during the day, the order of alternation of days of work and rest.

How to approve the work schedule for employees: a sample order

It is not enough just to draw up a work schedule (download a sample in Excel or Word and fill it out), you also need to approve it. Issue a written order for the document to come into effect. There is no unified form for such cases, so the order is drawn up in free form, receives a registration number and certified by the signature of the head of the organization.

Sample order for approval of the shift schedule

Download Sample

In the administrative part of the order, indicate the details of the schedule that comes into force, and information about the official who is entrusted with monitoring its implementation. This may be a personnel officer, secretary or chief accountant, and if the organization is small, then its head or his deputy. Do not forget to enter the current date and place of execution of the order, as well as familiarize the responsible employees mentioned in the document with it.

★ If the enterprise has a trade union or a representative of the labor collective that defends the interests and rights of employees, first coordinate the draft document with it. This requirement, enshrined in Article 103 of the Labor Code of the Russian Federation, must be observed by all employers. The general procedure for coordination, concerning not only local regulations, but also shift schedules, pay slips and some other documents, is prescribed in article 372 of the Labor Code of the Russian Federation. The motivated opinion received from the trade union can be positive, negative or with a proposal for improvement.

For personnel working in shifts, flexible or any other mode that differs from the standard 40-hour week with a fixed start and end of the working day, a work schedule is formed (it is not difficult to download a sample or develop from scratch). The presence of such a document will allow you to clearly standardize working hours, exclude overtime and other violations for which the employer faces a fine.

A sample shift schedule will help you create your own plan for the activities of each employee in the enterprise. It can be downloaded for free.

The uniqueness of each profession is unconditional. Nobody will argue with this. Most of the country's population works according to the 5/2 schedule, where there are five working days and two days off. But there are many other modes of operation. The sample shift schedule offered on this page will help you create your own plan for the activities of each employee in the enterprise. Like all templates, the shift schedule example can be downloaded for free via a direct link.

A number of organizations do not have the ability to stop the process of functioning and are forced to work 24 hours a day. In this regard, there is a need for personnel to ensure the functioning. Regulation of the activities of workers is simply necessary to solve the problems of the company. Thanks to a properly drawn up shift schedule, work takes place automatically. One specialist passes the shift to another. That, in turn, transfers authority to the third.

Mandatory shift schedule items

• Company details in the upper left corner;
• On the contrary, on the right, a management approval mark is placed;
• The shift schedule can be specified by the structural unit;
• The main content is compiled in the form of a table, where the full names of employees are entered vertically, the day of the month horizontally;
• The duration of the shift, breaks for rest and meals, the number of employees in the shift are to be fixed.
• In the lower part, specialists and the immediate supervisor put their signatures confirming familiarization with the document.

The work schedule of employees will help plan uninterrupted work when working in shifts. Read how to compose it, download the sample

From this article you will learn:

What is a work schedule

A working time schedule is a document that specifies the beginning and end, as well as the duration of the working day of employees when working in shifts. Art. 103 of the Labor Code of the Russian Federation obliges the employer to draw it up and approve the LNA.

Working time can be:

• standard (5 or 6 days) - there is no need for scheduling;
• non-standard (for example, replaceable) - needs planning.

If an enterprise operates around the clock, whether it is a large thermal power plant or a small shop, it is obvious that people are needed to maintain the work process. But not a single workaholic will be able to work continuously, and Article 91 of the Labor Code of the Russian Federation establishes the duration of working time no more than 40 hours a week. In this case, employees work in shifts, for example, for 12 hours, but not every day.

Directly, the form itself of the schedule for employees to work in 2019 does not have a unified form; it can be developed personally by the head of the company. In this case, you can use the sample work schedule of employees below.

Filling out the form (drawing up a work schedule) is carried out by the head or an authorized person appointed by order.

Often these are heads of departments, since it is they who, immersed in the work of their department, can do it in the most optimal way. The compiler must take into account the time that each employee will work, without allowing for flaws or overtime. The schedule is usually developed for a month, but sometimes quarterly or even annual schedules are used. Not less than a month before the plan comes into force, all personnel sign to familiarize themselves with it.

To facilitate the scheduling of work, the following structure can be taken as a basis:

1. Introduction:

• name of the company and structural unit,
• title,
• date and place of creation,
• for what period it was made.

2. The main part is compiled in the form of a table (matrix) with columns:

• Names of employees and their positions,
• day of the month,
• at the intersection of the graph in the cells, with the help of symbols, it is indicated whether the person is working on that day (and if so, on what shift) or is resting.

3. Final part:

• decoding of symbols (for example, 1 - first shift, 2 - second shift, c - day off);
• shift start and end times (for example, shift 1: 08.00-20.00, shift 2: 20.00-08.00), shift duration;
• the number of workers on a shift.

4. Signatures: compiler, manager, employees (with a mark of familiarization). The storage period for schedules is not established by law, but it is assumed that it is similar to the period of time sheets for RV and is 5 years (in hazardous / hazardous production - 75 years). Many managers, just in case, save the plan in the personnel department for a year before transferring it to the archive.

Calculation of shift work schedule

To avoid mistakes and correctly draw up a shift schedule in 2019, use:

• 1C: ZUP
• Google Sheets
• online calculators
• MS Excel

First of all, the accounting period is established and approved by the LNA (month, quarter, half year or year).

The accounting period cannot be more than 1 year under normal conditions and more than three months - in harmful conditions. For some professions, it is separately regulated by law.

With a shift schedule, the summarized time tracking (SURV) is used. This is convenient, since most often the weekly norm of 40 hours is not observed, and with monthly or quarterly payment, the average value is leveled.

The optimal duration is considered to be a quarter, the interval is medium in duration, and therefore more flexible. There are often cases when, already at the stage of drawing up a shift schedule, significant processing is laid into it - keep in mind that this is prohibited. Failure is also not welcome. If, in fact, one or the other did happen, the employer will have to compensate the employee in accordance with the law.

Basic rules for calculating shift work schedules in 2019:

• determine the RMS;
• fix work in the daytime and at night;
• observe the legislation in the field of rest of employees (in particular, the rule of 42 hours of uninterrupted weekly rest);
• personalized time tracking for each employee.

It is important not to forget:

• set a time limit taking into account the category of workers (minors, people with disabilities, etc.);
• pay for work on holidays (Article 112 of the Labor Code of the Russian Federation) at a double rate, taking into account that the holiday starts at 00:00 and ends at 24:00.
• to reduce the norm of hours for an employee who began to work not from the beginning of the accounting period;
• exclude from the norm hours missed due to illness or vacation.

When I was transferred to the position of a manager, I was faced with the need to schedule work for my employees. At first, I often confused it with a time sheet, but now I understand the differences between these documents well. The schedule is drawn up in advance so that each person knows how many days and when exactly he should go to work. And the report card is compiled already on the fact of the presence of a person at the workplace or in his absence. And in the framework of this article, we will analyze in detail how to properly draw up work schedules.

Differences from 2017

Legislation annually introduces various changes and additions to the procedure for maintaining internal documentation not only in accounting, but also in personnel matters. Some changes have also been made this year. The graph is a multi-component document that contains information about the following:

• norm of time which a person must work out;
• number of days intended for work and free time in a person during a specified period;
• time limits duration of the employee's working period;
• time intervals intended for a break.

The number of obligatory days in the standard week 5/2 has not changed compared to last year. Therefore, we have to work 247 days out of 365. If we compare the schedule of 2017 and the current one, we can draw several conclusions:

1. The total number of calendar days has not changed also remained unchanged and the number of working days.
2. The number of days when a shortened day by an hour is legally declared will be 6. Last year there were only 3 such days. I remind you that shortened days are established by law before holidays. Therefore, employees can work 1 hour less, while they must be paid a full day, without having to work on this hour later.
3. The number of days off, as well as holidays, turned out to be the same and amounted to 118 days.

These holidays and weekends are relevant only for those modes of work where there are standard working weeks with fixed or flexible days off. When work is carried out in shifts, weekends do not have a significant impact on the schedule.

Compilation nuances

To correctly format this document, you need to know which approach to use. The sequence of actions should be as follows:

1. It is necessary to define a specific period for which this document will be compiled. Usually this calendar period is rounded up to a certain number of days, for example, month, year, quarter. Although sometimes you can see the schedule for the week.
2. If an organization has multiple operating modes, it is necessary to divide all employees into groups in accordance with their modes. In this case, it will be much more convenient for you to create a schedule, and you will not get confused about who should go to work on what day.
3. Next, you need to calculate the working time for each mode.. That is, you must determine how many days employees who are on a 5-day system should work on a flexible schedule.
4. Now we need to group the working days with the days off in this way to meet the 42-hour rest requirement for each employee.

It is imperative to take into account certain categories of workers who are entitled to a reduced or part-time day. For such categories, it is necessary to calculate separately the size of their working week in hours, determine the number of days that they must spend at work. And after that, it remains easy to calculate by dividing the maximum allowable number of hours by the number of days.

Remember that any work time allowance is reduced by the total number of breaks when the worker is not actually working.

This includes non-working breaks such as:

• sick leave;
• vacation;
• other days laid down for the employee by law.

If we calculate the number of hours that a typical employee must work during a 5/2 work week, the calculation will be the following formula:

8 hours * 247 days - 6 hours = 1970 hours, where

• 8 ocloc'k- this is the standard norm for the duration of the working day;
• 247 days- this is the number of weekdays, minus holidays and weekends, which are officially established by law for the current year;
• 6 hours- the amount of time that was reduced by law as pre-holiday this year.

Thus, in 2019, all employees must work 1970 hours according to the norm. But from all this amount, you still need to subtract at least 28 days that the employee is entitled to leave. And accordingly, this is 20 working days for 8 hours = 160 hours. In total, it turns out that 1810 hours on average will be worked by each employee at week 5/2.

The type of graphs can vary significantly, as they directly depend on the set operating mode. Therefore, the legislation does not establish a certain strict form of this document. You can learn more about this in the video below.

Schedule

For the convenience of compiling this document, I recommend using Excel if you do not have one of the special accounting programs installed, where all accounting and other accounting data is immediately entered.

When making your own chart, I recommend making it in the form of a table, where you will have the following columns:

1. Subparagraph number. Then it will be easier for you to navigate the table itself.
2. Full name of the employee. Here you will need to enter your entire state. I recommend pre-dividing them according to their modes. And then you have to arrange them in groups.
3. Job title. It will help you visually navigate and control the correctness of the drawn up schedule and the specified mode of work.
4. Discharge. You will need this column if you have employees with different ranks and qualifications. If your company does not take into account this information, then this column can be omitted.
5. Numbers. You must create as many columns as there are days you want to include in your chart.
6. Norms. You must calculate the norms in days and hours as a result in order to check the compliance of the drawn up schedule with the current legislation.
7. Number of days off. Holidays are also taken into account. You must enter their number in order to see how many days your employees will actually have a rest.

Then, in each cell, you must fill in who, when, works and rests. I recommend doing this on a computer, as the information can be easily erased and corrected if necessary. If you need to compile this document in printed form, be sure to do it in pencil, as it is often necessary to correct the entered data.

Many managers don't bother arranging shifts for their employees. They only prescribe the established norms for them and give the schedule for consideration by the team itself. And workers themselves determine the days when they will go to work. But this method is mainly used in shift mode. Because for standard 5/2 or 6/1 weeks, the scheduling is the same from week to week.

Although in some cases, with a flexible week, such a scheme can also be used. Its advantage is the ability of employees to independently determine the working days, based on their desires and capabilities, and the employer frees himself from unnecessary work.

But with a large staff, this method is difficult to use, since each employee will try to choose weekdays, and this can cause additional conflict situations.

The time sheet is the main document containing information on the number of attendances and absences for work of each employee of the company. It is transferred to the accounting department. And based on the data, wages are calculated and accrued.

The law provides for 2 unified timesheet forms: T-12 - to be filled in manually; T-13 - for automatic control of the actual hours worked (through the turnstile).

Data is entered every business day. At the end of the month, the total of attendances and absences of each employee is calculated. Report generation can be simplified by automating the filling of some cells using Excel. Let's see how.

Filling in input data with Excel functions

Forms T-12 and T-13 have almost the same set of details.

Download time sheet:

In the header of page 2 of the form (for example, T-13), fill in the name of the organization and structural unit. Just like in the founding documents.

We prescribe the document number manually. In the column "Date of compilation" set the function TODAY. To do this, select a cell. In the list of functions, find the desired one and press OK 2 times.

In the column "Reporting period" indicate the first and last day of the reporting month.

We allocate a field outside the time sheet. This is where we will work. This is the OPERATOR field. First, let's make our own calendar for the reporting month.

The red field is the dates. Puts down ones on the green field if the day is a day off. In cell T2, we put one if the time sheet is compiled for a full month.

Now let's determine how many working days are in a month. We do it on the operational field. In the desired cell, insert the formula =COUNTIF(D3:R4,""). The COUNTIF function counts the number of non-empty cells in the range given in brackets.

We manually enter the serial number, full name and specialty of the employees of the organization. Plus a payroll number. Information is taken from the personal cards of employees.

Automating a timesheet with formulas

The first sheet of the form contains symbols for recording working hours, digital and alphabetic. The point of automation using Excel is to display the number of hours when entering the designation.

For example, let's take the following options:

• On a weekend;
• I am a turnout (working day);
• OT - vacation;
• K - business trip;
• B - sick leave.

First, let's use the "Select" function. It will allow you to set the desired value in the cell. At this stage, we need the calendar that we made in the Operator's Field. If there is a day off on some date, “B” appears in the report card. Worker - "I". Example: =CHOICE(D$3+1,"I","B"). It is enough to enter the formula in one cell. Then “hook” it by the lower right corner and draw it across the entire line. It turns out like this:

Now let's make it so that on safe days people have "eights". Let's use the "If" function. Select the first cell in the row under the legend. "Insert function" - "If". Function arguments: logical expression - address of the cell to be converted (cell above) = "B". "If true" - "" or "0". If this day is really a day off - 0 working hours. "If false" - 8 (without quotes). Example: =IF(AW24="B";"";8). We “hook” the lower right corner of the cell with the formula and multiply it throughout the row. It turns out like this:

You need to do the same work for the second half of the month. It is enough to copy the formulas and change the cells they refer to. Result of work:

Now let's summarize: we calculate the number of attendances of each employee. The COUNTIF formula will help. The range for analysis is the entire series for which we want to get a result. The criterion is the presence in the cells of the letter "I" (appearance) or "K" (business trip). Example: . As a result, we get the number of working days for a particular employee.

Let's count the number of working hours. There are two ways. Using the "Sum" function - simple, but not effective enough. More complicated, but more reliable - by using the COUNTIF function. Formula example: . Where AW25:DA25 is the range, the first and last cells of the series with the number of hours. The criterion for the working day (“I”) is “=8”. For a business trip - “=K” (in our example, 10 hours are paid). The result after entering the formula.