How to Convert Time to Decimal for Payroll (With Chart)

📅 Updated September 13, 2026 ⏱ 8 min read ✍️ By Amara Taylor
Employee timesheet and calculator used to convert time to decimal for payroll processing

If you process timesheets, track billable hours, or run payroll, you need to convert time to decimal before you can multiply clock hours by an hourly wage. The conversion takes just one formula, dividing the minutes by 60, and gets even faster with our free time to decimal calculator.

This guide from Anchor AI Tools walks you through the method step by step, gives you a printable minutes-to-decimal chart, includes real payroll examples with overtime, and provides a built-in calculator so you can convert time to decimal right here on this page.

Quick answer: To convert time to decimal for payroll, divide the minutes by 60 and add the result to the hours. For example, 7 hours 45 minutes = 7 + (45 ÷ 60) = 7.75 decimal hours.

Multiply by the hourly rate to get gross pay. At $20 an hour, 7.75 decimal hours is $155.00.

Why Payroll Requires Decimal Time

Most time clocks and handwritten timesheets record hours and minutes in standard format, such as 8:30, 6:15, or 7:45. But payroll software, accounting spreadsheets, and invoicing systems need decimal hours to compute wages correctly.

Consider this: an employee works 8 hours and 30 minutes at $20 an hour. If you mistakenly enter 8.30 × $20 you get $166, but the correct calculation is 8.50 × $20 = $170.00. That $4 error compounds across every employee, every pay period.

According to the U.S. Department of Labor, employers must keep accurate records of hours worked. Converting clock time to decimal format is the standard method payroll professionals use to meet this requirement and correctly calculate regular pay, overtime wages, labor cost reports, client billable hours, and compliance documentation.

The Time-to-Decimal Formula

Decimal Hours = Hours + (Minutes ÷ 60) Keep the hours. Convert only the minutes.

Step by step: how to convert time to decimal

  1. Separate hours and minutes. A clock reading 6:45 gives hours = 6 and minutes = 45.
  2. Divide minutes by 60. 45 ÷ 60 = 0.75.
  3. Add the decimal to the hours. 6 + 0.75 = 6.75 decimal hours.
  4. Multiply by the hourly rate. 6.75 × $18.00 = $121.50 gross pay.

That is the entire process. Every time you convert time to decimal, you only divide the minutes portion by 60. The hours stay unchanged.

Office desk with a timesheet and pen showing payroll hours being converted to decimal

Accurate time-to-decimal conversion prevents costly payroll errors across every pay cycle.

Free Time to Decimal Calculator

Use this calculator to instantly convert time to decimal. Enter the hours and minutes, and copy the result into your payroll system, spreadsheet, or invoice. Add an hourly rate to see gross pay.

⏱️ Time to Decimal Calculator

Enter hours and minutes. The hourly rate is optional. Nothing is uploaded or stored.

Decimal hours
7.75
7 + (45 ÷ 60) = 7.75 decimal hours
7h 45mClock time
465Total minutes
Gross pay

For a full weekly timesheet with rounding rules, use the time to decimal calculator, or the hours worked calculator to total a week from clock-in and clock-out times.

Minutes to Decimal Conversion Chart

This reference covers every minute from 1 to 60. Bookmark this page, print the chart, or tape it next to your time clock for quick lookup when you need to convert time to decimal on the fly.

MinDecMinDecMinDec
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: for any minute value, just divide by 60. For instance, 37 minutes ÷ 60 = 0.6167, which rounds to 0.62 decimal hours.

Real Payroll Examples

📋 Example 1 · a single shift

Employee clocks in at 8:00 AM and out at 4:45 PM. Rate: $22.00 an hour.

Clock time: 8h 45m. Convert: 45 ÷ 60 = 0.75, giving 8.75 decimal hours.

Gross pay = 8.75 × $22.00 = $192.50

🗓️ Example 2 · a weekly timesheet

DayClock timeDecimal
Monday8h 15m8.25
Tuesday7h 45m7.75
Wednesday8h 30m8.50
Thursday9h 00m9.00
Friday6h 50m6.83
Total40h 20m40.33
40.33 × $25.00 = $1,008.25 gross

Entering 40.20 instead of 40.33 would underpay by $3.25 every week. Over a year that is $169, from reading the minutes as decimals once per timesheet.

Overtime: Federal and State Rules Differ

This is where payroll conversions most often go wrong, and it is not a maths problem. It is a question of which overtime rule applies to you.

RuleThresholdApplies
Federal (FLSA)Over 40 hours per weekEverywhere in the US
Daily overtimeOver 8 hours per daySome states, including California, Alaska, Nevada and Colorado

The Fair Labor Standards Act sets a weekly threshold only. It has no daily overtime rule. A 9-hour day followed by a 31-hour week triggers no federal overtime at all, because the week totals 40.

Several states add a daily rule on top. Where it applies, hours past 8 in a single day earn 1.5× regardless of the weekly total. Check your state before applying the example below.

⏰ Example 3 · daily overtime, in a state that requires it

