A program that counts work experience online. Online work experience calculator - calculation according to the work book. What is meant by work experience?

Self-calculation of your own work experience can take quite a long time. Fortunately, there are programs that can cope with this task and produce the desired result in a matter of seconds. One of them is the Calculation of seniority, which will be discussed in more detail in this article.

The calculation of the length of service, based on the date of admission and dismissal, will quickly calculate the length of the working period at a particular enterprise. The program can also calculate the total and longest continuous experience, it is enough to specify several working terms. If any date was entered incorrectly, it can be removed from the list.

Import and export

The program makes it possible to export the specified data to a separate file with the STJ extension. It will be saved in the location specified by the user. If you need to work with the saved data again, you can easily import it back into the Seniority Calculation.

Printing a Document

If there is a need to print out the specified data, the Seniority Calculation provides such an opportunity to the user. The sheet will indicate the name of the program, as well as all the information, including total and continuous work experience.

Advantages

Russian-language interface;
Free distribution;
Availability of information on general and continuous experience;
Ability to import and export data;
Printout of entered information.

Flaws

The program does not take into account the day of dismissal in the working period.

Seniority Calculation is a great program that can quickly give you the amount of seniority based only on the entered date of hire and dismissal. In addition, it makes it possible to save the specified data, as well as print them. At the same time, she loses one day in the calculations from each period, therefore, after the calculation, add the required number of them yourself.

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 calculating the length of service. 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. 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.

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 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 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 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, 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.

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 the periods of work in chronological order on a separate sheet of paper. 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. Similarly, follow the work book if you determine the duration of work in your 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 is employed under an employment contract...

Two ways to calculate seniority with examples

If the result of the calculation is a negative number of 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 a positive value of days and months is obtained

Example when days are negative

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.

Seniority is a period of socially useful activity, work, study of an employee. The length of service is divided into subspecies: insurance, special (preferential) and continuous (this concept has been abolished). The length of service is used to calculate sick leave, pensions and other social benefits.

Periods for calculating the length of service (insurance) employee

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

period of military service;
caring for a child up to 1.5 years (if there are several periods, then the maximum period is 4.5 years);
a period of temporary disability with a sick leave (see →);
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 of the calculation of the insurance period is the occupation of the type of activity that pays insurance premiums to the FIU. It does not have to be an organization, as an individual entrepreneur independently transfers funds to the FIU. The time of study in educational institutions, graduate school, courses is not included in the insurance experience, because. 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.

It might be useful to read: