Article — Minutes to Decimal Hours Converter
Minutes to Decimal Hours — Payroll Time Conversion
Convert minutes to decimal hours by dividing by 60. So 15 minutes equals 0.25 hours, 30 minutes equals 0.5 hours, and 45 minutes equals 0.75 hours. The decimal-hours format is the standard for US payroll, professional-services billing, and time-tracking software because totaling and multiplying decimal numbers is much easier than working with hours-and-minutes notation.
This conversion sits at the heart of every paycheck. A worker who clocks in at 8:07 AM and out at 5:23 PM has accumulated 9 hours 16 minutes, which the payroll system stores as 9.267 decimal hours. Multiplying by the hourly wage gives gross pay — and rounding rules under the Fair Labor Standards Act govern how that 9 h 16 min gets converted in the first place.
Minutes to decimal hours basics
The conversion formula is one division: decimal hours = minutes ÷ 60. The constant 60 comes from the sexagesimal hour subdivision that traces back to Babylonian astronomy. There is no measurement uncertainty — the formula is mathematical.
Three quick conversions cover most everyday cases. 15 min = 0.25 h. 30 min = 0.5 h. 45 min = 0.75 h. Beyond those, the most common increment in professional billing is 6 minutes — exactly 0.1 hour. A 6-minute call bills as 0.1 hour; a 24-minute call bills as 0.4 hour.
The song "Seasons of Love" from the musical Rent opens with "525,600 minutes" — that's exactly one common year (365 days × 24 h × 60 min). In decimal hours, the same year is 8760 hours. Both numbers are arithmetic identities, not approximations.
Why payroll uses decimal hours
Decimal hours simplify multiplication. To compute weekly pay, you need to multiply hours by hourly wage. With decimal hours (37.5 h × $20.00/h = $750.00), it's one line. With hours-and-minutes (37 h 30 min × $20.00/h), you'd convert mid-calculation anyway.
The same applies to weekly totals. Adding 7.5 + 8.25 + 7.75 + 8.5 + 6.0 = 38.0 decimal hours is trivial. Adding 7 h 30 min + 8 h 15 min + 7 h 45 min + 8 h 30 min + 6 h 0 min requires regrouping minutes into hours, which is error-prone for clerks doing it by hand.
Time-clock systems store entries internally as decimal hours and display them in hh:mm format for human readers. Every payroll software (ADP, Paychex, QuickBooks Payroll, Gusto) handles this conversion automatically.
FLSA time-clock rounding rules
US Department of Labor regulations (29 CFR 785.48) permit "rounding" actual time worked to specific increments, provided the rounding is neutral over time. Two increments dominate: 6-minute (0.1 hour) and 15-minute (0.25 hour). Both are FLSA-compliant if applied consistently.
The 15-minute rule uses the "7-minute" convention. Minutes 1–7 past the quarter-hour round down; minutes 8–14 round up to the next quarter. A worker clocking in at 8:07 AM records 8:00; at 8:08 they record 8:15. Same logic applies at clock-out. Over many shifts the gains and losses should average to zero.
Courts have ruled that employer-favorable rounding (always rounding clock-ins forward and clock-outs backward) violates FLSA. A 2018 Ninth Circuit case (Corbin v. Time Warner) awarded back wages where rounding systematically shorted workers. If your rounding rule produces consistent loss to one party, it isn't compliant.
Decimal hours vs clock time
Clock time uses the sexagesimal system: 1 hour = 60 minutes. Decimal time uses base 10: 1 hour = 100 hundredths. The two systems are isomorphic for arithmetic but read differently for humans. "7.5 hours" is decimal; "7:30" is clock time. Both represent the same duration of 450 minutes.
The trap is interpretation. A spreadsheet cell containing "7.30" might mean 7 hours 30 minutes (decimal: 7.5) or 7.30 hours literally (decimal: 7.30 = 7 h 18 min). The two interpretations differ by 12 minutes — meaningful at scale across a payroll cycle. Always label spreadsheet columns clearly.
Excel and Google Sheets both have native time data types. If a cell is formatted as "duration" or "time," entering "7:30" produces a value that behaves correctly in formulas — multiplying by 24 converts to decimal hours. Avoid manual decimal-hour entry; let the spreadsheet do it.
Minutes to decimal quick table
Memorizing common conversions speeds up mental payroll math. The full minute-to-decimal table for every increment from 1 to 60 minutes fits on a sticky note. The key conversions:
- 1 min = 0.0167 h (rounded to 0.02 h)
- 5 min = 0.0833 h (rounded to 0.08 h)
- 6 min = 0.10 h exactly (FLSA increment)
- 10 min = 0.1667 h
- 15 min = 0.25 h exactly (quarter hour)
- 20 min = 0.3333 h
- 30 min = 0.50 h exactly (half hour)
- 45 min = 0.75 h exactly (three-quarters)
- 60 min = 1.00 h exactly
Billable hours in decimal format
Professional services firms — law, accounting, consulting, IT — almost universally bill in 0.1-hour increments (6 minutes). A short email to a client takes 0.1 hour; a phone call up to 12 minutes is 0.2 hour; an hour-long meeting is 1.0 hour. Time entries are recorded in decimal hours, not minutes, and totaled directly for invoices.
Some firms use 0.25-hour (15-minute) billing for less granular work. The trade-off: 0.1-hour billing is fairer to clients (less rounding-up bloat) but heavier admin overhead for the firm. 0.25-hour billing simplifies accounting but rounds short tasks aggressively upward.
Decimal time in spreadsheets
Excel stores time internally as fractions of a day. 1.0 = 24 hours = midnight tomorrow. A time of 7:30 AM is stored as 0.3125 (7.5 / 24). To convert to decimal hours, multiply the cell value by 24. To convert decimal hours back to clock time, divide by 24 and format the cell as time.
Google Sheets behaves identically. Both systems handle the sexagesimal-to-decimal conversion automatically when you switch cell formats. The mistake to avoid is entering "7.5" into a "time"-formatted cell — Sheets interprets it as 7.5 days, not 7.5 hours.
Common minutes-to-decimal mistakes
Manual decimal entry is the leading source of error. Typing "7.30" expecting it to mean 7 h 30 min produces a 12-minute under-recording. Best practice: enter clock time (7:30) and let the spreadsheet or payroll system convert.
The second mistake is asymmetric rounding under FLSA. Rounding every clock-in forward and every clock-out backward systematically shorts workers — actionable under federal labor law. Always audit rounding rules over a representative payroll cycle to verify the gains and losses balance out.