Experience program. Online work experience calculator - calculation according to the work book

To calculate the length of service, there are a number of programs that can greatly simplify this process. They provide the user with the opportunity to quickly find out the duration of the labor period, significantly saving time. It is this kind of software that will be discussed in this article.

This is a small program that performs only one function - the calculation of work experience. It produces a result based only on the date of hire and dismissal. With its help, you can also find out the total length of service by summing up all periods.

Calculation of seniority

Compared to the previous version, Counting seniority provides where more possibilities for the user. In addition to calculating the working period, this program creates a kind of report in the results. In addition, the user can easily edit the field with the results of her work and give it the desired look. After this report can be copied to any text editor for further processing.

Another feature is that with this application you can calculate the working period by indicating one year of work for several years of experience. Unfortunately, to get the total period of work using the Calculation of seniority, you will have to arm yourself with a calculator, since the program itself does not indicate this data.

Seniority calculation

The calculation of seniority is the most multifunctional program of all that we have reviewed in the article. In addition to the main function of calculating the working period, it can also save the entered data in a separate file, providing the possibility of reusing it. An important positive quality is the function of printing the created document on the printer. Another nice bonus- providing the application with information about the total and longest continuous working period.

This article has reviewed the best software tools that can easily perform seniority calculations. Some of them provide the user with a number of additional features, such as printing, import and export, counting a year in two, etc. All described programs are distributed absolutely free of charge and translated into Russian.

The calculation of work experience is different in different situations. Check if you correctly determine the number of years worked by an employee.

From this article you will learn

What is meant by work experience?

In personnel practice, several terms are used that relate to the concept. Therefore, the calculation of years worked is carried out in different ways.

	Peculiarities
	All periods of work, regardless of breaks between them. It was the basis of the pension system, but has ceased to have a special significance. When needed, .
By specialty	Years of work by profession are taken into account. It is considered important when applying for a job for a specific position, as it serves as a guarantee that a person understands the professional field. It also gives the right to early retirement if the conditions are harmful or dangerous. But in this case, we are talking more about a special experience that gives the right to early retirement.
Continuous	It includes the total duration of work not only with one employer, but in all organizations over the years of a person's life. Now it has lost its former meaning. Find out, .
Insurance	Depends on the period of time during which the employee is officially employed. It is used to calculate pensions, benefits and other payments.

In some cases, special types of work experience are taken into account, which include activities in special conditions, including harmful and dangerous ones. The activity of a specialist associated with a risk to life and health gives the right to early retirement, extended leave,.

Seniority Calculator

Experience information example

Practical situation

Answered by Natalia Ulanova,
lawyer, expert of the magazine "Kadrovoe delo".

In order for the FSS to offset the expenses of the organization for paying sick leave, and for the employee not to receive less than the required leave, correctly calculate the length of service. We have prepared cheat sheets with which you will find out which periods are included in it and which are not. If in doubt, look at the material, and there will be fewer errors in the calculations ...

Ask your question to the experts

Calculation of work experience according to the work book

Experience can be calculated. You can do this yourself or an accountant can do the work. To manually determine the duration of the period, you will need a copy of the work book and insert, a calculator, a sheet of paper, and a pen.

Note! Future social payments depend on how correctly they are. If you find errors in it, make the correct entries or direct the employee to the organization that incorrectly entered the information in the document. In some cases, the length of service is confirmed by certificates from employers, labor agreements, extracts from the records of the personnel department, testimonies, archival papers.

To do it manually, write down on a separate sheet of paper the periods of work in chronological order. From the date of dismissal at the enterprise, subtract the date of employment. Write out the data separately. Do not try to add labor periods in all organizations at once - this will lead to errors. What periods to consider.

The date of employment is March 15, 2010, and the date of dismissal is June 16, 2014. Work experience - 4 years 3 months 1 day. For clarity, make the following entry: 06/16/2014 - 03/15/2010. Write down all the periods of work in different organizations, and then add up the numbers. Convert the data to standard units of calculation - years, months, days. In the same way, follow work book if you determine the duration of work in the specialty. But in this case, take into account the time periods when the employee worked in the professional field.

In this case, take July 1 of the year as the date. If the day of the month is not reflected, take the 15th day of the corresponding month as the date. This is stated in the Rules approved. The insurance period is determined in calendar order. To understand the rules, consider the following situation. The employee got a job employment contract…

Two ways to calculate seniority with examples

If the result of the calculation is a negative number months or days, proceed as follows. When only the number of months turned out to be negative, reduce the resulting value by one, and add 12 to the number of months. Then reduce 12 by a negative number of months.

