How to Convert Minutes to Decimal Hours for Payroll

To convert minutes to decimal hours, divide the number of minutes by 60. Then add that decimal to the whole hours. For example, 2 hours 45 minutes becomes 2 + (45/60) = 2.75 hours. This is the number you multiply by the hourly wage to calculate pay.

Why payroll requires decimal hours

Entering "8:15" into a payroll field as 8.15 would underpay the employee. Eight hours and 15 minutes is actually 8.25 hours (15/60 = 0.25), so the correct entry is 8.25. A small error like this repeated daily adds up to a meaningful underpayment over a year.

The full conversion chart

Minutes	Decimal hours	Minutes	Decimal hours
1	0.02	31	0.52
5	0.08	35	0.58
10	0.17	40	0.67
15	0.25	45	0.75
20	0.33	50	0.83
25	0.42	55	0.92
30	0.50	60	1.00

Quick reference for the four most common breaks

• 15 minutes = 0.25 hours
• 30 minutes = 0.50 hours
• 45 minutes = 0.75 hours
• 60 minutes = 1.00 hours

Converting a full timesheet row

Say an employee worked 78 hours and 45 minutes over a two-week pay period. Convert the minutes: 45 / 60 = 0.75. Total payroll hours = 78.75. At $17.50/hr, gross pay for the period is 78.75 x $17.50 = $1,378.13. For hours beyond 40 in either week, see how to calculate overtime.

Reverse conversion: decimal back to minutes

Multiply the decimal portion by 60. If a report shows 7.33 hours, the minutes are 0.33 x 60 = approximately 20 minutes, so the actual time is 7 hours 20 minutes. This is useful when reading automated reports and translating them back to clock notation.

Full 60-minute conversion table by single-minute increment

The table above covers common intervals. Here is every minute from 1 to 30 for reference when exact precision matters:

Minutes	Decimal	Minutes	Decimal	Minutes	Decimal
1	0.017	11	0.183	21	0.350
2	0.033	12	0.200	22	0.367
3	0.050	13	0.217	23	0.383
4	0.067	14	0.233	24	0.400
5	0.083	15	0.250	25	0.417
6	0.100	16	0.267	26	0.433
7	0.117	17	0.283	27	0.450
8	0.133	18	0.300	28	0.467
9	0.150	19	0.317	29	0.483
10	0.167	20	0.333	30	0.500

How employer time-rounding affects decimal hours

Some employers round employee punch times to the nearest 5 minutes, 6 minutes (tenth of an hour), or 15 minutes before converting to decimals. The most common system is the tenth-of-an-hour rounding, which divides each hour into six 10-minute blocks:

• 0 to 5 minutes past the hour rounds down to the hour (0.0 hours)
• 6 to 15 minutes rounds to 0.1 hours (6 minutes)
• 16 to 25 minutes rounds to 0.2 hours (12 minutes)
• 26 to 35 minutes rounds to 0.3 hours (18 minutes)
• 36 to 45 minutes rounds to 0.4 hours (24 minutes)
• 46 to 55 minutes rounds to 0.5 hours (30 minutes)
• 56 to 59 minutes rounds to 0.9 hours, and so on through full-hour increments

Rounding is permissible under federal guidance only when it is applied neutrally so that it does not consistently under-compensate employees over time. If you believe rounding is systematically reducing your paycheck, compare your actual punch times against the rounded totals each pay period. This article is for educational purposes and is not legal advice.

Decimal hours in Excel and Google Sheets

Spreadsheet programs store time values as fractions of a day. One hour is 1/24 of a day, so a cell showing "8:30" (8 hours 30 minutes) is stored internally as 0.3542. To convert it to decimal payroll hours, multiply by 24: =A1*24 gives 8.5. If your cell shows a time-formatted result instead of 8.5, change the cell format from "Time" to "Number." A common payroll formula for a single row is =(B2-A2)*24-C2, where B2 is clock-out, A2 is clock-in, and C2 is the unpaid break in decimal hours (enter 0.5 for a 30-minute break). Use the time card calculator for an instant conversion without spreadsheet setup.

Common errors to avoid when entering decimal hours

Even with the formula memorized, these mistakes appear frequently in timesheets and payroll entries:

• Treating minutes as cents: Entering 8 hours 20 minutes as 8.20 instead of 8.33 underpays the employee by about 13 cents per hour worked. Over a full year that small error compounds to several dollars.
• Forgetting to convert break time: If you subtract a break, subtract it in decimal form too. A 45-minute break is 0.75 hours, not 0.45.
• Rounding too aggressively: Rounding 8.17 down to 8.0 for convenience removes 10 minutes of pay per day. Use at least two decimal places for payroll accuracy.
• Adding hours and minutes columns separately: If one column holds hours and another holds minutes, you cannot simply add the totals without first converting the minutes column to decimals. Add all minutes together, divide by 60, then add the whole-hour quotient to your hours column and carry any remainder.

