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 — divide 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.
Most time clocks and handwritten timesheets record hours and minutes in standard format — 8:30, 6:15, 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/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 used by payroll professionals to meet this requirement and correctly calculate regular pay, overtime wages, labor cost reports, client billable hours, and compliance documentation.
Decimal Hours = Hours + (Minutes ÷ 60)
Keep the hours. Convert only the minutes.That is the entire process. Every time you need to convert time to decimal, you only divide the minutes portion by 60 — the hours stay unchanged.
Accurate time-to-decimal conversion prevents costly payroll errors across every pay cycle.
Use this calculator to instantly convert time to decimal. Enter the hours and minutes, click Calculate, and copy the result into your payroll system, spreadsheet, or invoice.
Enter hours and minutes below. Optionally add an hourly rate to see gross pay.
For bulk conversions, try the full time to decimal calculator page with additional formatting options.
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.
| Min | Dec | Min | Dec | Min | Dec |
|---|---|---|---|---|---|
| 1 | 0.02 | 21 | 0.35 | 41 | 0.68 |
| 2 | 0.03 | 22 | 0.37 | 42 | 0.70 |
| 3 | 0.05 | 23 | 0.38 | 43 | 0.72 |
| 4 | 0.07 | 24 | 0.40 | 44 | 0.73 |
| 5 | 0.08 | 25 | 0.42 | 45 | 0.75 |
| 6 | 0.10 | 26 | 0.43 | 46 | 0.77 |
| 7 | 0.12 | 27 | 0.45 | 47 | 0.78 |
| 8 | 0.13 | 28 | 0.47 | 48 | 0.80 |
| 9 | 0.15 | 29 | 0.48 | 49 | 0.82 |
| 10 | 0.17 | 30 | 0.50 | 50 | 0.83 |
| 11 | 0.18 | 31 | 0.52 | 51 | 0.85 |
| 12 | 0.20 | 32 | 0.53 | 52 | 0.87 |
| 13 | 0.22 | 33 | 0.55 | 53 | 0.88 |
| 14 | 0.23 | 34 | 0.57 | 54 | 0.90 |
| 15 | 0.25 | 35 | 0.58 | 55 | 0.92 |
| 16 | 0.27 | 36 | 0.60 | 56 | 0.93 |
| 17 | 0.28 | 37 | 0.62 | 57 | 0.95 |
| 18 | 0.30 | 38 | 0.63 | 58 | 0.97 |
| 19 | 0.32 | 39 | 0.65 | 59 | 0.98 |
| 20 | 0.33 | 40 | 0.67 | 60 | 1.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.
📋 Scenario
Employee clocks in 8:00 AM, clocks out 4:45 PM. Rate: $22.00/hour.
Clock time: 8h 45m → Convert: 45 ÷ 60 = 0.75 → 8.75 decimal hours
| Day | Clock Time | Decimal |
|---|---|---|
| Monday | 8h 15m | 8.25 |
| Tuesday | 7h 45m | 7.75 |
| Wednesday | 8h 30m | 8.50 |
| Thursday | 9h 00m | 9.00 |
| Friday | 6h 50m | 6.83 |
| Total | 40h 20m | 40.33 |
At $25.00/hour: 40.33 × $25.00 = $1,008.25. Entering 40.20 instead of 40.33 would underpay by $3.25 every week.
⏰ Overtime Scenario
Employee works 9h 15m. Overtime at 1.5× kicks in after 8 hours. Base rate: $20/hour.
Regular: 8.00 × $20 = $160 · OT: 1.25 × $30 = $37.50
The Fair Labor Standards Act requires overtime pay at 1.5× for hours beyond 40 in a workweek. Accurate decimal conversion is critical for compliance.
Excel and Google Sheets can automate time-to-decimal conversion with a single formula.
If you use spreadsheets for timekeeping, automate the conversion. Column A = clock-in, column B = clock-out:
Format the result as Number (not Time) with two decimal places. For calculating percentage deductions like tax or benefits, combine this with our percentage calculator.
Or skip formulas entirely — the Anchor AI Tools time to decimal calculator does the conversion instantly.
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. When in doubt, use exact decimal values.
Mixing 12/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 1-hour lunch = 8 work hours, not 9.
Not double-checking. Use the calculator above or the time to decimal calculator to verify manual calculations before submitting payroll.
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 on home projects too? Our square footage calculator and concrete calculator can help estimate materials. Buying a home? The mortgage calculator estimates monthly payments. Need to handle documents? Try our free PDF converter or merge PDF tool.
Need to convert time to decimal right now?
Use the Free Calculator →=((B2-A2)*24) where B2 is clock-out and A2 is clock-in. This converts Excel's fractional day format to decimal hours. Format the cell as Number, not Time.Time to Decimal Calculator
Convert hours and minutes to decimal for payroll.
Percentage Calculator
Calculate percentage increase, decrease, and discounts.
Mortgage Calculator
Estimate monthly payments with taxes and insurance.
Square Footage Calculator
Measure rooms, flooring, and land area.
Concrete Calculator
Cubic yards for slabs, footings, and driveways.
PDF Converter
Convert PDF to Word, JPG, PNG, or Excel.
Merge PDF
Combine multiple PDFs into one document.
SEO Audit Tool
Check your site's SEO health and AI visibility.
Published by Anchor AI Tools · © 2026 Anchor AI Tools