How is the length of continuous service calculated? How is continuous length of service calculated?

Seniority. The calculation can be started from the following aspects: (1) continuous calculation method, also called continuous calculation of length of service.

For example, if an employee is transferred from unit A to unit B, his working time in both units A and B shall be counted as continuous length of service. If an employee is wrongly handled, and is later reviewed and rehabilitated, the time of the wrongful treatment can be calculated continuously from the time of continuous calculation of the length of service before the error and the length of service after the rehabilitation, and the continuous length of service. (2) The combined calculation method, also known as the combined calculation of continuous length of service, refers to the work experience of employees.

Generally, if there is a period of interruption for non-subjective reasons, this period of time is deducted, and the two working hours before and after the interruption are combined. In the case of downsizing of retired workers and staff, the continuous working hours before retirement and after re-entry may be combined. (3) Seniority conversion algorithm.

Engage in special types of work.

and workers working in special working environments, the continuous length of service can be converted. When calculating the general length of service, the length of service of the enterprise should be included, but the general length of service should not be included in the calculation of continuous length of service. After the implementation of the basic pension insurance individual payment system, the actual payment period is used as the basis for retirement and pension insurance benefits, and the previous continuous service period is regarded as the payment period.

The calculation of the number of years of service or continuous service shall be calculated in accordance with the provisions of the Guo Fa [1978] No. 104 document, that is, only one year can be counted as a "full" anniversary.

If you have worked in three factories for a total of ten years, then your length of service is ten years.

2) The combined calculation method, also known as the combined calculation of continuous length of service, refers to the employee's work experience, generally not due to his subjective reasons for a period of interruption, the deduction of this period, the two periods of working time before and after the interruption are combined. In the case of streamlining of retired workers and staff, the continuous working hours before retirement and after re-entry may be combined.

In any of the following circumstances, it shall be calculated as the continuous length of service of the enterprise: where the management organ of the enterprise and the administrative side of the enterprise are transferred, the length of service of the enterprise before and after the transfer shall be calculated consecutively; For those who are transferred to study at home and abroad by the management organs of the enterprise and the administrative aspects of the enterprise, the study time and the length of service of the enterprise before the assignment shall be calculated consecutively.

The formula for calculating the number of months is: (year-year) 12+month-month+1. Here's how:

1. First open the excel sheet and enter the basic information of the personnel. This tutorial mainly calculates the continuous length of service, so the example mainly lists the participation time and retirement time, and the following uses the excel formula to calculate the continuous length of service.

2. In the continuous seniority column, the formula input here needs to complete the sail mold in the English half-angle state. Since the number of months is calculated, the formula should be: (year-year) 12 + month-month + 1.

Under the continuous length of service column, double-click the cell, enter the = sign, because it is the year, so you need to take the year for the first two columns, and then enter the year after the =, and then enter ().

3. The brackets here should be filled in with the number of the series, the number of the series is the number of the retirement time of the pei column, we click on the retirement time of the column, the number of columns automatically appear in the brackets.

4. According to the above method, the calculation formula of converting the difference of years into the number of months is completed, and the formula after input is shown in the figure.

5. Then enter the formula for calculating the difference between months of less than one year, and the month is month. After the year-month difference formula is entered, +1 is required. This is because we calculate the length of continuous service, including the first month of service.

6. After the formula is entered, press the Enter key. At this point, the months are calculated.

7. After calculating, select the cell with the sedan chair and drag the lower right corner of the cell downwards to calculate the number of months of continuous service of each person in the table.

If you have been in a company since you joined the company, you have been in normal attendance, which is the continuous length of service.

Legal analysis: 1) Where the management organ of the enterprise and the administrative side of the enterprise are transferred to work, the length of service of the head of the enterprise before and after the transfer shall be calculated continuously (2) If the enterprise management organ and the administrative side of the enterprise are transferred to study at home and abroad, the study time and the length of service of the enterprise before the transfer shall be calculated continuously (3) If the workers and employees are transferred to work in other enterprises by the enterprise management authority due to the suspension of work or the reduction of production of the enterprise, the length of service of the enterprise before and after the transfer shall be counted continuously (4) The dismissed workers, If an employee still returns to work in the enterprise when the enterprise resumes work, business or expands production, the length of service of the enterprise before and after the dismissal shall be calculated together (5) If the enterprise is transferred, reorganized or merged, and the original workers and employees still remain in the enterprise, the length of service of the enterprise before and after the transfer, reorganization or merger shall be calculated consecutively (6) If the employee ceases to work due to work-related injury, the medical treatment period shall be calculated as the length of service of the enterprise (7) If the employee ceases to work due to illness or non-work-related injury, and the medical treatment period is less than 6 months, the length of service of the enterprise shall be calculated continuously. If the employee still returns to work in the original enterprise after recovering from illness for more than 6 months, the length of service in the enterprise before and after the period is not counted as the length of service, and the length of service in the enterprise before and after is calculated as the length of service (8) The number of years transferred to the enterprise to work exclusively in revolutionary work and the military age during the period of service shall be calculated as the length of service in the enterprise. (9) The continuous length of service of employees of state organs and public institutions shall be calculated in accordance with the above provisions.

Legal basis: Detailed Rules for the Implementation of the Regulations on Labor Insurance

Article 38 The general length of service refers to the working time of all or the main ** of workers and employees who use their wage income as the means of subsistence. When calculating the general length of service, the length of service of the enterprise should be included.

Article 39 The length of service of the enterprise shall be calculated on the basis of the continuous service time of the workers and employees in the enterprise, and if they have resigned, they shall be counted from the date of their last return to work in the enterprise. However, this does not apply in any of the following cases.

1. The length of service of the enterprise before and after the transfer of workers by the management organ of the enterprise, the administrative side of the enterprise or the management side shall be counted consecutively. However, if there is a conclusive certificate for the transfer of work due to business needs before liberation, the length of service in the enterprise can be counted continuously. 2. If there is a conclusive proof that the workers who worked in the enterprise before liberation and were forced to leave their jobs and return to the enterprise can be combined for the calculation of the length of service in the enterprise after the discussion and approval of the trade union group and the approval of the labor insurance committee.