How to Calculate Hours Worked in Excel 2007
How to calculate the worked period
You will need
- - employment history;
- - calculator or 1C program.
To calculate the working period for the accrual of sick leave or other social benefits, count the total work experience for all records in the workbook. To do this, from the date of dismissal of each record subtract the date of the device to work. Add all the numbers you have received, round to full years, months and days. Each year, count on the basis of 12 months, a month - based on 30 days. With the length of service of 8 years, charge 100% of average earnings, from 5 to 8 years - 80%, up to 5 years - 60%.
To calculate the worked period to determine the number of days of additional leave, subtract from the date of granting leave the date of employment for hazardous, dangerous or difficult production. Round up the resulting number to full years. When calculating additional holidays, do not take into account the number of months and days. Every whole year multiply by 1 and the average daily earnings for the 12 months preceding payment.
To calculate the time spent to pay compensation for unused vacation, from the date of dismissal subtract the date of employment. For each month that has been worked for more than 15 days, accrue vacation pay, as for a fully worked month, less than 15 days - not payable compensation. To pay compensation, divide 28 by 12, multiply by the calculated number of months and by the average daily earnings for 12 months or for the actual working period, if the experience of 12 months is not worked out.
To calculate the worked period for the accrual of early retirement, subtract from the date of calculation the date of employment or transfer to a harmful enterprise, the work on which is counted in the experience of harmfulness for the accrual of early retirement.
To calculate the time spent for the calculation of the old-age pension, calculate all the records in the employee’s workbook, taking the employment date away from the date of dismissal from each enterprise. Add up the numbers, round up to full years.
Video: Excel Magic Trick 718: Calculate Hours Worked (Day or Night Shift) & Subtract Lunch
How Do You Calculate Average Hours Worked?
Related newsWhat female professions are always in demand
Как можно дома заработать денег в 2019 году
How to choose a cork adhesive
Hairdryer VITEK - a great gift for your girlfriend
How to make sour cream in 2019
Сонник: к чему снится ссора с мужем
Could there be a big breakdown a month after strong emotional experiences?
How to cook apple marmalade
How to wean a kitten from breastfeeding