Weekly timesheet template
By Fred Wu, maker of Hourbun · Checked · Report a mistake
The short answer
Enter a row for each client and project, and the hours of each day as 1.5 or 1:30. The sheet adds up each row, each day and the week, in hours and minutes and in decimal hours. Print it as a PDF, or download a CSV file that Hourbun imports. It runs in your browser: nothing you type is sent or stored.
How it works
How to fill in a timesheet
- Name the week. Enter your name and a date of the week, and choose whether the week starts on Monday or on Sunday.
- Add a row for each piece of work. Enter the client, the project, a task and a note if you want them, and whether the time is billable.
- Enter the hours of each day as decimal hours (1.5 or 1,5) or as hours and minutes (1:30). A cell holds up to 24 hours, and the sheet keeps each cell to the hundredth of an hour, as Hourbun does: 0:20 is 0.33 hours.
- Check the totals. Each row, each day and the week show in hours and minutes and in decimal hours. The total in hours and minutes adds the whole minutes of each cell, so three cells of 0:20 make 1:00, and 0.99 in decimal hours.
- Print it or download the CSV. Print gives a landscape sheet, and the print dialog of your browser saves it as a PDF. An empty sheet prints as a blank template. The CSV has a row for each day with hours, and needs a client and a project on each row.
To turn minutes into decimal hours, divide them by 60: 15 minutes is 0.25 hours, 20 minutes is 0.33 hours and 45 minutes is 0.75 hours.
A worked example
A day of four entries, as you would type them in the cells of one day:
- 1:30
- 1.50 h
- 0:20
- 0.33 h
- 0:20
- 0.33 h
- 0:20
- 0.33 h
The day: 2:30 in hours and minutes, or 2.49 hours.
The decimal total adds the hundredths of the cells. The total in hours and minutes adds their whole minutes, so the two can differ by a minute or a hundredth.
Convert hours and minutes
To add up a list of times, or for more tables, use the time to decimal hours converter.
Minutes to decimal hours
Each minute of an hour in decimal hours, rounded to the hundredth as Hourbun rounds it.
| Minutes | Hours |
|---|---|
| 1 | 0.02 |
| 2 | 0.03 |
| 3 | 0.05 |
| 4 | 0.07 |
| 5 | 0.08 |
| 6 | 0.10 |
| 7 | 0.12 |
| 8 | 0.13 |
| 9 | 0.15 |
| 10 | 0.17 |
| 11 | 0.18 |
| 12 | 0.20 |
| 13 | 0.22 |
| 14 | 0.23 |
| 15 | 0.25 |
| Minutes | Hours |
|---|---|
| 16 | 0.27 |
| 17 | 0.28 |
| 18 | 0.30 |
| 19 | 0.32 |
| 20 | 0.33 |
| 21 | 0.35 |
| 22 | 0.37 |
| 23 | 0.38 |
| 24 | 0.40 |
| 25 | 0.42 |
| 26 | 0.43 |
| 27 | 0.45 |
| 28 | 0.47 |
| 29 | 0.48 |
| 30 | 0.50 |
| Minutes | Hours |
|---|---|
| 31 | 0.52 |
| 32 | 0.53 |
| 33 | 0.55 |
| 34 | 0.57 |
| 35 | 0.58 |
| 36 | 0.60 |
| 37 | 0.62 |
| 38 | 0.63 |
| 39 | 0.65 |
| 40 | 0.67 |
| 41 | 0.68 |
| 42 | 0.70 |
| 43 | 0.72 |
| 44 | 0.73 |
| 45 | 0.75 |
| Minutes | Hours |
|---|---|
| 46 | 0.77 |
| 47 | 0.78 |
| 48 | 0.80 |
| 49 | 0.82 |
| 50 | 0.83 |
| 51 | 0.85 |
| 52 | 0.87 |
| 53 | 0.88 |
| 54 | 0.90 |
| 55 | 0.92 |
| 56 | 0.93 |
| 57 | 0.95 |
| 58 | 0.97 |
| 59 | 0.98 |
| 60 | 1.00 |
Do this in Hourbun
Track the week in Hourbun
Hourbun is time tracking and invoicing for freelancers and small teams. Try it for 14 days, with no card.
- Track the week as you work. Start a timer on a task with Start timer, or fill in the Week view: a row for each project and task, and a cell for each day, with hours as 1.5 or 1:30.
- Import this sheet. An owner or an admin opens Settings, then Import, chooses Another app (CSV) and uploads the CSV: Hourbun proposes a column for each field and shows a preview first. The people step matches each person of the file to a teammate. A file of one person is the time of whoever imports it, so choose the teammate there when the sheet is someone else's.
- Approve the week. On the Team plan, a teammate sends the week with Submit week, and a manager of the project, an admin or the owner approves it.
- Invoice the hours. Turn the billable hours of the week into an invoice at the rates of the task, the project or the client.
Questions
Questions and answers
How do I convert minutes to decimal hours?
Divide the minutes by 60. 15 minutes is 0.25 hours, 30 minutes is 0.5 and 45 minutes is 0.75, so 7 hours and 45 minutes is 7.75 hours. The table on this page has each minute of an hour, rounded to the hundredth as Hourbun rounds it.
Why do the two totals differ a little?
The sheet keeps each cell to the hundredth of an hour, so 0:20 is 0.33 hours. The decimal total adds those hundredths, and the total in hours and minutes adds the whole minutes of each cell: three cells of 0:20 are 0.99 hours and 1:00. Hourbun adds up its totals the same way.
Does this timesheet calculate overtime?
No. Overtime rules come from employment law and contracts, and they differ by country, so this sheet only adds up hours. Hourbun is for freelancers and small teams who bill clients for their time, not for payroll.
Can I open the CSV in Excel or Google Sheets?
Yes. The file is UTF-8, with a row for each day with hours under the headers Date, Person, Client, Project, Task, Notes, Hours and Billable, with dates as 2026-11-16 and decimal hours. Excel, Numbers and Google Sheets open it. A text that starts with =, +, - or @ gets a ' in front, so that a spreadsheet does not run it as a formula.
Is this timesheet free and private?
Yes. It is free, needs no account, and runs in your browser: nothing you type is sent to Hourbun or stored, not even in your browser. Your sheet is gone when you close or reload the page, so print it or download the CSV first.
Free, no sign-up