Short answer: Download the free Excel template below. Enter the week's start date, then each day's check-in time, check-out time and break minutes. The sheet works out each day's hours, the weekly total, regular hours and overtime. Shifts that run past midnight, such as 8:00 PM to 5:00 AM, are calculated correctly.
What it looks like
| Day | Check in | Check out | Break (min) | Hours |
|---|---|---|---|---|
| Monday | 8:00 PM | 5:00 AM | 60 | 8.00 |
| Tuesday | 8:00 PM | 5:00 AM | 60 | 8.00 |
| Wednesday | 9:00 AM | 6:00 PM | 30 | 8.50 |
| Thursday |
What is included
- Overnight shifts calculated correctly
- Breaks deducted automatically
- Weekly total, regular hours and overtime
- Optional pay estimate
- Employee and manager sign-off
- Opens in Excel, Google Sheets and LibreOffice
How to use it
- Fill in the company, employee, team and the date the week starts.
- Set the weekly regular-hours limit (40 by default) and, if you want a pay estimate, the hourly rate and overtime multiplier your policy uses.
- For each day, enter the check-in time, check-out time and break minutes. Leave days off empty.
- Read the totals at the bottom: total hours, regular hours, overtime and the optional pay estimate.
- Print or export it, then have the employee and the manager sign it off.
Download
Excel (.xlsx) · Printable PDF. Free to use, change and share.
Related
- Team Monitoring
- How to Manage an Amazon VA Team: KPIs, Check-ins, Time
- How to Monitor Remote E-commerce Teams Fairly
Link to this template
Writing about remote teams or Amazon operations? You are welcome to link to this page. Copy this HTML:
