Time Card Conversion: How to Convert Time to Decimal

If you've ever stared at a timesheet trying to figure out what 7 hours and 45 minutes looks like as a number you can actually use for payroll — you're not alone. Time card conversion trips up a lot of small business owners, and a small mistake in the math can mean underpaying your team or throwing off your labor costs without realizing it.

The good news? Once you understand the formula, it's straightforward. 

This guide walks you through exactly how to convert time to decimal, complete with a step-by-step breakdown, common examples, and tips for avoiding the mistakes that quietly cost businesses money. We'll also cover how to reverse the conversion, how to do it in Excel or Google Sheets, and how payroll fits into all of it.

‍

{{banner-cta}}

‍

TL;DR: What is time card conversion?

Time card conversion is the process of turning clock time into decimal hours so payroll systems can calculate accurate wages. Standard time and payroll math don't speak the same language — a clock reads 7:45, but payroll needs 7.75. That gap is what time card conversion solves, and getting it right matters for every hourly worker on your team.

Here's what to know before we get into the math:

• The formula: minutes ÷ 60 = decimal
• 45 minutes = .75, 30 minutes = .50, 15 minutes = .25
• Even small errors compound fast across a full team and pay period
• Manual conversion is error-prone — most small businesses eventually automate it

The formula to convert time to decimal

There's really only one formula you need to know:

Minutes ÷ 60 = decimal

That's it. Since there are 60 minutes in an hour, dividing any number of minutes by 60 gives you the decimal equivalent. Here's how it looks in practice:

• 45 minutes ÷ 60 = .75
• 30 minutes ÷ 60 = .50
• 15 minutes ÷ 60 = .25
• 10 minutes ÷ 60 = .17
• 20 minutes ÷ 60 = .33
• 27 minutes ÷ 60 = .45
• 40 minutes ÷ 60 = .67
• 43 minutes ÷ 60 = .72

Once you have the decimal, you add it to the whole hours worked. So if an employee worked 8 hours and 45 minutes, their decimal time is 8.75. If they worked 6 hours and 30 minutes, it's 6.50.

Keep this formula handy — everything else in time card conversion builds from it.

How to convert hours and minutes to decimal (step by step)

Let's walk through the full process from timesheet to payroll-ready number.

Step 1: Separate the hours and minutes

Start by identifying the total hours and total minutes worked. If an employee worked from 9:00 AM to 5:30 PM, that's 8 hours and 30 minutes.

Step 2: Divide the minutes by 60

Take the minutes and apply the formula. 30 ÷ 60 = 0.50.

Step 3: Add the decimal to the total hours

Combine the whole hours with the decimal. 8 + 0.50 = 8.50 hours.

Step 4: Multiply by the employee's hourly wage

Now you have a number payroll can work with. If that employee earns $18/hour: 8.50 × $18 = $153.00.

Don't forget to account for break deductions, overtime thresholds, and any multiple pay rates before finalizing. Those details matter for compliance and accurate wages.

Common time card conversion examples

Here are the specific time combinations that come up most often on timesheets:

• 8 hours 30 minutes = 8.50
• 7 hours 45 minutes = 7.75
• 9 hours 15 minutes = 9.25
• 9 hours 45 minutes = 9.75
• 9 hours 30 minutes = 9.50
• 7 hours 40 minutes = 7.67
• 7 hours 24 minutes = 7.40
• 4 hours 40 minutes = 4.67
• 2 hours 45 minutes = 2.75
• 2 hours 55 minutes = 2.92

Bookmark this list — it covers the combinations that show up on most small business timesheets week after week.

Time clock conversion for payroll

Converting time card hours to decimal isn't just about cleaner math — it's what makes payroll legally and financially accurate. Here's what you need to keep in mind.

1. Why payroll uses decimals

Payroll software calculates wages by multiplying hours worked by a pay rate — and that calculation requires decimal hours, not clock time. If you're doing any part of this manually, the conversion has to happen first. Most modern time clock systems handle it automatically.

