Need to convert minutes to decimal for a timesheet, payroll run, or billing invoice? Divide the minutes by 60. That single step turns clock minutes into the decimal hours that payroll software and spreadsheets actually understand.
Use the free converter below for an instant answer with a one-tap copy button, paste a whole timesheet column into the bulk tool, or grab the full 1โ60 minute chart further down the page.
This tool from Anchor AI Tools gives you the conversion four ways: an instant calculator, a bulk converter that takes a whole timesheet column at once, a printable reference chart, and the formula with worked examples so you understand exactly how the number is produced.
Quick Answer: To convert minutes to decimal, divide the minutes by 60. So 20 minutes = 0.33 decimal hours (20 รท 60 = 0.3333). The formula is Decimal = Minutes รท 60.
Common values: 10 min = 0.17, 15 min = 0.25, 18 min = 0.30, 30 min = 0.50, 40 min = 0.67, 45 min = 0.75.
For a full clock time, keep the whole hours and add the decimal: 8 hours 30 minutes = 8.50 decimal hours. See the full 1โ60 minute chart or paste a whole column into the bulk timesheet converter.
Enter minutes (and optionally whole hours) below. Choose a rounding precision if your payroll system needs it, then click Convert and copy the decimal value straight into your timesheet or spreadsheet.
Divide minutes by 60. Add whole hours for a full clock-time conversion.
For converting a full clock-in to clock-out span, use the dedicated time to decimal calculator. To go the other way, see decimal to time.
Converting one value at a time is slow when a timesheet holds forty rows. Paste an entire column below and every line is converted to decimal hours at once, with a running total, an optional payroll rounding rule, and a CSV you can open straight in Excel or Google Sheets.
The bulk converter reads the formats a real timesheet actually contains, including 7:45, 7h 45m, 7 hr 45 min, and 7:45:30. Day labels such as Monday 7:45 are stripped automatically, and blank lines are skipped.
Paste one time value per line. Nothing is uploaded โ the conversion runs entirely in your browser.
Tip: copy the column straight out of Excel or Google Sheets and paste it here. Press Ctrl + Enter to convert.
| # | Your Entry | Hours & Minutes | Decimal Hours |
|---|---|---|---|
| Total | โ | โ | |
These are the most-searched single minute values converted to decimal hours. Each shows the rounded two-decimal value used on most timesheets, with the exact value in brackets. To convert any other value, divide the minutes by 60.
| Question | Decimal Hours | Exact |
|---|---|---|
| 5 minutes in decimal | 0.08 | 0.0833 |
| 6 minutes in decimal | 0.10 | 0.1000 |
| 10 minutes in decimal | 0.17 | 0.1667 |
| 15 minutes in decimal | 0.25 | 0.2500 |
| 18 minutes in decimal | 0.30 | 0.3000 |
| 20 minutes in decimal | 0.33 | 0.3333 |
| 25 minutes in decimal | 0.42 | 0.4167 |
| 30 minutes in decimal | 0.50 | 0.5000 |
| 40 minutes in decimal | 0.67 | 0.6667 |
| 45 minutes in decimal | 0.75 | 0.7500 |
| 50 minutes in decimal | 0.83 | 0.8333 |
| 55 minutes in decimal | 0.92 | 0.9167 |
20 minutes in decimal is the most common lookup: 20 รท 60 = 0.3333, which rounds to 0.33 decimal hours. Most payroll systems accept the two-decimal value, but check whether yours requires a specific rounding increment first.
Decimal Hours = Minutes รท 60
For a full clock time: Hours + (Minutes รท 60)Because there are 60 minutes in an hour, every minute is worth 1/60 of an hour, or about 0.0167 in decimal. To convert any minute value, you simply divide by 60. The whole-hour part of a clock time never changes โ only the minutes get converted.
This chart covers every minute from 1 to 60 rounded to two decimal places. The highlighted rows (15, 30, 45, 60) are the quarter-hour values used most often in payroll. Bookmark or print this page and keep it next to your time clock.
| Min | Decimal | Min | Decimal | Min | Decimal |
|---|---|---|---|---|---|
| 1 | 0.02 | 21 | 0.35 | 41 | 0.68 |
| 2 | 0.03 | 22 | 0.37 | 42 | 0.70 |
| 3 | 0.05 | 23 | 0.38 | 43 | 0.72 |
| 4 | 0.07 | 24 | 0.40 | 44 | 0.73 |
| 5 | 0.08 | 25 | 0.42 | 45 | 0.75 |
| 6 | 0.10 | 26 | 0.43 | 46 | 0.77 |
| 7 | 0.12 | 27 | 0.45 | 47 | 0.78 |
| 8 | 0.13 | 28 | 0.47 | 48 | 0.80 |
| 9 | 0.15 | 29 | 0.48 | 49 | 0.82 |
| 10 | 0.17 | 30 | 0.50 | 50 | 0.83 |
| 11 | 0.18 | 31 | 0.52 | 51 | 0.85 |
| 12 | 0.20 | 32 | 0.53 | 52 | 0.87 |
| 13 | 0.22 | 33 | 0.55 | 53 | 0.88 |
| 14 | 0.23 | 34 | 0.57 | 54 | 0.90 |
| 15 | 0.25 | 35 | 0.58 | 55 | 0.92 |
| 16 | 0.27 | 36 | 0.60 | 56 | 0.93 |
| 17 | 0.28 | 37 | 0.62 | 57 | 0.95 |
| 18 | 0.30 | 38 | 0.63 | 58 | 0.97 |
| 19 | 0.32 | 39 | 0.65 | 59 | 0.98 |
| 20 | 0.33 | 40 | 0.67 | 60 | 1.00 |
Pro tip: The four values worth memorising are the quarters โ 15 min = 0.25, 30 min = 0.50, 45 min = 0.75, 60 min = 1.00. For everything else, divide by 60. For example, 37 รท 60 = 0.6167, which rounds to 0.62.
A quick-reference minutes to decimal chart prevents the most common payroll entry errors.
Some teams want the answer on paper next to the time clock rather than on a screen. The button below opens a clean, one-page minutes to decimal conversion chart formatted for printing, with no navigation, no adverts, and no colour bleed.
In the print dialogue, choose Save as PDF as the destination if you would rather keep a digital copy or email the chart to your payroll team.
Minutes to decimal chart โ one page, print ready
Every minute from 1 to 60, plus the quarter-hour reference key. Free, no signup, no email required.
๐ Convert 41 minutes
An employee works 8 hours and 41 minutes. Convert the minutes: 41 รท 60 = 0.683 (to three places).
๐ Convert 20 minutes
A freelancer logs 20 minutes on a task. 20 รท 60 = 0.3333, which rounds to 0.33 decimal hours. At $60/hour the exact value bills 0.3333 ร $60 = $20.00, while the rounded 0.33 bills $19.80.
๐ Convert a weekly timesheet
Mon 8:15, Tue 7:45, Wed 8:30, Thu 9:00, Fri 6:50 converts to 8.25, 7.75, 8.50, 9.00, and 6.83. The week totals 40h 20m, which is 40.33 decimal hours โ not 40.20.
โ ๏ธ The most common mistake
30 minutes is half an hour. Half of 1.00 is 0.50, not 0.30. Typing 8.30 instead of 8.50 undercounts 12 minutes every shift.
Most exact conversions produce repeating decimals. Ten minutes is 0.1667, and 40 minutes is 0.6667. For payroll, many employers round to a set increment instead.
Under the U.S. Department of Labor's interpretation of the Fair Labor Standards Act, time may be rounded to the nearest 5 minutes, the nearest tenth of an hour (6 minutes), or the nearest quarter hour (15 minutes), provided the rounding does not consistently favour the employer.
The best-known method is the 7-minute rule, which rounds to the nearest quarter hour. Time from 1 to 7 minutes past an interval rounds down, and time from 8 to 14 minutes rounds up to the next quarter hour.
So a clock-in at 8:07 is treated as 8:00, while 8:08 becomes 8:15. The rule must round in both directions so that, on average, employees are paid for all hours worked.
| Rounding | Increment | Decimal step | Common use |
|---|---|---|---|
| Nearest 5 min | 5 minutes | 0.083 | Fine-grained payroll |
| Nearest 6 min | 1/10 hour | 0.10 | Legal & billable hours |
| Nearest 15 min | 1/4 hour | 0.25 | Most common (7-min rule) |
| Exact | 1 minute | 0.0167 | Modern digital clocks |
The bulk converter above applies any of these rules to an entire timesheet at once. For full timesheet rounding with start and end times, use the hours worked calculator.
If your minutes sit in a spreadsheet cell, divide by 60 directly. If you have a clock time stored as a time value, multiply by 24 to get decimal hours:
Format the result cell as Number (not Time) with two decimal places. For pay deductions like tax or benefits, pair this with the percentage calculator.
This conversion is everyday work for payroll administrators entering timesheets, freelancers billing partial hours, HR teams processing time cards, accountants tracking labour costs, project managers logging billable time, and small business owners running payroll by hand.
Anyone who multiplies worked time by a rate needs decimal hours first, because you cannot multiply 8:30 by a wage directly.
For the complete payroll workflow โ converting a full shift, deducting breaks, and handling overtime โ read our guide on how to convert time to decimal for payroll, or convert full hours with the hours to decimal calculator.
Need to convert a full clock-in to clock-out time?
Use the Time to Decimal Calculator โ=A1/60. Format the result cell as Number, not Time, with two decimal places.Time to Decimal Calculator
Convert full clock time to decimal hours.
Hours to Decimal
Convert hours and minutes for payroll.
Decimal to Time
Convert decimal hours back to clock time.
Hours Worked Calculator
Total a timesheet with breaks and rounding.
Payroll Conversion Guide
Full how-to with overtime examples.
Percentage Calculator
Calculate deductions, tax, and discounts.
All 60 chart values and every worked example on this page are checked against the formula before publishing ยท How we check our tools
This converter gives figures for planning only. Confirm final pay figures with a qualified payroll professional.
Written by Amara Taylor for Anchor AI Tools ยท Last reviewed September 13, 2026 ยท ยฉ 2026 Anchor AI Tools