Follow along in this step-by-step guide to learn how to easily calculate hours worked in Microsoft Excel.

This calculates the amount of overtime pay, if any. In the example, this would calculate 8 hours of overtime pay. Enter "=A5+A4" in cell A6 to add regular and overtime pay.