Hours & Pay

Decimal Hours Calculator & Bulk Timesheet Converter

Convert up to 500 time durations between hours:minutes and decimal hours. Get a total, check each row and export the conversion table as CSV.

Your inputs

Calculated on your device

Accepts up to 500 nonnegative durations. Decimal results show four places; hours:minutes rounds to the nearest minute. The total uses unrounded inputs, not the displayed rounded rows.

Formula and assumptions

Decimal hours = whole hours + minutes ÷ 60. In reverse, multiply decimal hours by 60 and round to the nearest minute for hours:minutes display. Sum original values before rounding the total.

Results depend on your inputs. Read the calculation methodology.

Worked example

7:30 + 8:15 + 6:45 = 7.5 + 8.25 + 6.75 = 22.5 decimal hours, or 22:30. Writing 7:30 as 7.30 would understate that row by 12 minutes.

Official reference

U.S. Department of Labor: hours worked

Understand the result

Related calculators

Keep time notation separate from decimal notation

A colon separates hours from minutes, which use a base of 60. A decimal point expresses a fraction of an hour. Use 7:45 for seven hours and forty-five minutes in the first mode, or 7.75 in decimal mode. The converter rejects invalid minute portions such as 7:75 instead of silently treating them as another format.

Reconcile rounding before uploading

Use the downloadable table to compare each source value with its converted value. Decimal rows display four places, while hours:minutes displays whole minutes. Totals are calculated from original inputs. An external payroll system may use a different rounding policy, so compare its import specification before using a rounded display as a final record.

Frequently asked questions

What is 7 hours 45 minutes in decimal hours?

7 + 45 ÷ 60 = 7.75 hours. It is not 7.45 hours.

Can I paste multiple rows?

Yes. Paste one duration per line, without headers, names or currency symbols. Select the format that matches every row. The current limit is 500 rows.

Why can the displayed rows differ slightly from the total?

Each displayed row may be rounded. The total adds the original values before rounding, avoiding accumulated display rounding.

Does conversion round clock punches?

No. It converts durations. It does not apply a nearest-quarter-hour rule to employee clock-in or clock-out times.

Continue with your own figures

Timesheet Rounding Checker and Bulk Time Converter — Paste up to 500 durations, convert H:MM or decimal hours, and compare rounding each row with rounding the total once.

Work through a specific example