Convert Clock Time to Decimal Hours for Payroll (Chart + Formula)

Payroll software rarely accepts "7:45" as a number—it wants 7.75. Converting clock time to decimal hours is one of the most common stumbling blocks on a time card, and a small rounding mistake (writing 7.45 instead of 7.75) can change your paycheck. This guide explains the minutes-to-decimal formula, shows a full conversion chart, and how a work hours calculator or free time card calculator displays both formats so you never have to convert by hand.

Why payroll wants decimal hours

Gross pay is hours multiplied by rate. Multiplying 7:45 by $18/hour is awkward; multiplying 7.75 by $18 is one step. Payroll systems, Excel templates, and most CSV imports store paid time as a decimal with two places after the point. Colon format (7:45) is for humans reading a clock; decimal format (7.75) is for machines doing payroll math.

When you export a time card to CSV, paid-hours columns are already in decimal form. Understanding the conversion helps you spot errors when comparing your paper card to what payroll received.

The minutes-to-decimal formula

To convert clock time to decimal hours, divide the minutes portion by 60 and add the result to whole hours:

Decimal hours = whole hours + (minutes ÷ 60)

Example: 7 hours 45 minutes → 45 ÷ 60 = 0.75 → 7 + 0.75 = 7.75. Example: 8 hours 30 minutes → 30 ÷ 60 = 0.50 → 8.50. Fifteen minutes is always 0.25; thirty minutes is 0.50; forty-five minutes is 0.75.

If your shift includes lunch breaks, convert net paid time—not gross time on site. Work 9:00 AM to 5:30 PM with a 30-minute lunch break means 8.0 paid hours (8:00), not 8.50. Deduct break minutes first, then convert the remainder to decimal.

Common mistakes (7.45 vs 7.75)

The most frequent error is treating minutes like hundredths of an hour. Seven hours forty-five minutes is not 7.45—it is 7.75. The digits after the decimal represent fractions of an hour (sixtieths converted to decimals), not the minute hand on a clock.

At $20/hour, 7.45 hours pays $149.00 while 7.75 hours pays $155.00—a $6.00 difference on one row. Across a full week, repeated mistakes add up. Always divide minutes by 60 before combining with whole hours.

Example: one shift end-to-end

Clock in 8:00 AM, clock out 4:45 PM, lunch break 45 minutes.

1. Gross time: 8:00 AM to 4:45 PM = 8 hours 45 minutes (525 minutes).
2. Subtract break: 525 − 45 = 480 minutes = 8 hours 0 minutes.
3. Decimal: 8 + (0 ÷ 60) = 8.00 paid hours.

A harder row: in 6:15 PM, out 2:30 AM next day (overnight), 30-minute lunch break. Gross cross-midnight time is 8 hours 15 minutes; minus break = 7 hours 45 minutes = 7.75 decimal. See our overnight shift guide for cross-midnight math—the decimal step is the same once you have net minutes.

Let the calculator convert for you

Manual conversion across five or ten days invites typos. Our timesheet calculator and homepage time card show each day in colon format (8:30) and decimal format (8.50) on the same row. For one shift, the work hours calculator prints gross and net hours in both formats instantly. If you already know daily totals, the weekly hours calculator sums decimal or h:mm entries without clock times. When you print or export CSV from the full tool, decimal columns are payroll-ready—no spreadsheet formulas required.

Enter clock-in, clock-out, and lunch break minutes per day. The tool handles overnight shifts, bi-weekly periods, and custom date ranges automatically. Pick 12-hour AM/PM or 24-hour display; internal math stays consistent either way.

FAQ

How do I convert 7 hours 30 minutes to decimal?

Divide 30 by 60 to get 0.50, then add to 7 for 7.50 decimal hours. Thirty minutes is always half an hour in decimal form.

Should I round decimal hours to two places?

Yes—most payroll systems use two decimal places (hundredths of an hour). Our calculator rounds paid hours to two decimals to match common payroll imports. Your employer may have a separate time-clock rounding policy (e.g., nearest quarter-hour) that applies before decimal conversion—ask HR if unsure.

Does the CSV export use decimal hours?

Yes. Paid-hours columns in the CSV export are decimal values ready for payroll software. See the full print and CSV export guide for column details.