Employee works 9h 15m in one day. Base rate $20 an hour. This state requires 1.5× after 8 hours in a day.

Convert: 9h 15m = 9.25 decimal hours, split into 8.00 regular and 1.25 overtime.

Regular: 8.00 × $20 = $160.00. Overtime: 1.25 × $30 = $37.50.

Total = $197.50

Under federal rules alone, that same 9h 15m day would be paid at straight time unless the week passed 40 hours. Converting to decimal is the same either way. Which hours count as overtime is the part that depends on where you are.

How to Convert Time to Decimal in Excel or Google Sheets

If you use spreadsheets for timekeeping, automate the conversion. With column A as clock-in and column B as clock-out:

=((B2 - A2) * 24) Subtract the times, then multiply by 24 for decimal hours.
=A1/60 Or convert a plain minutes value in cell A1.

Format the result as Number, not Time, with two decimal places. Leaving it formatted as Time is the most common reason a correct formula shows the wrong answer.

Or skip formulas entirely. The time to decimal calculator does the conversion instantly, and the minutes to decimal chart covers bulk timesheet conversion.

Spreadsheet showing time to decimal payroll calculations in Excel

Excel and Google Sheets automate time-to-decimal conversion with a single formula.

Common Mistakes When You Convert Time to Decimal

Treating minutes as cents. Entering 8:30 as 8.30 instead of 8.50 is the most common payroll error. Thirty minutes is half an hour (0.50), not 0.30. This underpays by 12 minutes per shift.

Rounding too aggressively. The U.S. DOL allows rounding to the nearest 5, 6, or 15 minutes, but it must average out fairly over time. When in doubt, use exact decimal values.

Applying the wrong overtime rule. Federal overtime is weekly, over 40 hours. Daily overtime after 8 hours is a state rule and does not apply everywhere. Check which one governs your payroll before you calculate.

Mixing 12 and 24-hour formats. 17:30 is 5:30 PM, not 5:30 AM. Make sure your spreadsheet handles the correct format.

Forgetting unpaid breaks. Subtract lunch before converting. 8:00 AM to 5:00 PM with a one-hour lunch is 8 work hours, not 9.

Who Needs to Convert Time to Decimal?

This conversion is essential for small business owners running payroll manually, freelancers billing hourly clients, HR managers processing timesheets, accountants tracking labor costs, project managers monitoring billable hours, and contractors invoicing for time-and-materials work.

Working across a full week? The hours worked calculator totals clock-in and clock-out times with breaks. Going the other way, decimal to time turns a decimal figure back into hours and minutes for checking a timesheet entry.

Need to convert time to decimal right now?

Use the Free Calculator ↑

Frequently Asked Questions

How do I convert time to decimal for payroll?
Keep the whole hours, divide the minutes by 60, and add the result. 8 hours 15 minutes becomes 8 + 15/60 = 8.25 decimal hours. Apply the same rounding rule across the whole timesheet.
Why does payroll use decimal hours instead of hours and minutes?
Because pay is a multiplication. A rate can be multiplied directly by 7.5 hours, while 7 hours 30 minutes is base 60 and must be converted first. Every payroll system stores decimals for this reason.
What are the quarter-hour payroll conversions?
15 minutes is 0.25, 30 minutes is 0.50, and 45 minutes is 0.75. These three cover most rounded timesheet entries and are worth knowing without looking them up. 6 minutes is exactly 0.10.
Is overtime calculated daily or weekly?
Federal law sets a weekly threshold of over 40 hours and has no daily rule. Some states, including California, Alaska, Nevada and Colorado, add daily overtime after 8 hours. Check which applies before calculating.
Should payroll time be rounded before or after converting?
Convert the actual time first, then apply your approved rounding method once at the end. Rounding each daily entry before totalling compounds the error across the week.
How do I convert time to decimal in Excel?
Subtract the clock-in from the clock-out and multiply by 24, as =((B2-A2)*24). Format the cell as Number rather than Time, or a correct formula will still display the wrong value.
What does entering 8.30 instead of 8.50 cost?
Twelve minutes of unpaid work per shift. At $20 an hour that is $4 a day, and across a five-day week for one employee it is $20. The digits after the point are a fraction of an hour, not minutes.
How do I convert decimal hours back into minutes?
Multiply the decimal portion by 60. For 6.25 hours, that is 6 hours and 0.25 × 60 = 15 minutes. This reverse check is the quickest way to verify a timesheet entry matches the shift worked.

Related Free Tools From Anchor AI Tools

⚠️ Accuracy note: This guide and the Anchor AI Tools time to decimal calculator provide figures for payroll planning. Overtime thresholds and rounding rules vary by state and by employer policy. Always verify final figures with a qualified payroll professional and check your local labor 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 payroll example on this page are re-derived before publishing, and overtime rules are checked against current Department of Labor guidance · How we check our tools

This guide is general information, not payroll or legal advice. Confirm overtime and rounding rules for your state with a qualified professional.

Written by Amara Taylor for Anchor AI Tools · Last reviewed September 13, 2026 · © 2026 Anchor AI Tools