About this document
Excel Salary and Overtime Calculation Guide by Roxanne Cruz is a document available to read on EtoBox.
The document provides directions for using Microsoft Excel to calculate salary and overtime pay for employees based on their hourly rates and timesheets for a week. It involves creating a spreadsheet with labels for employee name, hourly rate, work days of the week and hours worked. It then has steps to calculate total hours worked, regular hours, overtime hours, regular pay, overtime pay (at 1.25 times hourly rate) and total pay through formulas. The filled out spreadsheet would show the weekly salary comp
- Author
- Roxanne Cruz
- Language
- EN