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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |