How to use an Excel timesheet?
A quarter of businesses surveyed, use paper or spreadsheets to track employee time. Most of us know how to use Microsoft Excel. It’s a step up from printed paper timesheets.
There are easier and more accurate ways to track employee hours. If you’re set on using manual timesheets, it helps to know what you’re doing. For the spreadsheet enthusiast, we’ve designed a free Excel solution.
Step 1: Fill in the employee name, the manager, your company name, the pay period start date, the employee’s standard pay rate, and the overtime rate.
Step 2: Employees can fill in the day, date, job/shift, job/shift code, their time in/out (including breaks), and any remaining hours (overtime, sick leave and holidays).
Step 3: When it’s time to hand the timesheet in, employees sign the top of the form. Managers can then calculate the employee’s total time for payroll.