Excel Timesheet & Payroll Builder

I need a single Excel workbook that lets me enter clock-in and clock-out times for each employee and have the sheet instantly calculate their regular hours as well as any overtime they rack up. The file also has to let me store different hourly rates per person so the totals update automatically when rates vary from one employee to the next.

A clean summary page pulling daily, weekly, and monthly totals would be ideal, but the core requirement is the automated maths: I do not want to touch a calculator or rewrite formulas every pay period. If macros or Power Query make the workflow smoother, feel free to use them—just keep everything contained in the workbook so I can hand it to my team without extra installs.

Deliverables
• An unlocked Excel file with formulas/macros already wired for automatic time and overtime calculations.
• Simple rate table I can edit for each employee.
• Quick instructions (one pager or inline notes) so anyone can add new staff or change pay periods without breaking the logic.

I’ll review by dropping in a week’s worth of test punches and confirming the hours and overtime match my manual figures. Let me know your turnaround time and any questions you have about formatting or local overtime rules, and we can get started right away.