Free daily time clock sheet (Excel)
Record start time, finish time, and breaks for each day worked. Calculates total hours automatically. Perfect for businesses that need to track exact clock-in and clock-out times.
Daily time clock sheet
Excel format (.xlsx)
No signup required. Works with Excel and Google Sheets.
What's in this template
A detailed daily time tracking layout
Employee name
Full name of each staff member
Date
The date being recorded
Start time
Clock-in time for the shift
Finish time
Clock-out time for the shift
Break (minutes)
Unpaid break duration
Total hours
Calculated hours worked
How time is recorded
Enter start and finish times for each day. Add break minutes to deduct from total hours. The template calculates net hours worked automatically.
| Employee | Date | Start | Finish | Break | Hours |
|---|---|---|---|---|---|
| Sarah Jones | 20/01/2025 | 09:00 | 17:30 | 30 min | 8.0 |
| James Smith | 20/01/2025 | 14:00 | 22:00 | 30 min | 7.5 |
How to use this template
Get started in four simple steps
Download
Get the Excel file and open it
Add details
Enter employee names and dates
Record times
Enter start, finish, and breaks
Export for payroll
Send to payroll or keep for records
Who uses this template
Ideal for businesses tracking exact clock times
Template disclaimer
This template tracks time and attendance only. It does not calculate wages, penalties, or entitlements. For automated calculations and compliance support, use time and attendance software.
When spreadsheets stop working
Manual time sheets work for small teams. But as you grow, chasing paper, fixing errors, and calculating hours becomes painful. For automatic clock-ins via mobile or tablet with GPS verification, try time and attendance software.
Explore time & attendance softwareDaily time clock sheet FAQ
- The template calculates total hours by subtracting the start time from the finish time, then deducting any break minutes entered. The result is shown as decimal hours (e.g., 7.5 for 7 hours 30 minutes).
- Yes, simply add a new row for each day worked. You can track an entire week or month for one employee by adding multiple rows with different dates.
- No, this template tracks hours only. It does not calculate wages, penalties, or entitlements. For automated pay calculations, consider time and attendance software.
- Enter times in 24-hour format (e.g., 09:00 for 9am, 17:30 for 5:30pm) or 12-hour format with AM/PM. The template will calculate hours based on the times entered.
- Basic overnight shifts can be tracked, but for complex scenarios spanning midnight, you may need to split into two entries or use time and attendance software.
Related templates
Explore more time tracking templates
Ready to track clock times?
Download the template now and start recording employee times.
Disclaimer
This template tracks time and attendance only. It does not calculate wages, penalties, or entitlements. RosterElf Pty Ltd accepts no liability for any loss arising from reliance on this template. For automated calculations and compliance support, use time and attendance software.