When the number of days turned out to be negative, reduce the number of months obtained by one. Add 30 to days, decrease them by a negative number. Keep in mind that when calculating in each period, a day is lost. Therefore, add to the resulting number exactly as many days as there were periods of admission and dismissal. It is this order that is established by the Instruction approved.

An example of calculating the total length of service when it turns out positive value days and months

An example when it turns out negative meaning days

Ivanova has three periods in her work:

from May 27, 1996 to March 13, 2003, she worked as a courier for ZAO Omega;
from March 19, 2003 to January 31, 2004 - at Germes LLC;
from February 1, 2004 to August 4, 2006 - at JSC Master.

On August 11, 2006, the employee went to work in another company. Sum of employment dates: 05/27/1996 + 03/19/2003 + 02/01/2004 = 10/47/6003. The sum of the dates of layoffs: 03/13/2003 + 01/31/2004 + 08/04/2006 = 12/48/6013.

The difference between the number of dismissal dates and the sum of admission dates: 12/48/6013 - 10/47/6003 = 02/01/0010 (10 years 2 months 1 day). Add three days to the resulting number, since there were so many periods of admission and dismissal. It turns out that the length of service is 10 years, 2 months and 4 days.

Glebova recorded three periods:

from May 27, 1996 to March 13, 2003, she worked as a courier at ZAO Omega;
from March 19, 2003 to January 29, 2004 - at Germes LLC;
from February 1, 2004 to August 4, 2010 - at JSC Master.

On August 11, 2010, the employee went to work in another company. Sum of admission dates: 05/27/1996 + 03/19/2003 + 02/01/2004 = 10/47/6003. The sum of the dates of dismissals: 03/13/2003 + 01/29/2004 + 08/04/2010 = 12/46/6017.

The difference between the sum of the dates of dismissals and the sum of the dates of admissions: 12/46/6017 - 10/47/6003 = (-01).02.0014. Since the number of days is negative, to determine the length of service, subtract one from the number of months, and add 30 to the number of days, from which subtract the negative value (-01). The resulting value will be 01/29/14 (14 years 1 month 29 days). Add three more days. The total length of service will be 14 years 2 months 2 days.

How to calculate seniority online?

To simplify the work, you can calculate the length of service online. So you will avoid mistakes, because the program rarely crashes. It is designed in such a way that every 30 days are automatically converted into a month, and 12 months into a calendar year. But this does not mean that you do not need to check the entered data. After their introduction, check the information again with what is available.

In the columns, enter the dates of hiring, dismissal in the format day, month, year. Enter data manually or use a special calendar.
If there are other periods that are counted as seniority, include them in the program.
Click the "calculate" button. See how long the employee worked.
If errors are found, re-enter the information.

Calculate seniority even novice personnel officers and accountants can use the program. Therefore, they began to be used much more often. Manual determination of the duration of work, if there are many entries, takes time.

Correctly calculate the length of service in order to avoid questions from the inspection authorities when submitting reports. Do not entrust work to inexperienced specialists who can make serious mistakes. Using online services, check if they count correctly. To do this, enter any few values, perform manual data control.

The time has come to calculate the length of service according to the work book. It's not as difficult as it might seem. There are several ways to calculate the total work experience: using the accounting program module, manually, using an online calculator, and using a free program for calculating work experience.

Free program for calculating seniority

If your work book has more than one entry, but several dozen, then it will be difficult to calculate the total work experience manually. Accounting programs usually have a seniority calculation module, but not everyone has a familiar accountant who can be approached with such a request.

There are also various online calculators for calculation insurance experience. But it would be more convenient for me to have such a calculator on my computer.

Recently, I had to count the insurance experience for a pension. When the idea of automating the process of calculating the total experience came to my mind, I began to think about how to write a program. Writing such an experience calculator is quite simple. A program for calculating seniority can even be made in MsWord. To write a program, it would be easier for me to use MSAccess, but not everyone has it. I also did not consider the final format of the exe file, since many are afraid to download and run unknown files on their computer. Therefore, taking into account all these limitations, I chose Excel for the seniority calculation program.

I suggest you download a simple program for calculating seniority for free. The proposed program is an Excel file - calculator.xls

The file is located on Yandex disk, which excludes the receipt of any viruses.

Download for free calculator.xls file.

The program for calculating seniority is free, you can use it without any restrictions. Forbidden to change free program and sell it.

To calculate the length of service, open the calculator.xls file and enter all periods of work on the work book in the cells with a yellow background, as seen in the screenshot below.

Enter the dates in the format DD.MM.YYYY (after entering, they are displayed as DD.MM.YY).

Dates are not controlled, that is, you yourself must monitor the correctness of the input. The order of the periods does not matter. If, when entering, you missed any period from the work book, there is no need to insert it in the middle. This period can be inserted at the end of the list.

When calculating, every 30 days is considered as a month, and 12 months as a year. It is also taken into account that the day of dismissal is included in the length of service.

In the cells on a green background, as you enter, data on the length of service for each period will appear, and on a light turquoise background under the inscription "total years months days" - the total length of service.

Make sure in advance that you have enough pension experience under the new pension rules. After all you can earn seniority for retirement without working . Read the instruction.

Calculate the total work experience manually

The procedure for calculating the length of service according to the work book manually:

write out all periods of work according to the work book,
calculate the number of days, months and years for each individual period of service,
calculate the total length of service by summing the length of service for all periods.

An example of calculating seniority

Consider the calculation of seniority on an example.

Let's take the following period of work according to the work book:
hired 08/04/1984,
dismissed 08/02/1996.

You need to start calculating the experience from the days. From the day of dismissal, we subtract the day of employment and add one, since the day of dismissal is also considered a working day, that is
2 - 4 +1 = -1.

But since the result less than zero, you need to take a unit of months, and this unit of months is equal to 30 days.

We get
30 + 2 - 4 +1 = 29 days

Now let's count the months, remembering that we took the unit when counting the days, that is, we need to subtract 1 from the months:
8 - 8 - 1 = -1.

Since the result is again less than zero, you need to take one from the number of years, that is, take 12 months.

As a result, we get
12 + 8 - 8 -1 = 11 months

Now we count the years, remembering that we took the unit when counting the months
1995 - 1984 -1 = 11 years

As a result of the calculations, it turned out that the length of service for the period was 11 years 11 months 29 days.

If the calculation of days would result in 30 or 31, in this case it would be necessary to convert this number of days into full months, that is, subtract 30 days and add one to the number of months.

The total experience is determined according to the same rules by adding days, then months and years of experience for all periods.

For example, take 2 periods
accepted - 08/04/1984, dismissed - 08/02/1996 (experience for a period of 11 years 11 months 29 days)
accepted - 09/15/1997, dismissed - 10/25/2001 (experience for a period of 4 years 1 month 11 days).

Let's sum up the days first:
29 + 11 = 40.

Since a full month is considered 30 days, subtract 30 from the amount received
40 - 30 = 10 days.

Let's take into account that it will be necessary to add 1 to the number of months.

Sum up the months
11 + 1 + 1 = 13.

It turned out more than 12 months. Since a full year is considered 12 months, subtract 12 from the number of months and add one to the number of years.

So, months will turn out
13 - 12 = 1 month

Let's sum up the years:
11 + 4 + 1 = 16 years old.

In total, the total length of service was 16 years 1 month 10 days.

As you can see, calculating the total length of service manually is quite time consuming, and it is easy to make a mistake.

You need to start the process with the preparation of documents. These include:

employment history;
labor contract;
collective agreement.

Take the dates when you started working at a particular place, as well as the end dates labor activity, enter it into the calculation programs and get the result online.

Currently, this is a really convenient and accessible resource for everyone.

Its undoubted advantages are:

simplicity;
lack of special knowledge;
counting speed;
automatic mode of operation.

The user is only required to enter the data known to him in special fields, and then click on the "Calculate" button. Further, the calculator will do everything by itself and provide the finished result.

You can use any calculator by entering the "Online seniority calculator" in the search box. Information about it can be found on the first pages of the issuance. search engine. You can also use the sites mentioned above.

citizens Russian Federation calculate their length of service federal law"On labor pensions in the Russian Federation" No. 173, which entered into force on 01.01.2002.

At present, there is no concept of “work experience” in the law, since December 31, 2001 it has been replaced by the specified term “insurance experience”, that is, the period during which a working citizen has worked with his wages deductions to the Pension Fund of the Russian Federation, and other periods legally justified added to them.

However, the phrase "work experience" is often used interchangeably.

The insurance period is the duration of periods of work and other activities during which paid insurance premiums to the Pension Fund of the Russian Federation.

In addition to periods of work, the length of service includes the following periods:

period military service;
caring for a child up to 1.5 years (if there are several periods, then the maximum period is 4.5 years);
period of temporary disability with registration sick leave(see → sick leave calculation example);
the period of registration in employment institutions when receiving unemployment benefits;
care for the disabled, the elderly over 80 years of age (guardianship);
period of illegal detention in places of deprivation of liberty.

An important feature calculation of the insurance period is the occupation of the type of activity that pays insurance premiums to the FIU. It doesn't have to be an organization individual entrepreneur independently transfers funds to the FIU.

study time in educational institutions, graduate school, courses is not included in the length of service, tk. insurance premiums are not paid to the FIU. The figure shows an example of the calculation of seniority.

