Timesheet: add up your hours and estimate your fee
Add up your work time and estimate the fee
Result
Add your first entry to see totals.
How the fee is worked out
A 90-minute entry at 80.00 an hour is 120.00. A 200-minute entry at 85.00 is 283.33. The fee uses exact minutes, then rounds half away from zero to the cent.
Billable and non-billable time
A 30-minute entry that is not billable adds 0:30 to non-billable time and 0.00 to the fee. The billable total stays 120.00 when that entry is added to 90 minutes at 80.00.
Why totals can differ by a cent
Three entries of 20 minutes at 100.00 are 33.33 each, so the total is 99.99. One entry of 60 minutes at 100.00 is 100.00. Each entry is rounded to the cent, then added.
Common mistakes
- Type hours and minutes in the two boxes. 1 and 30 means 1 hour 30 minutes.
- 1.30 and 1:30 are not accepted. Minutes above 59 are not carried over.
- Non-billable time still counts in the total hours. Its fee is 0.
Using your CSV
Export CSV downloads a file you can open in a spreadsheet. A leading apostrophe on a text cell stops the spreadsheet from treating that cell as a formula. Numbers in the file use a dot.
A note for Canadian businesses
This timesheet does not calculate overtime, wages, payroll, or tax. It estimates a fee from the hours and rates you type.
Questions
How do I convert minutes to decimal hours?
Divide the minutes by 60. 90 minutes is 1.50 hours. The fee uses the minutes, not the rounded decimal.
Does it have a timer?
No. Type the hours and minutes.
Can I keep several rates?
Yes. Each entry has its own hourly rate.
Does it include tax?
No.
How do I get the data out?
Export CSV, or copy the summary. The summary is the totals only, not the task names.
Why does the CSV show an apostrophe?
A leading apostrophe stops a spreadsheet from reading a task as a formula.
Do I need an account?
Saving needs a free account. Without one, your entries stay on this page.