Using Microsoft Excel, you can track your employee's wages using a formula. The most important formulas involve total hours worked, regular time hours worked, overtime hours worked and overtime pay.

Click cell "D1" and type "Total Hours." Press the "Enter" key. Click cell "D2" and type the total hours of the first employee. Continue entering each employee's total hours in column C. Click cell "E2 ...