The result is how much PTO has been accrued in the pay period. The result is 84.00, which is the percentage of correct answers on the test.

With 0.08 as your multiplier, you can enter the days worked in the pay period and multiply them by 0.08. Select the cell that contains the result from step 2. This means that for every day worked, the employee accrues 0.08 days off. If it is accrued hourly, you first need to divide the total number of vacation hours that they are entitled to in a year by the number of working days in the year.įor example, if an employee works 30 hours per week and there are 365 working days in the year, divide 30 by 365. If your employees are entitled to paid time off, then you likely have a system for accruing vacation time for every day or hour worked. To find net pay, subtract what is in the cell for total deductions from the cell with gross pay. You can do the same for any other deductions and then add them together to calculate total deductions. Subtracting percentages from a number in Excel is a little different than subtracting two whole numbers or decimals. This can be done by subtracting 100 percent (the starting percentage of your number before it is subtracted) with the subtractor percentage. For example, if you have gross earnings of $550 in column A1, and the income tax that must be deducted is 12%, you can enter =(A1)*0.12 in the cell that you would like the deduction to appear in. Deductions like income tax or health benefits can be calculated by subtracting their percentage from gross earnings.

Subtracting percentages excel