Duration converter

Convert time to decimal hours

7 hours 45 minutes = 7.75 hours. Enter a duration such as 7:45, or paste a whole column and copy decimal hours into your spreadsheet.

Batch paste and copy
No input data uploaded
Handles 24+ hour durations

Single conversion

Duration

Try H:MM, H:MM:SS, 2h 45m, or 165 min.

Display precision

This changes display only—not the source duration or a workplace rule.

Decimal hours

Your result will appear here.

Convert a pasted list

Paste one duration per line. Valid rows keep their order; a bad row never blocks the others.

Up to 1,000 non-empty rows

Durations, one per line

Nothing pasted here is uploaded or stored.

The calculation

How to convert minutes to decimal hours

Keep the hours: 7 hours.
Divide the minutes by 60: 45 ÷ 60 = 0.75.
Add them together: 7 + 0.75 = 7.75 hours. If your duration includes seconds, add seconds divided by 3,600.

decimal hours = hours + minutes ÷ 60 + seconds ÷ 3,600

For 2:45, the calculation is 2 + 45 ÷ 60 = 2.75. Minutes use sixty parts per hour, so 2 hours 45 minutes is not 2.45 hours.

2:45 → 2.75

Forty-five minutes is three quarters of an hour, or 0.75.

0:30 → 0.50

Thirty minutes is one half of an hour. At two places, it displays as 0.50.

40:30 → 40.50

This tool treats values as durations, so hours never wrap after 24.

Spreadsheet formulas

Convert time to decimal hours in Excel or Google Sheets

Duration in one cell

=A2*24

Use when A2 is a numeric spreadsheet time or duration, not text. A duration of 7:45 becomes 7.75. Format the result as a Number, not as a time.

Separate hours, minutes, and seconds

=A2+B2/60+C2/3600

Put numeric hours in A2, minutes in B2, and seconds in C2. For hours and minutes only, use =A2+B2/60.

For durations over 24 hours, display the source duration with [h]:mm:ss (or Format → Number → Duration in Google Sheets). A duration of 40:30:00 converts to 40.5. Use your spreadsheet locale's decimal separator when entering numbers.

Precision

Display rounding is not a time policy

Some fractions repeat in decimal notation. One minute is 1/60 of an hour, approximately 0.016666…. The calculator keeps the source duration unchanged and rounds only the displayed decimal to the precision you select.

A workplace, client, payroll system, or contract may have separate rules about which time counts or how recorded time is rounded. This format converter does not choose or apply those rules.

Related tools