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.

Overtime pay is the additional pay an employee receives for working beyond their regular hours in a work week, usually beyond 40 hours. This additional pay is typically calculated as one and a half ...