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.
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.
Enter 90 for an hour and 30 minutes. Decimals such as 10.5 minutes are accepted.
Enter a decimal number (not 8:30). The seconds and the nearest-minute versions are shown separately.
Accepted: 8:20, 08:20:15, 8h 20m, 90m. A dot such as 8.30 is flagged as ambiguous. Maximum 500 rows. Blank rows are ignored.
Enter durations to calculate.
| Row | Input | Decimal (2) | Decimal (4) | Status |
|---|---|---|---|---|
| No rows yet. Try “Load sample”. | ||||
Export contains one row per input plus status. Invalid and ambiguous rows are excluded from totals; do not treat the copied column as validated payroll records without reviewing the status table.
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.
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.
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.
| Minutes | Decimal (2) | Decimal (4) | Minutes | Decimal (2) | Decimal (4) |
|---|---|---|---|---|---|
| 0 | 0.00 | 0.0000 | 31 | 0.52 | 0.5167 |
| 1 | 0.02 | 0.0167 | 32 | 0.53 | 0.5333 |
| 2 | 0.03 | 0.0333 | 33 | 0.55 | 0.5500 |
| 3 | 0.05 | 0.0500 | 34 | 0.57 | 0.5667 |
| 4 | 0.07 | 0.0667 | 35 | 0.58 | 0.5833 |
| 5 | 0.08 | 0.0833 | 36 | 0.60 | 0.6000 |
| 6 | 0.10 | 0.1000 | 37 | 0.62 | 0.6167 |
| 7 | 0.12 | 0.1167 | 38 | 0.63 | 0.6333 |
| 8 | 0.13 | 0.1333 | 39 | 0.65 | 0.6500 |
| 9 | 0.15 | 0.1500 | 40 | 0.67 | 0.6667 |
| 10 | 0.17 | 0.1667 | 41 | 0.68 | 0.6833 |
| 11 | 0.18 | 0.1833 | 42 | 0.70 | 0.7000 |
| 12 | 0.20 | 0.2000 | 43 | 0.72 | 0.7167 |
| 13 | 0.22 | 0.2167 | 44 | 0.73 | 0.7333 |
| 14 | 0.23 | 0.2333 | 45 | 0.75 | 0.7500 |
| 15 | 0.25 | 0.2500 | 46 | 0.77 | 0.7667 |
| 16 | 0.27 | 0.2667 | 47 | 0.78 | 0.7833 |
| 17 | 0.28 | 0.2833 | 48 | 0.80 | 0.8000 |
| 18 | 0.30 | 0.3000 | 49 | 0.82 | 0.8167 |
| 19 | 0.32 | 0.3167 | 50 | 0.83 | 0.8333 |
| 20 | 0.33 | 0.3333 | 51 | 0.85 | 0.8500 |
| 21 | 0.35 | 0.3500 | 52 | 0.87 | 0.8667 |
| 22 | 0.37 | 0.3667 | 53 | 0.88 | 0.8833 |
| 23 | 0.38 | 0.3833 | 54 | 0.90 | 0.9000 |
| 24 | 0.40 | 0.4000 | 55 | 0.92 | 0.9167 |
| 25 | 0.42 | 0.4167 | 56 | 0.93 | 0.9333 |
| 26 | 0.43 | 0.4333 | 57 | 0.95 | 0.9500 |
| 27 | 0.45 | 0.4500 | 58 | 0.97 | 0.9667 |
| 28 | 0.47 | 0.4667 | 59 | 0.98 | 0.9833 |
| 29 | 0.48 | 0.4833 | 60 | 1.00 | 1.0000 |
| 30 | 0.50 | 0.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.
| Task | Formula | Explanation |
|---|---|---|
| Time or duration in A2 → decimal hours | =A2*24 | An Excel duration of 8:30 becomes 8.5 hours. |
| Hours in A2, minutes in B2, seconds in C2 | =A2+B2/60+C2/3600 | Works with separate number columns. |
| Decimal hours in A2 → spreadsheet duration | =A2/24 | Apply 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)*24 | Avoids accumulating row-by-row display rounding. |
| Start A2 / end B2, with overnight shift | =MOD(B2-A2,1)*24 | For 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.
| Method | Three rows of 8:20 | Result |
|---|---|---|
| Round each row first | 8.33 + 8.33 + 8.33 | 24.99 |
| Add exact durations first | 8:20 + 8:20 + 8:20 = 25:00 | 25.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.