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.