If you are an employer with hourly workers, it can be challenging to calculate pay if they work only a fraction of an hour. To pay employees working partial hours, you need to know how to convert minutes for payroll. Failing to calculate minutes for payroll causes errors and creates more work on the back end.
Converting minutes is simple if you know how to express minutes as decimals. Once time worked is converted into decimal form, such as 4.35 hours, you can multiply by the pay rate and find the total wages due. See our payroll minute conversion chart below for help.
Minute Conversion Chart
Minutes | Decimal Equivalent | Minutes | Decimal Equivalent |
|---|---|---|---|
1 | 0.02 | 31 | 0.52 |
2 | 0.03 | 32 | 0.53 |
3 | 0.05 | 33 | 0.55 |
4 | 0.07 | 34 | 0.57 |
5 | 0.08 | 35 | 0.58 |
6 | 0.10 | 36 | 0.60 |
7 | 0.12 | 37 | 0.62 |
8 | 0.13 | 38 | 0.63 |
9 | 0.15 | 39 | 0.65 |
10 | 0.17 | 40 | 0.67 |
11 | 0.18 | 41 | 0.68 |
12 | 0.20 | 42 | 0.70 |
13 | 0.22 | 43 | 0.72 |
14 | 0.23 | 44 | 0.73 |
15 | 0.25 | 45 | 0.75 |
16 | 0.27 | 46 | 0.77 |
17 | 0.28 | 47 | 0.78 |
18 | 0.30 | 48 | 0.80 |
19 | 0.32 | 49 | 0.82 |
20 | 0.33 | 50 | 0.83 |
21 | 0.35 | 51 | 0.85 |
22 | 0.37 | 52 | 0.87 |
23 | 0.38 | 53 | 0.88 |
24 | 0.40 | 54 | 0.90 |
25 | 0.42 | 55 | 0.92 |
26 | 0.43 | 56 | 0.93 |
27 | 0.45 | 57 | 0.95 |
28 | 0.47 | 58 | 0.97 |
29 | 0.48 | 59 | 0.98 |
30 | 0.50 | 60 | 1.00 |
Click below to download the payroll minute conversion chart for easy reference later.
Thank you for downloading!
Thank you for downloading!
💡 Quick Tip:
Rather than calculating payroll manually, consider Gusto, our top recommended payroll software for small businesses.
It’s a full-service payroll provider that helps ensure your pay stubs are calculated correctly and contains the required information for your state.
Start a free 30-day trial today.
What Is Time Sheet Conversion?
Time sheet conversion involves accurately calculating employee payroll by taking the time entered on a time sheet and performing a calculation to pay for the hours worked. To be sure you’re not overpaying or underpaying your employees, you must convert minutes worked into decimals.
You can use our minute calculator chart for time clock minutes conversion—showing you the corresponding decimal for minutes one through 60, which will help you calculate gross pay accurately and quickly based on actual hours worked.
Pro Tip: Before converting time sheet minutes for payroll, you’ll have to decide whether to use actual hours worked or rounded to the nearest quarter as federal law allows. It’s better to use actual hours because rounding can cause you to pay more than necessary for wages and overtime. See below for calculating both actual and rounded hours.
Steps to Convert Minutes for Payroll
Below are the steps you should follow to convert your employees’ minutes worked into decimal form and dollars to be paid.
Step 1: Calculate Total Working Hours & Minutes
Calculating total hours worked is usually straightforward if you have a time-tracking system (pen-and-paper, time clock, spreadsheet, etc.); however, if your policy requires you to round employee hours to the nearest quarter, as the Department of Labor allows, it can be tricky.
Actual Hours Worked
To calculate the actual time worked, simply total the hours and minutes between your employee’s starting and ending times for each workday. The sample time sheet below provides a good example of the information you’ll start with before converting minutes to decimal form.
Sample Time Sheet
Clock-in/ | 8 a.m. - 4 p.m. | 8:04 a.m - 4:10 p.m. | 8:03 a.m. - 4:07 p.m. | 8:08 a.m. - 3:50 p.m. | 8:01 a.m. - 3:58 p.m. |
Clock-out | 8 hrs | 8 hrs, 6 mins | 8 hrs, 4 mins | 7 hrs, 42 mins | 7 hrs, 57 mins |
Hours: 8 + 8 + 8 + 7 + 7 = 38 hours
Minutes: 0 + 6 + 4 + 42 + 57 = 109 minutes
(Convert 60 minutes of the 109 minutes to one hour to make it easier; 109 minutes – 60 minutes = 49 minutes; 38 hours + 1 hour = 39 hours)
38 hours + 109 minutes = 39 hours and 49 minutes
Rounding Hours Worked to Quarters
Federal law also gives employers the option to calculate wages using rounded hours worked when processing payroll. It’s up to you which method you prefer, but should you choose the rounding method, you need to know how to round correctly to maintain compliance.
You’re allowed to round employee time to the nearest quarter-hour. A quarter of an hour is 15 minutes, and there are four in each hour, i.e., 0:15, 0:30, 0:45, 0:00. If your employee clocks in at any time not in a quarter, you can round. However, you can only round up to the next quarter if the time is from eight to 14 minutes past the previous quarter. If your employee’s time is from one to seven minutes past the previous quarter, you must round back down.
Example (using the sample time sheet above)
On Tuesday, your employee clocks in at 8:04 a.m. He leaves at 4:10 p.m. and doesn’t take a break. The actual time worked is eight hours and six minutes. Rounded hours worked are eight hours and 15 minutes.
- 8:04 a.m. is rounded down because it’s not more than seven minutes past the previous quarter (8 a.m.).
- 4:10 p.m. is rounded up because it’s more than seven minutes past the previous quarter (4:15 p.m.).
- The employee’s timesheet would reflect 8 a.m. to 4:15 p.m.—nine minutes more than actual time worked.
The differences that arise with rounding your employees’ working hours can add up over time. In our example, it was in the employee’s favor, which meant you would be paying for more time than was logged. Paying for an additional nine minutes for three days a week throughout the 52 weeks in a year would equal an extra 468 minutes or seven hours and 48 minutes of non-working time you’d be paying for.
Pro Tip: The impact of rounding can be inconsistent each week, depending on your employees’ work habits, so it’s not the best idea to adopt a policy of rounding hours worked in hopes of manipulating it in your favor.
Step 2: Convert Minutes to Decimals
Converting minutes to decimals is as simple as dividing minutes by 60 (the number of minutes in an hour). The good news is you can skip that step if you use our time card minute conversion chart. In the chart, simply find the minutes worked, between one and 60, and the decimal equivalent will be to its immediate right. For instance, the decimal equivalent of 15 minutes is 0.25. Once you have the decimal, add it to the number of hours worked.
Let’s look at the sample timesheet again (see below) and convert Tuesday’s actual time worked to a decimal.
Sample Time Sheet
Monday | Tuesday | Wednesday | Thursday | Friday | |
|---|---|---|---|---|---|
Clock-in/ | 8 a.m. - 4 p.m. | 8:04 a.m. - 4:10 p.m. | 8:03 a.m. - 4:07 p.m. | 8:08 a.m. - 3:50 p.m. | 8:01 a.m. - 3:58 p.m. |
Clock-out | 8 hrs | 8 hrs, 6 mins | 8 hrs, 4 mins | 7 hrs, 42 mins | 7 hrs, 57 mins |
On Tuesday, the employee worked eight hours and six minutes. Per the payroll hours chart for time sheets, six minutes is the same as 0.10. Add the decimal to the number of hours worked to get the total time worked in numeric forms, like this:
8 hours + 0.10 hours = 8.10 hours
The employee worked 8.10 hours on Tuesday.
If converting minutes by hand is too time-consuming or complicated for your team, consider using payroll software that handles your timekeeping. Check out our highest-rated payroll software, most of which offers time tracking.
Step 3: Multiply Time Calculated & Wage Rate
Now you’re ready to use the time you converted into decimal form to calculate how much you need to pay your employee. Let’s assume the employee’s hourly wage is $14.25. Using the same sample timesheet, you owe $115.43 for the hours worked on Tuesday. See how we calculated that below.
$14.25 (hourly wage) x 8.10 (time in decimal form) = $115.43
For more help with payroll calculations, check out our article on how to calculate payroll
Methods for Tracking & Calculating Payroll Minutes
How you track working hours and what tools you use to calculate can ensure your payroll is accurate. There are several methods you can use to track your hours and minutes for payroll processing.
By Hand
Tracking and calculating hours and minutes worked for payroll by hand is one method. To do this, simply write down all hours and minutes worked and then follow the formulas above to calculate your hours for payroll. I don’t recommend this method, however, because it leaves room for many errors, such as incorrect hours recorded and inaccurate mathematical calculations.
Time Tracking Software
Probably the best method for calculating your hours and minutes for payroll is using time tracking software. This type of software has built-in calculations to ensure accuracy. It will also allow you to track projects and bill clients.
Pricing can range from a few dollars per employee ($4 – $20) to a monthly fee ($20 – $100). It may be worth the small expense to ensure your time calculated is accurate for payroll.
Spreadsheet
If you are unable to afford time tracking software, you can use a spreadsheet that will calculate for you. Simply input your hours and minutes into the spreadsheet and then either make the calculations yourself or run a formula to calculate for you. All spreadsheet software will allow you to automatically calculate cells, ensuring accuracy.
Frequently Asked Questions (FAQs)
Every 60 minutes worked is equal to one hour. Simply add up the total minutes worked and divide by 60 to get an accurate number of hours plus minutes worked. For example, a part-time employee who worked 1,245 minutes in a week will have worked a total of 20.75 hours (1,245 / 60). Based on the payroll time conversion table, this equals 20 hours and 45 minutes.
The easiest way to do this is to calculate the total hours and minutes worked and then convert the minutes into decimals. From there, you can multiply the time calculated by the wage rate to get the total amount due. For example, 20 hours and 45 minutes worked is converted to 20.75 and then multiplied by the employee’s hourly rate.
Simply, it is a chart that converts minutes to decimals. Once you have converted the minutes to decimals you can multiply that by the employee’s hourly rate to get their total amount due.
Other Calculators
https://fitsmallbusiness.com/time-card-calculator/
https://fitsmallbusiness.com/how-to-calculate-gross-pay/
https://fitsmallbusiness.com/how-to-calculate-overtime/
https://fitsmallbusiness.com/retro-pay-calculator/
https://fitsmallbusiness.com/how-to-do-payroll-in-excel/
https://fitsmallbusiness.com/track-employee-hours/
