Free time conversion tool · Excel-friendly

Hours to Decimal Calculator: Minutes Chart, Excel & Bulk Converter

Convert hours and minutes to decimal hours instantly. Convert back to hours and minutes, paste an Excel timesheet column, compare rounding methods, or print the full minutes-to-decimal chart. No account needed.

Quick answer: 8:30 = 8.50 hours · 8:20 = 8.33 hours · 7:45 = 7.75 hours.

A clock uses 60 minutes per hour, but decimal hours express that fraction in base 10. 8:30 is not 8.30 hours.

Reviewed: November 22, 2026Precision: exact seconds; 2- and 4-place resultsPrivacy: calculations run in your browser

Hours to Decimal Converter

Choose a mode below. All conversions treat time as a duration, not a time of day.

Use a colon. Values like 25:30 are allowed for weekly totals. Minutes and seconds must be 00–59.

Decimal hours · hundredths
8.50
Rounded to 2 places
Decimal hours · 4 places
8.5000
More precision for spreadsheets
Total minutes
510
Includes seconds as fractions

How to Convert Hours and Minutes to Decimal Hours

An hour contains 60 minutes, so the correct conversion divides the minute portion by 60 and adds it to the whole hours. Seconds are divided by 3,600. This is a numeric conversion, not a change to the length of an hour.

Decimal hours = hours + minutes / 60 + seconds / 3600

8 hours 30 minutes

8 + (30 ÷ 60) = 8.50 hours. Entering 8.30 instead would represent 8 hours 18 minutes.

8 hours 20 minutes

8 + (20 ÷ 60) = 8.3333… = 8.33 hours to 2 decimals.

7 hours 45 minutes

7 + (45 ÷ 60) = 7.75 hours. This converts cleanly without rounding.

37 hours 30 minutes

37 + (30 ÷ 60) = 37.50 hours. Durations above 24 hours are supported.

Clock notation vs decimal notation: 7:30 means 7 hours 30 minutes; 7.30 means 7.3 decimal hours, or 7 hours 18 minutes. The colon and decimal point are not interchangeable.

Minutes to Decimal Hours Chart (0–60 Minutes)

Use this printable minute conversion table for timesheets, billing or a quick lookup. Two-decimal values are rounded to the nearest hundredth of an hour; four-decimal values preserve more detail. 60 minutes = 1.00 hour.

Minute-to-decimal conversion: minute ÷ 60
MinutesDecimal (2)Decimal (4)MinutesDecimal (2)Decimal (4)
00.000.0000310.520.5167
10.020.0167320.530.5333
20.030.0333330.550.5500
30.050.0500340.570.5667
40.070.0667350.580.5833
50.080.0833360.600.6000
60.100.1000370.620.6167
70.120.1167380.630.6333
80.130.1333390.650.6500
90.150.1500400.670.6667
100.170.1667410.680.6833
110.180.1833420.700.7000
120.200.2000430.720.7167
130.220.2167440.730.7333
140.230.2333450.750.7500
150.250.2500460.770.7667
160.270.2667470.780.7833
170.280.2833480.800.8000
180.300.3000490.820.8167
190.320.3167500.830.8333
200.330.3333510.850.8500
210.350.3500520.870.8667
220.370.3667530.880.8833
230.380.3833540.900.9000
240.400.4000550.920.9167
250.420.4167560.930.9333
260.430.4333570.950.9500
270.450.4500580.970.9667
280.470.4667590.980.9833
290.480.4833601.001.0000
300.500.5000———

Rounding a single minute to 0.02 hours is a display convention; it does not change the underlying minute. When accuracy matters, add durations before rounding the final total or follow your system’s documented rules.

How to Convert Time to Decimal Hours in Excel and Google Sheets

Excel and Google Sheets generally store time and durations as fractions of a day. If A2 contains a genuine time or duration value such as 8:30, multiplying by 24 returns decimal hours. Format the result cell as a regular number.