The main calculation parameters are an indication of the date of acceptance and dismissal from work.

Download OK | Seniority

Compared to the previous option, the Seniority Calculation provides much more options for the user. In addition to calculating the working period, this program creates a kind of report in the results.

In addition, the user can easily edit the field with the results of her work and give it the desired look. After this report can be copied to any text editor for further processing.

READ ALSO: MILITARY INSURANCE COMPANY BRANCH - Kemerovo

Download Calculation of seniority

There are also various online calculators for calculating the length of service. But it would be more convenient for me to have such a calculator on my computer.

Writing such an experience calculator is quite simple. A program for calculating seniority can even be made in MsWord.

To write a program, it would be easier for me to use MSAccess, but not everyone has it. I also did not consider the final format of the exe file, since many are afraid to download and run unknown files on their computer.

Therefore, taking into account all these limitations, I chose Excel for the seniority calculation program.

I suggest you download a simple program for calculating seniority for free. The proposed program is an Excel file - calculator.xls

The file is located on Yandex disk, which excludes the receipt of any viruses.

Download the free calculator.xls file here.

The program for calculating seniority is free, you can use it without any restrictions. It is forbidden to modify the free program and sell it.

To calculate the length of service, open the calculator.xls file and enter all periods of work on the work book in the cells with a yellow background, as seen in the screenshot below.

Enter the dates in the format DD.MM.YYYY (after entering, they are displayed as DD.MM.YY).

Dates are not controlled, that is, you yourself must monitor the correctness of the input. The order of the periods does not matter. If, when entering, you missed any period from the work book, there is no need to insert it in the middle. This period can be inserted at the end of the list.

When calculating, every 30 days is considered as a month, and 12 months as a year. It is also taken into account that the day of dismissal is included in the length of service.

Make sure in advance that you have enough pension experience under the new pension rules. After all, seniority for retirement can be earned without working. Read the instructions on how to get seniority for retirement without working.

READ ALSO: PFR contributions in 2018 for lawyers

The procedure for calculating the length of service according to the work book manually:

write out all periods of work according to the work book,
calculate the number of days, months and years for each individual period of service,
calculate the total length of service by summing the length of service for all periods.

An example of calculating seniority

Consider the calculation of seniority on an example.

Let's take the following period of work according to the work book: hired on 08/04/1984, fired on 08/02/1996.

But since the result is less than zero, you need to take a unit of months, and this unit of months is equal to 30 days.

We get 30 2 - 4 1 = 29 days

Now let's count the months, remembering that we took the unit when counting the days, that is, we need to subtract 1: 8 - 8 - 1 = -1 from the months.

Since the result is again less than zero, you need to take one from the number of years, that is, take 12 months.

As a result, we get 12 8 - 8 -1 \u003d 11 months

Now we count the years, remembering that we took the unit when counting the months 1995 - 1984 -1 = 11 years

As a result of the calculations, it turned out that the length of service for the period was 11 years 11 months 29 days.

If when calculating the days it would turn out 30 or 31, in this case it would be necessary to convert this number of days into full months, that is, subtract 30 days and add one to the number of months.

The total experience is determined according to the same rules by adding days, then months and years of experience for all periods.

For example, let's take 2 periods: accepted - 08/04/1984, dismissed - 08/02/1996 (experience for a period of 11 years 11 months 29 days) accepted - 09/15/1997, dismissed - 10/25/2001 (experience for a period of 4 years 1 month 11 days).

Let's sum up the days first: 29 11 = 40.

Since 30 days are considered a full month, subtract 30 from the amount received 40 - 30 = 10 days.

Let's take into account that it will be necessary to add 1 to the number of months.

Sum the months 11 1 1 = 13.

It turned out more than 12 months. Since a full year is considered 12 months, subtract 12 from the number of months and add one to the number of years.

So, months will turn out 13 - 12 \u003d 1 month

Let's sum up the years: 11 4 1 = 16 years.

In total, the total length of service was 16 years 1 month 10 days.

As you can see, calculating the total length of service manually is quite time consuming, and it is easy to make a mistake.

CALCULATION OF EXPERIENCE

For counting work experience you can use different ways.

Each of them is convenient and has its own characteristics. Among them:

Calculation of periods of work (service, activity) is carried out in calendar order based on full months (30 days) and a full year (12 months). At the same time, every 30 days of these periods are converted into full months, and every 12 months of these periods are converted into full years (clause 2, section III of the Rules for calculating and confirming the insurance period).

If the periods of work (service, activity) included in the insurance period coincide in time, one of such periods is taken into account at the choice of the insured person, confirmed by an application that indicates the period chosen for inclusion in the insurance period (clause 22 of the Rules for calculating the insurance period) .