Billable hours calculator
Paste your timesheet, or open a file on this device, to calculate billable hours. Already use TimeRetain? Open TimeRetain to keep billable totals with your time record.
Your inputs stay in this browser. Double-check any numbers before acting on the result.
Load an example
In an Hours column, 0.25 is 15 minutes. With a Rate column, blank or zero rates count as non-billable by default. Without one, every row with a readable duration counts. A blank row, or a row whose time can't be read, is left out.
Timesheet total
- Billable time
- 0h
- Non-billable time
- 0h
- Billable amount
- 0
Totals use whole minutes and can differ from a timesheet that includes seconds. The amount is meaningful only when all rates use one currency.
This total covers only the first 5,000 rows, not the whole sheet.
Detected columns: . Open Options if a column is wrong.
Options
Adjust the detected columns if needed. Rates 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.
Keep a record of client work for your next invoice.
Get a total from your timesheet
Paste your rows, or open a CSV or Excel file on this device. The calculator reads the file in your browser and doesn’t send your rows anywhere. It shows your billable hours. With rates in one currency, it also calculates the amount.
For example, 2.5 hours at $80 per hour gives $200. Another 1.5 hours at $100 adds $150, for four billable hours and $350.
In an Hours column, 0.25 means 15 minutes, and 1 means one hour.
Understand the result
When your sheet includes rates, rows with an empty or zero rate count as non-billable by default. Without a rate column, every row with a readable duration counts. A blank row, or a row whose time can’t be read, is left out.
Make the next invoice easier
This calculator totals time you have already recorded. For new work, a manual time tracker saves you from trying to remember Friday what happened on Monday.
With TimeRetain, you can keep each client’s hours together and review the work before you bill. You have the hours and notes to refer to when an invoice question comes up.
Questions and answers
How do you calculate billable hours?
With a Rate column, blank or zero rates count as non-billable by default. Without one, every row with a readable duration counts. A blank row, or a row whose time can't be read, is left out.
Does this calculator upload my spreadsheet?
No. The calculator reads the file in your browser and doesn't send your rows anywhere.
What if I only have an hours column?
Paste it, or open a file on this device. In an Hours column, 0.25 means 15 minutes, and 1 means one hour.
Can a billable hours calculator replace a time tracker?
No. This calculator totals rows you already recorded. A manual time tracker helps you capture work as it happens, so you have hours to review for the next invoice.