2. How overtime factors in

Under the Fair Labor Standards Act (FLSA), non-exempt employees must be paid at 1.5x their regular rate for hours worked over 40 in a workweek. In decimal terms:

• An employee who works 42.50 hours has 40 regular hours and 2.50 overtime hours
• The overtime hours are paid at 1.5x their standard rate
• Decimal hours make this threshold much easier to track accurately

3. Break deductions

Unpaid breaks need to be subtracted from total hours before calculating pay. A common example:

• Employee works 9:00 AM to 5:30 PM = 8.50 hours on the clock
• Subtract a 30-minute unpaid lunch = 8.00 payable decimal hours
• Skipping this step is one of the most common payroll errors small businesses make

4. Rounding policies

The DOL permits employers to round employee time, but the rules are specific:

• Acceptable increments: nearest 5 minutes, nearest one-tenth of an hour (6 minutes), or nearest quarter hour (15 minutes)
• The quarter hour is the maximum — rounding to 20 or 30 minutes violates the FLSA
• Rounding must be neutral and not consistently favor the employer
• When in doubt, paying for exact time worked is always the safer approach

A note on compliance: Homebase can help you track hours accurately and flag potential compliance issues, but it's always a good idea to consult with a labor law professional for guidance specific to your state and business.

How to convert decimal hours back to time

Sometimes you need to go the other direction — converting decimal hours back into hours and minutes. This comes up when reviewing timesheets, explaining pay to employees, or double-checking payroll records.

The formula is just as simple:

Decimal × 60 = minutes

Take the decimal portion of the hours, multiply by 60, and you have your minutes back. Here's how that looks:

• 7.75 hours → 0.75 × 60 = 45 minutes → 7 hours 45 minutes
• 8.50 hours → 0.50 × 60 = 30 minutes → 8 hours 30 minutes
• 9.25 hours → 0.25 × 60 = 15 minutes → 9 hours 15 minutes
• 6.67 hours → 0.67 × 60 = 40 minutes → 6 hours 40 minutes

This reverse conversion is useful when an employee asks why their hours look different on a pay stub than what they clocked. Being able to translate decimal back to clock time quickly builds trust with your team.

How to convert time to decimal in Excel or Google Sheets

If you're managing timesheets in a spreadsheet, you can automate the decimal conversion with a formula instead of doing the math manually for every row.

The formulas. There are two options, and both work in Excel and Google Sheets:

• =HOUR(A1)+MINUTE(A1)/60 — pulls the hour and minute values from a time-formatted cell and converts to decimal hours (e.g., 8:30 → 8.50)
• =A1*24 — a simpler option that works when your cell is already formatted as a time value; multiplies the internal time fraction by 24 to return decimal hours

Both return the same result. Use whichever fits how your data is entered.

How to use it. Enter clock-in and clock-out times in separate columns, then calculate total time worked in a third column using =B1-A1. Apply either formula above to convert that result to decimal hours. 

Note: Excel stores the subtracted result as a time fraction internally — that's expected, and it's exactly why the conversion formula is needed. Format your decimal output column as "Number" with two decimal places so it displays cleanly.

A quick note on cell formatting. If you're getting unexpected results, check two things: your total hours column should be formatted as "Time," and your decimal output column should be formatted as "Number." That resolves most formatting conflicts.

The honest limitation. Spreadsheet formulas work fine for a handful of employees, but they don't scale well. The more employees you have, the more room there is for formula errors, missed rows, and version control issues. 

If you're spending significant time managing time conversion in a spreadsheet every pay period, that's a sign a dedicated time tracking tool will pay for itself quickly.

5 common time card conversion mistakes that cost businesses money

Manual time card conversion leaves a lot of room for error. These are the mistakes that come up most often — and the ones most likely to affect your bottom line.

1. Rounding incorrectly

