How to Calculate Payroll Hours

Actual time calculation

You can choose to calculate on the basis of the exact hours worked, but you need to make sure that your time tracking solution allows it.

This is how the calculation works:

You first need to add the whole hours, which means 5 days multiplied by 8 hours. This adds up to 40 hours for the week.

Then you have to add the minutes. In this case: 13+7+4+9+2 = 35 minutes

The total hours for the week come up to 40 hours and 35 minutes. This addition is correct, but you cannot use it for payroll calculation, as the time is not in decimal format.

Rounded time calculation

You might decide to use rounding in your payroll calculations. While the practice of timesheet rounding is legal under federal law in the U.S., you need to follow strict rules as to how you apply it.

You cannot round to more than 15-minute intervals. This means that you can use the following minutes after an hour: :00, :15, :30 and :45. When an employee has clocked in or out at times different from the 15-minute intervals, you can round to the nearest one, which can be either up or down.

You also have to follow the 7-minute rule if you’re applying 15-minute rounding. It states that if a logged time is within 7 minutes from such an interval, you have to round down. If it is above 7 minutes, you have to round up.

Here are some examples:

1. The logged time is 9:07 am. You have to round down to 9:00 am.

2. The logged time is 9:08 am. In this case, you have to round up to 9:15 am.

After you round up or down, you have to subtract the clock-in time from the clock-out time to receive the number of hours and minutes that an employee has worked during a specific day.

Let’s say the person clocked in at 9:08 am, which is rounded to 9:15 am, and clocked out at 5:28 pm, which is rounded to 5:30 pm.

• First you need to convert all hours in the 24-hour format, so 5:30 pm becomes 17:30.

• Then you subtract 9:15 from 17:30, and the result is 8:15.

• This means that the employee worked 8 hours and 15 minutes. Don’t forget that this has to be converted to decimal format before you use it for payroll calculation.

You can also use other rounding options, such as 5-minute or 6-minute rounding. In both cases, the rounding should be either up or down, depending on whether the logged time hits the half-interval mark.

The guiding principle for your rounding system is that it should never harm the interests of your employees. Failing to protect their right to fair payment can result in wage theft accusations and trials. You can set up rounding that’s only in your employees’ favor, but you cannot legally round time always in your interest. A tried-and-true way that you can opt for is to round the clock-in time in favor of the employee, and the clock-out time in your favor.

Whichever method you choose — actual or rounded hours calculation — you have to keep in mind that if an employee has worked more than 40 hours per week, you are legally responsible for overtime pay. It’s typically 1.5 times the regular wage rate per hour. There may be other cases in which you need to use the overtime rate, such as weekend working hours or other special occasions.

Payroll time conversion

The next issue that you need to tackle is how to calculate hours and minutes for payroll. Whether you’ve used actual or rounded timesheet hours, you will end up with the logged time in the format of hours and minutes.

However, if you calculate this time with the wage rate, you will not get the correct final payroll cost. You have to convert the minutes into decimals, or parts of one hour. This is necessary, as the wage rate is formulated per one hour.

In order to convert minutes into decimal values, you have to divide the minutes logged by 60 minutes.

Here’s an example. If an employee has logged 8 hours and 20 minutes, you need to divide 20 minutes by 60. The result is 0.33. So the time in decimal format is 8.33 hours. This is the number that you can use in the next step, where you multiply by the wage rate.

Credit: Patriot Software

Final payroll cost per employee

When you have the timesheet hours for a certain employee and you have converted the time in decimal format, you can move to the final step of the calculation. It entails multiplying the wage rate that’s been agreed by the hours worked, which are in decimal format.

Here is a simple payroll calculations formula:

The weekly payment for this employee before tax deductions is $764.

You can calculate the final cost manually, or by using an employee payroll calculator online. If you’re using a weekly payroll calculator, you will have to input the hours worked for one week, but you can also find options for bi-weekly calculations.

When you’re considering how to calculate paychecks for your staff, keep in mind that the total pay that you will come up with does not account for taxes and deductions, i.e. this is the gross pay of the respective employee. The most typical deductions you will need to subtract before payouts include insurance premiums, retirement contributions, child support payments, and union membership fees, among others. You will also need to withhold and remit federal, state, and local income taxes, as well as social security and Medicare, to get the final payment that an employee will receive.