Billable Hours Conversion Worksheet: Minutes to Decimal Hours for Law Firm Billing

Overview

To convert recorded time into billable hours, divide the minutes of eligible recorded work by 60, then apply the billing policy approved for that matter. Keep the actual time record separate from any rounding, write-down, or other adjustment so the reviewer can explain how the invoice was calculated.

A conversion worksheet is useful because clock notation and decimal hours are not interchangeable. Forty-five minutes is 0.75 hours, not 0.45 hours. A correct calculation still does not establish whether an activity should be charged: eligibility, rates, client terms, and applicable professional rules need their own review.

Separate recorded time from chargeable time

Recorded time describes what happened. Billable time describes the portion the firm intends to charge after checking the work, matter, client arrangements, and review decisions. Administrative work may be tracked for operational reporting without being included on a client invoice. Conversely, eligible work can be written down during review without deleting the underlying time record.

For every entry, retain the matter, person, date, activity description, and actual duration. If an entry is adjusted, record the reason and reviewer rather than silently replacing the original. This makes it easier to investigate a correction, explain a prebill decision, and distinguish a recording error from a commercial adjustment.

Before including time in the calculation, check:

• The activity belongs to the correct client and matter.

• The description explains the work without unnecessary sensitive detail.

• The duration reflects the work performed and does not duplicate another entry.

• The applicable rate and chargeability decision have been confirmed.

Convert minutes into decimal hours

The calculation is simple: decimal hours equal recorded minutes divided by 60. For work spanning more than one hour, add the complete hours to the remaining minutes divided by 60. One hour and 18 minutes is therefore 1 + 18/60 = 1.30 hours.

Some durations produce repeating decimals. Four minutes is approximately 0.0667 hours. Keep enough precision in the underlying calculation and distinguish a display rounded to two decimal places from a rule that changes chargeable time. A spreadsheet can display fewer decimals while retaining a more precise value, so compare the stored value and the invoicing result.

Keep billing increments separate from conversion

A tenth of an hour represents six minutes; a quarter of an hour represents 15 minutes. These are units of time, not automatic permission to increase an entry. Converting four minutes into hours does not, by itself, justify charging six or 15 minutes.

Decide which documented policy applies before configuring an increment. Check the engagement terms, client billing requirements, and applicable jurisdictional rules. Also decide whether an approved adjustment is applied to an individual activity or to an aggregated period; those approaches can produce different totals. Do not choose whichever method produces the largest invoice.

For US context, ABA Model Rule 1.5 addresses fee reasonableness and communicating the basis or rate of charges. It is a model rule, not a universal billing-increment standard; applicable local rules may differ. This guide explains arithmetic and workflow, not legal advice or a recommendation to round time upward.

Use a worked calculation and a copyable worksheet

Consider an illustrative matter with 18 minutes of document review, 12 minutes of a client call, and 24 minutes of drafting. Assume all three activities are approved as chargeable, use the same illustrative hourly rate of 300 currency units, and require no time adjustment. The total is 54 minutes, or 0.90 hours, producing a time fee of 270 currency units before expenses or taxes.

Copy the following worksheet into your own spreadsheet. Replace the sample inputs with reviewed records, and calculate decimal hours from minutes rather than typing a rounded result by hand.

In a spreadsheet, put approved minutes in a numeric input cell and divide that cell by 60 in the hours cell. Multiply the hours cell by the numeric hourly-rate cell for the fee. Keep expenses, tax, credits, and other invoice items outside this time-only calculation. When different timekeepers or rates apply, calculate each approved amount separately before adding the monetary results.

Review the prebill before invoicing

A worksheet should support the source system, not become an untraceable second set of records. Match the worksheet to approved time entries and investigate any difference before posting an invoice. Check whether the export includes written-down time, whether rates changed during the period, and whether displayed decimals are masking a different stored value.

Use this final review checklist:

• Match each worksheet line to its source entry and matter.

• Check rate changes, duplicate time, overlapping activities, and exclusions.

• Document the reason for each adjustment without changing the source history silently.

• Reconcile the approved time fee to the invoice, keeping other charges separate.

If a spreadsheet result differs from the prebill, identify the cause rather than forcing the numbers to agree. An excluded activity, rate override, or time adjustment is a different issue from a minutes-to-hours error. Assign someone to resolve the exception and keep the review decision with the matter.

Connect the calculation to legal operations

Calculation is one part of the journey from a time record to a reviewed invoice. The legal time and billing software guide explains that wider connection, while the legal billing automation guide covers the review-to-invoice workflow.

For a MATTEROOM demonstration, bring a synthetic matter containing different timekeepers, rates, and one disputed entry. Ask the team to show the relevant configuration, review trail, and invoice result. Use the time, billing, and accounting overview to identify the product discussion; do not assume that a worksheet example describes a default software setting.