Federal rounding rules require you to round to the nearest quarter hour, not always in the employer's favor. Consistently rounding down to save on labor costs is a wage violation, and the penalties are steep. Learn more about time clock rounding rules.

2. Forgetting break deductions

Unpaid breaks that don't get deducted mean you're overpaying for time not worked. Paid breaks that do get deducted mean you're underpaying and potentially violating labor law. You need a clear, consistent policy — and a way to enforce it.

3. Miscalculating overtime

Overtime errors are among the most expensive payroll mistakes a small business can make. If an employee's decimal hours aren't calculated correctly, their overtime threshold shifts with it. A 0.25-hour error per employee per week across a team of ten adds up fast.

4. Spreadsheet errors

A misplaced formula, a copied cell that didn't update, a row that got skipped — spreadsheet mistakes are easy to make and hard to catch. Unlike dedicated payroll software, a spreadsheet doesn't flag when something looks off.

5. Decimal confusion

This one catches people off guard: .50 and .5 are the same value, but .50 hours and 50 minutes are not. If you're manually entering decimal hours into a payroll system, make sure you're entering the converted decimal — not the raw minutes.

Stop doing time card conversion manually

If you're dividing minutes by 60 every Sunday night before payroll runs, there's a better way.

Homebase automatically converts your employees' clock-in and clock-out times into decimal hours the moment they clock out. No math, no spreadsheets, no second-guessing. Your timesheets are ready for payroll before you even sit down to run it.

Here's what that looks like in practice:

• Automatic decimal conversion. Every shift is converted to decimal hours in real time.
• Overtime auto-calculated. Homebase tracks hours against your overtime thresholds and flags employees before they hit them.
• Break deductions handled. Set your break policies once and Homebase applies them automatically to every timesheet.
• One-click payroll export. When you're ready to run payroll, your hours are already converted, reviewed, and ready to go.

Kathleen Smith, founder of Smiling Tree Toys, knows the feeling: 

"Before Homebase I was manually tallying up my team's work hours and entering them into payroll, crossing my fingers I hadn't made any mistakes. Now our entire team logs in and out quickly and easily with the Homebase app, and all I have to do is send their hours to my payroll program with the click of a button."

Try Homebase free and see how much time you get back on your next payday.

‍

{{banner-cta}}

‍

FAQs about time card conversion

How do you convert minutes to payroll hours? 

To convert minutes to payroll hours, divide the minutes by 60 to get the decimal equivalent, then add that to the total hours worked. For example, 45 minutes ÷ 60 = 0.75, so 8 hours and 45 minutes becomes 8.75 payroll hours. That decimal figure is what you multiply by an employee's hourly wage to calculate pay.

Why do you divide minutes by 60? 

You divide minutes by 60 because there are 60 minutes in an hour. Dividing by 60 converts a portion of an hour into a decimal fraction of that hour — and that decimal is the only format payroll math can work with accurately.

What is .75 of an hour? 

.75 of an hour is 45 minutes. To confirm, multiply 0.75 × 60 = 45. So if an employee worked 9.75 hours, they worked 9 hours and 45 minutes.

How do you write 30 minutes on a timesheet? 

30 minutes on a timesheet is written as .50. An employee who worked 7 hours and 30 minutes would have 7.50 recorded on their timesheet — that's the decimal format payroll systems use to calculate wages.

How do you calculate overtime in decimal hours? 

To calculate overtime in decimal hours, take the employee's total decimal hours for the week and subtract 40. Any hours above 40 are overtime and must be paid at 1.5x the regular rate under the FLSA. For example, an employee who worked 42.75 hours has 2.75 hours of overtime.

Is there a time card conversion calculator? 

Yes — Homebase includes a free time card calculator that handles the conversion automatically. You can also use the formula above (minutes ÷ 60) manually, or set up the =HOUR(A1)+MINUTE(A1)/60 formula in Excel or Google Sheets.