When in doubt, use the time card calculator to do the conversion automatically. Also review how to calculate a timesheet with lunch breaks to make sure break deductions are handled correctly before converting to decimals.

Minutes 31 through 60, completing the chart

The single-minute table above stops halfway. Here is the back half of the hour, to the same three decimal places:

Minutes	Decimal	Minutes	Decimal	Minutes	Decimal
31	0.517	41	0.683	51	0.850
32	0.533	42	0.700	52	0.867
33	0.550	43	0.717	53	0.883
34	0.567	44	0.733	54	0.900
35	0.583	45	0.750	55	0.917
36	0.600	46	0.767	56	0.933
37	0.617	47	0.783	57	0.950
38	0.633	48	0.800	58	0.967
39	0.650	49	0.817	59	0.983
40	0.667	50	0.833	60	1.000

Between the two tables, every minute of the hour is covered. Bookmark whichever half your shifts tend to land in; punch clocks that record to the exact minute make the odd values like 0.883 far more common than the tidy quarters.

When the minutes top an hour

Sometimes the raw figure is not "8 hours and 20 minutes" but a pile of minutes on its own: a task tracker reports 135 minutes, or a week of small entries sums to 340. The same division handles it, and the whole hours fall out of the quotient. 135 divided by 60 is 2.25 hours. 340 divided by 60 is 5.67. There is no need to first split the pile into hours and remainder; the division does both jobs at once.

Total minutes	Decimal hours	Total minutes	Decimal hours
75	1.25	150	2.50
90	1.50	180	3.00
100	1.67	200	3.33
105	1.75	240	4.00
120	2.00	270	4.50
135	2.25	300	5.00

The same move settles overtime paperwork. A pay period ending at 43 hours 24 minutes converts to 43.40, which splits into 40 regular hours and 3.40 overtime hours; the 3.40 is what gets multiplied by the time-and-a-half rate, not "3 hours 24" mashed into 3.24.

The six-minute trick for head math

Six minutes is exactly a tenth of an hour, and that one fact makes rough conversion possible without paper. Count how many full six-minute chunks the minutes hold: 20 minutes is three chunks and change, so a hair over 0.3. Fifty minutes is eight chunks and a bit, so roughly 0.83. It will not replace the chart when a paycheck depends on the second decimal, but it is enough to catch a typo. Anyone who glances at "8 hours 50 minutes" and sees 8.5 written next to it now knows instantly that a third of an hour went missing.

What one minute is actually worth

Conversion errors stay abstract until you price them. A minute of paid work is the hourly rate divided by 60:

Hourly rate	One minute	Ten minutes
$12	$0.20	$2.00
$15	$0.25	$2.50
$18	$0.30	$3.00
$20	$0.33	$3.33
$25	$0.42	$4.17
$30	$0.50	$5.00

Now compound it. A timesheet habit that drops four minutes a day, writing 8:04 down as a flat 8 hours for instance, costs $1.33 a day at $20 an hour. That is $6.67 a week, and roughly $347 across a 52-week year. Nobody notices a minute. Everybody would notice $347.

A week under quarter-hour rounding, minute by minute

The rounding rules above are easier to feel with a concrete week. Quarter-hour rounding moves each punch to the nearest :00, :15, :30 or :45, so a single punch can shift by as much as 7 minutes in either direction. Here is a realistic week with a 60-minute unpaid lunch each day, actual time worked against what the rounded record shows:

Day	Actual punches	Actual hours	Rounded punches	Rounded hours
Mon	7:58 to 4:04	7.10	8:00 to 4:00	7.00
Tue	8:07 to 4:02	6.92	8:00 to 4:00	7.00
Wed	8:09 to 4:11	7.03	8:15 to 4:15	7.00
Thu	7:52 to 4:08	7.27	7:45 to 4:15	7.50
Fri	8:02 to 3:58	6.93	8:00 to 4:00	7.00

Actual total: 35.25 hours. Rounded total: 35.50. This particular week the employee comes out 15 minutes ahead, worth about $4.50 at $18 an hour, and a different week could tip the other way just as easily. That give-and-take is the whole reason federal guidance tolerates the practice. A rounding pattern that only ever subtracted would not qualify.

Quarter-hour versus tenth-hour: which drifts more

Of the permitted rounding intervals, the tenth of an hour can move a punch at most 3 minutes; the quarter hour can move one 7. With four punches in a typical day (in, out to lunch, back from lunch, out), the worst possible single-day drift is 12 minutes under tenth-hour rounding and 28 under quarter-hour. Actual drift runs far smaller because individual roundings offset each other, but the ceiling matters: if your workplace is choosing between systems, the tenth-hour version keeps the recorded day measurably closer to the worked one.

Related reading

• How to calculate hours worked
• How to calculate overtime pay
• Work hours in a year (and a month)
• Biweekly pay periods explained
• Timesheet with lunch breaks