Free daily timesheet template
For a day that is not one shift: an early job, a second site, an afternoon somewhere else. Each part gets its own line, and the day adds itself up.
| Job or task | Location | Start | Finish | Unpaid break (minutes) | Hours |
|---|---|---|---|---|---|
| Office clean | Parkview Medical, Suite 4 | 05:30 | 07:30 | 0 | 2.00 |
| Office clean | Kent Street Offices, Level 2 | 08:00 | 10:00 | 0 | 2.00 |
| Window touch-ups | Kent Street Offices, foyer | 10:00 | 11:15 | 0 | 1.25 |
| Gym clean | Harbour Gym | 16:00 | 18:30 | 15 | 2.25 |
What is in the file
- Template, blank, with 10 rows under job or task, location, start and the rest.
- Example, the same sheet filled in for Aroha Ngata.
- How to use, with the steps and the mistakes below.
The hours column is a formula, not a number typed in. It takes the finish from the start, counts a shift that runs past midnight correctly, and takes off the unpaid break.
How to fill it in
- Write a line for each job or shift in the day, in the order they happened.
- Put the location for each one, even when it is the same place twice.
- Give travel between jobs its own line if your business records it.
- Check the total at the bottom before signing the day off.
Common mistakes
- Travel time folded into a job’s start and finish
- Two overlapping lines, which count the same half hour twice
- A day signed off without comparing the jobs with the roster
When a spreadsheet stops being enough
In Roster Flow staff clock in at each venue as they arrive, and a second shift in a day is a record of its own.
Questions
What is on the daily timesheet template?
6 columns: job or task, location, start, finish, and 2 more. The blank sheet gives you 10 rows, and the example is the same grid filled in for Aroha Ngata: several shifts or jobs in one day, each with its own times.
Does the daily timesheet template work out the hours?
Yes. Hours is a formula, not a number typed in: it takes the finish from the start, counts a shift that runs past midnight correctly, and takes the unpaid break off. Type a start and a finish and the hours follow.
Can I use the daily timesheet template in Google Sheets?
Yes. Open daily-timesheet.xlsx from Google Drive, or use File, then Import, then Upload with daily-timesheet.csv. The grid and its example come across either way.
Do I need an account to download the daily timesheet template?
No. daily-timesheet.xlsx, daily-timesheet.csv and daily-timesheet.pdf are plain links. There is no sign up, no email address asked for, and nothing to install.