Billable Hours with Different Rates

Calculate using the labelled inputs: Billable Hours with Different Rates.

Total billable hours
32
Invoice, sum of rounded rows
4800.00
Billable share of worked time (%)
80
Invoice per billable hour, rounded
150.00
Number of rows
1

Calculation and assumptions

row_amount=round(hours·rate,2); invoice=Σrow_amount; utilization=100·billable_hours/worked_hours; average_rate=round(invoice/billable_hours,2).

Use decimal hours with up to six decimals, rates with two; spaces between columns. Each row rounds to cents, halves away from zero, before summing. Enter worked hours for the same period; positive worked time must cover all billable hours. Zero worked hours means unknown and gives a dash for utilization. Zero billable hours gives a dash for average rate. No overtime, payroll deductions or tax is inferred. In one chosen two-decimal currency; no taxes or current market rates are supplied.

Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Frequently asked questions

How is the result calculated?

row_amount=round(hours·rate,2); invoice=Σrow_amount; utilization=100·billable_hours/worked_hours; average_rate=round(invoice/billable_hours,2).

What assumptions apply?

Use decimal hours with up to six decimals, rates with two; spaces between columns. Each row rounds to cents, halves away from zero, before summing. Enter worked hours for the same period; positive worked time must cover all billable hours. Zero worked hours means unknown and gives a dash for utilization. Zero billable hours gives a dash for average rate. No overtime, payroll deductions or tax is inferred. In one chosen two-decimal currency; no taxes or current market rates are supplied.

How precise are the results?

Monetary totals use two decimal places with the stated rounding rule; other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Also try:

Back to category →