TaskFormulaExplanation
Time or duration in A2 → decimal hours=A2*24An Excel duration of 8:30 becomes 8.5 hours.
Hours in A2, minutes in B2, seconds in C2=A2+B2/60+C2/3600Works with separate number columns.
Decimal hours in A2 → spreadsheet duration=A2/24Apply custom number format [h]:mm to display totals above 24 hours.
Round decimal hours to hundredths=ROUND(A2*24,2)Rounds each row. Only do this when your workflow calls for row-level rounding.
Sum recorded durations, then convert=SUM(A2:A8)*24Avoids accumulating row-by-row display rounding.
Start A2 / end B2, with overnight shift=MOD(B2-A2,1)*24For clock times spanning less than 24 hours; not a substitute for dated punches or break handling.

Why does Excel show 0.3541667 instead of 8:30?

Because 8 hours 30 minutes is 8.5/24 of a day. Change the cell format to [h]:mm to display a duration, or multiply the cell by 24 and apply a Number format to see 8.50. An Excel value pasted as a bare number such as 0.3541667 is not automatically treated as a time duration by this tool’s bulk converter.

Official references: Microsoft: Convert times · Microsoft: Custom number formats · Google Sheets: Number and duration formats.

Advertisements

Why Bulk Timesheet Totals Can Differ by 0.01 Hours

Hundredths of an hour are increments of 36 seconds. A duration such as 8:20 equals 8.3333… decimal hours, usually displayed as 8.33. If three rows each contain 8:20, summing the displayed rounded values produces 24.99 hours. Adding all actual durations first gives exactly 25 hours, displayed as 25.00 hours.

MethodThree rows of 8:20Result
Round each row first8.33 + 8.33 + 8.3324.99
Add exact durations first8:20 + 8:20 + 8:20 = 25:0025.00

Neither display method should be presented as a universal payroll policy. For a company workflow, follow the employer’s timekeeping rules and the receiving system’s rounding behavior. This converter does not round actual clock-in or clock-out punches to 5-, 6- or 15-minute increments. That is a different operation.

When to Use This Converter Instead of a Time Card Calculator

Use this page when you already know a duration—such as 7:45, 90 minutes or an Excel column—and need the equivalent decimal number. It does not calculate shift lengths from start/end timestamps, subtract breaks, or determine overtime.

Already have work durations?

Convert them here, review any ambiguous entries, and copy the validated decimal values.

Have clock-in and clock-out times?

Use the Time Card Calculator for schedules, breaks and overnight shifts.

Planning time across days?

Try the US Business Days Calculator for workday dates rather than hour conversions.

Advertisements

Hours to Decimal Calculator: Frequently Asked Questions

What is 8 hours 30 minutes in decimal?

8.50 hours. Divide 30 minutes by 60 to get 0.50, then add 8.

What is 8 hours 20 minutes in decimal hours?

8.3333… hours, normally shown as 8.33 to two decimal places. The repeating fraction matters when summing many rows.

What is 20 minutes in decimal hours?

20 ÷ 60 = 0.3333…, rounded to 0.33. Use the 0–60 minute chart for every whole minute.

Is 0.30 hours the same as 30 minutes?

No. 0.30 × 60 = 18 minutes. Thirty minutes equals 0.50 decimal hours.

How do I convert 8.33 decimal hours back to time?

8.33 hours = 8 hours 19 minutes 48 seconds. Rounded to the nearest minute, that is 8:20. The reverse converter displays both.

Why is 8.30 marked ambiguous when I paste an Excel column?

The dot could mean 8.30 decimal hours (8:18) while the intended clock notation might be 8:30. To prevent silent errors, enter a colon for hours and minutes. Use the Decimal → Time mode for true decimal values.

Can I convert totals longer than 24 hours?

Yes. Enter 37:30 or 40:15 for multi-day totals. In Excel and Google Sheets, format durations as [h]:mm when the elapsed hours can exceed 24.

Does the converter upload my timesheet data?

No. Calculations and CSV generation run in your browser. The site does not need an account or a file upload for this conversion tool. Your copied or downloaded file is handled by your own device.

Calculation method: standard 60-minute hour, integer-second totals where supported, and decimal presentation to 2 or 4 places. For independently published minute charts, see University of Houston’s payroll minute conversion chart. Reviewed November 22, 2026.

Scroll to Top