Minutes to Decimal Converter (Free Chart & Calculator)

๐Ÿ“… Updated September 13, 2026 โฑ 7 min read โœ๏ธ By Amara Taylor
โœ“ Free, no signup โœ“ Full 1โ€“60 chart โœ“ Bulk timesheet paste โœ“ Printable chart
Analog clock and timesheet used to convert minutes to decimal hours for payroll

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.

Minutes to Decimal Calculator

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.

โฑ๏ธ Minutes to Decimal Converter

Divide minutes by 60. Add whole hours for a full clock-time conversion.

Clock Timeโ€”
Decimal Hoursโ€”

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.

Bulk Timesheet Calculator: Convert a Whole Column of Minutes to Decimal

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.

๐Ÿ“‹ Bulk Minutes to Decimal Converter

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 EntryHours & MinutesDecimal Hours
Totalโ€”โ€”
โ€”
Rows converted
โ€”
Total decimal hours
โ€”
Average per row
โ€”
Lines skipped
โš ๏ธ Rounding note: The U.S. Department of Labor permits time to be rounded to the nearest 5, 6, or 15 minutes provided the rounding is neutral and does not consistently favour the employer. The default setting here is exact conversion. Apply a rounding rule only if your organisation already uses one.

Common Minutes in Decimal (Quick Lookup)

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.

QuestionDecimal HoursExact
5 minutes in decimal0.080.0833
6 minutes in decimal0.100.1000
10 minutes in decimal0.170.1667
15 minutes in decimal0.250.2500
18 minutes in decimal0.300.3000
20 minutes in decimal0.330.3333
25 minutes in decimal0.420.4167
30 minutes in decimal0.500.5000
40 minutes in decimal0.670.6667
45 minutes in decimal0.750.7500
50 minutes in decimal0.830.8333
55 minutes in decimal0.920.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.

The Minutes-to-Decimal Formula

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.

  1. Take the minutes on their own. From 8:45, the minutes are 45.
  2. Divide by 60. 45 รท 60 = 0.75.
  3. Keep the whole hours and add the decimal. 8 + 0.75 = 8.75 decimal hours.
  4. Multiply by the hourly rate if you need pay. 8.75 ร— $20 = $175.00.

Full 1โ€“60 Minutes to Decimal Chart

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.

MinDecimalMinDecimalMinDecimal
10.02210.35410.68
20.03220.37420.70
30.05230.38430.72
40.07240.40440.73
50.08250.42450.75
60.10260.43460.77
70.12270.45470.78
80.13280.47480.80
90.15290.48490.82
100.17300.50500.83
110.18310.52510.85
120.20320.53520.87
130.22330.55530.88
140.23340.57540.90
150.25350.58550.92
160.27360.60560.93
170.28370.62570.95
180.30380.63580.97
190.32390.65590.98
200.33400.67601.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.

Person reviewing a minutes to decimal chart on a timesheet for payroll entry

A quick-reference minutes to decimal chart prevents the most common payroll entry errors.

Printable Minutes to Decimal Conversion Chart

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.

Worked Examples

Example 1 โ€” A single partial hour

๐Ÿ“‹ Convert 41 minutes

An employee works 8 hours and 41 minutes. Convert the minutes: 41 รท 60 = 0.683 (to three places).

8h 41m = 8.683 decimal hours

Example 2 โ€” Minutes only

๐Ÿ“‹ 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.

20 minutes = 0.33 decimal hours

Example 3 โ€” A full week

๐Ÿ“‹ 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.

40h 20m = 40.33 decimal hours

Example 4 โ€” Why 8:30 is not 8.30

โš ๏ธ 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.

8h 30m = 8.50 (never 8.30)

Rounding Minutes to Decimal for Payroll (the 7-Minute Rule)

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.

RoundingIncrementDecimal stepCommon use
Nearest 5 min5 minutes0.083Fine-grained payroll
Nearest 6 min1/10 hour0.10Legal & billable hours
Nearest 15 min1/4 hour0.25Most common (7-min rule)
Exact1 minute0.0167Modern 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.

How to Convert Minutes to Decimal in Excel or Google Sheets

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:

// Minutes in cell A1 โ†’ decimal hours
=A1/60

// A clock time value in A1 โ†’ decimal hours
=A1*24

// Hours in B1 and minutes in C1 โ†’ decimal hours
=B1+(C1/60)

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.

Who Uses Minutes-to-Decimal Conversion?

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 โ†’

Minutes to Decimal โ€” Frequently Asked Questions

What is 20 minutes in decimal?
20 minutes in decimal is 0.33 hours, rounded to two places โ€” 20 รท 60 = 0.3333. Most payroll systems use 0.33; enter 20 in the calculator above and choose 4 places for the exact 0.3333.
What is 30 minutes in decimals?
30 minutes in decimal is 0.50 hours โ€” 30 รท 60 = 0.50 exactly. That is half an hour, and a common source of payroll error when people type 0.30 instead.
What is 1 hour 20 minutes in decimal?
1 hour 20 minutes in decimal is 1.33 hours. Keep the whole hour and convert the minutes: 1 + (20 รท 60) = 1 + 0.3333 = 1.33 decimal hours.
How do you convert minutes to decimals?
Divide the minutes by 60. That is the whole method. For example, 20 รท 60 = 0.33, and 45 รท 60 = 0.75. If the entry also has hours, keep the hours unchanged and add the decimal to them, so 7 hours 45 minutes becomes 7.75.
How do you calculate decimal hours for a whole timesheet?
Convert each row by dividing its minutes by 60, then add the decimal results together. The bulk converter on this page does every row at once, gives the weekly total, and exports a CSV you can open in Excel or Google Sheets.
Is there a printable minutes to decimal conversion chart?
Yes. The printable chart button on this page opens a clean one-page chart covering every minute from 1 to 60. Choose Save as PDF in the print dialogue to keep a digital copy. It is free and no email address is required.
How do I convert hours and minutes to decimal?
Keep the hours, divide the minutes by 60, then add both numbers. Example: 1 hour 45 minutes is 1 + (45 รท 60) = 1.75 decimal hours.
Why is 8:30 not 8.30 in decimal?
Because 30 minutes is half an hour, which is 0.50, not 0.30. Typing 8.30 counts only 18 minutes and undercounts pay by 12 minutes per shift. The correct value is 8.50.
How do I convert decimal hours back to minutes?
Multiply the decimal part by 60. Example: 0.75 hours ร— 60 = 45 minutes. Use the decimal to time calculator for the reverse conversion.
How do I convert minutes to decimal in Excel?
Put the minutes in a cell and divide by 60, for example =A1/60. Format the result cell as Number, not Time, with two decimal places.

Related Free Tools From Anchor AI Tools

โš ๏ธ Accuracy Note: This converter and chart provide estimates for payroll and timesheet planning. Rounding rules vary by employer and jurisdiction. Always confirm final figures with a qualified payroll professional and check your local labour laws.
Amara Taylor, who builds and maintains Anchor AI Tools
Written and reviewed by Amara Taylor ยท Content Lead, Anchor AI Tools ยท California, USA

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