How to Compute Annual Gross Pay in Excel. Annual gross pay is the amount of money an employee earns per year before deductions like state and federal taxes, 401(k) savings or health insurance ...

Type the formula to calculate the number of double time hours worked that day in cell B5. For example, suppose state law requires you to pay workers double time if they work more than 10 hours per ...