Hours Worked Tracker & Timesheet | Excel Spreadsheet Template

Stop adding up hours by hand - log each shift and let the spreadsheet do the math.

This hours worked tracker is an Excel spreadsheet template and weekly timesheet: type the start time, end time and break for each shift, and it calculates hours, pay and overtime for every person automatically.

WHAT'S INCLUDED

• Time Log (400 rows): date, person, client/project, start time, end time, unpaid break minutes - hours, hourly rate and pay calculate automatically (overnight shifts work too)• Weekly Timesheet: pick any week start date and see Mon-Sun hours, total, regular hours, overtime and gross pay for each person• Settings: up to 15 people with hourly rates, your overtime threshold (e.g. 40 hours/week) and multiplier (e.g. 1.5x), up to 12 clients/projects• Dashboard: total hours, total pay, shifts logged, average shift, this week's hours and overtime, charts by person and by project

BEST FOR

Small business owners with a few hourly staff, freelancers and contractors tracking billable hours, and employees who want to check their own hours and paycheck.

HOW IT WORKS

1. Add people, hourly rates and your overtime rule in Settings2. Log one row per shift with start and end time3. Open Weekly Timesheet for the week's hours, overtime and pay

IMPORTANT

Gross pay estimate only - not payroll, tax or legal advice. Check the overtime rules where you work.

FORMAT / DELIVERY

• Microsoft Excel (.xlsx) - also opens in Google Sheets (no macros)• Sample data included so you can see how it works• Instant digital download - no physical item

Questions? Message me any time. 30-day money-back guarantee.

FAQ

What exactly do I get?

Spreadsheet to track hours worked: log start/end times and breaks; get hours, pay, overtime and a weekly Mon-Sun timesheet per person.

What do I need to use it?

Microsoft Excel on Windows or Mac (Excel 2016 or newer, or Microsoft 365). It also opens in free Google Sheets, though Excel is recommended.

How do I get it?

It is an instant digital download: right after payment you get the file on the page and by email. No physical item is shipped.

What if it is not right for me?

Contact me through my Payhip store within 30 days and I will refund you - no hard feelings.

I have a question

Use the contact link on my Payhip store page and I will help.