Billable hours calculator
Paste or upload your timesheet to calculate billable hours. Already use TimeRetain? Open TimeRetain to keep billable totals with your time record.
Load an example
Your data stays in this browser. Double-check any numbers before acting on the result.
Timesheet total
- Billable time
- 0h
- Non-billable time
- 0h
- Billable amount
- 0
Only the first 5,000 rows were checked.
Detected columns: . Open Options if a column is wrong.
Options
Set the start and end columns. If you recorded hours only, pick that column as Hours. Rate and currency are optional.
A preview of the first rows. Use it to check the columns you picked.
Time columns
Rates and currency
Used when there is no rate column. Leave this field empty for hours only.
Track hours as you work. Export a CSV when you invoice.
How the calculation works
Your client agreement decides what is billable. The calculator applies these rules to the rows you provide:
| Result | Calculation |
|---|---|
| Worked time | end time − start time, or the Hours value |
| Billable time | worked time on rows with a positive rate |
| Non-billable time | worked time on rows with an empty or zero rate |
| Billable amount | billable time × the rate for each row |
If the file has no rate column, readable rows count as billable time. Add one rate for every row in Options if you also want a billable amount.
If a row ends at or before its start time, the calculator treats it as overnight. For example, 22:00 to 02:00 is 4 hours.
You can change empty rates, zero rates, and decimal hours in Options. You can also check the detected Start time, End time, Hours, Rate, and Currency columns there.
Rounding
Some contracts bill time in 6- or 15-minute blocks. This calculator uses each duration exactly as entered. It does not round your time.
Keep the stored start and end times unchanged. Apply the contract’s rounding rule when you create the invoice. Timesheet rounding explains why rounding a duration is different from changing its start and end times.
Use a tracker before the next invoice
This calculator totals time you have already recorded. For new work, start a timer when you begin.
TimeRetain keeps billable totals with your time record. Its timers are manual: you choose when tracking starts and stops. You can edit every entry, keep client rates with the work, and export a CSV when you invoice. Your time stays on your device unless you enable optional encrypted sync.
Questions and Answers
How do you calculate billable hours?
Find the worked time for each row, then apply the billing rule from your client agreement. This calculator treats a row with a positive rate as billable and, by default, treats an empty or zero rate as non-billable.
Does this calculator upload my spreadsheet?
No. The calculator reads the file in your browser. Nothing is sent to a server, and the rows are gone when you close the tab.
What if I only have an hours column?
Set that column as Hours and leave Start time and End time as None. Values such as 7.5, 8, and 6.25 are enough.
Can a billable hours calculator replace a time tracker?
No. A calculator checks rows that already exist. A manual time tracker records the start and stop times as you work, lets you correct the record, and keeps it ready for the next invoice.