How to calculate hours worked

Calculating the hours worked by employees is vital to ensuring they receive an accurate paycheque. It can also help you measure the productivity of your workforce and ensure you comply with government time- tracking laws. While determining how many hours employees work can be a complex subject, time-tracking tools can make the process easier.

In this article, we’ll cover how to calculate hours worked from start to finish, dive into the importance of calculating hours worked, and the tools you can use to do it. Use the links below to navigate the post or continue reading to learn everything you need to know about determining hours worked.

• How to calculate hours worked: Step-by-step instructions
• How to track employee hours
• Wrapping up

How to calculate hours worked: Step-by-step instructions

To help you accurately calculate hours and minutes worked, we’ve provided this step-by-step guide. Note that the instructions below may change slightly depending on your needs.

1. Choose a recording method

Start calculating time worked by first choosing a method to record time. Here are a few of the most common methods:

• Manual timesheets
• Time tracking apps
• Digital time clock

We’ll cover these time-tracking methods in more detail later on.

2. Set a start and end time

When tracking hours worked, you’ll have to set a start and end time. This will be the time your staff clocked in and out each workday. For instance, if an employee works a shift from 8 AM. to 5 PM.

3. Set a rounding policy

Per the Labour Law, employers are allowed to round up time worked by employees with a fraction of an hour rounded up or down to the nearest full half-hour. This is to offset employees that don’t clock in or out on time. Anything fifteen minutes or greater and less than forty-five minutes rounds to the half hour -3:15 and 3:44 round to 3:30 . Anything forty-five minutes or greater and less than fifteen minutes rounds to the hour – 2:45 and 3:14 round to 3:00.

4. Convert time to military time

If you’re unfamiliar with military time, it’s a way of converting the 12-hour format to a 24-hour format. To do this, simply add 12 hours to times ranging between 1 PM and 11:59 PM. Any times outside of this range will be left unchanged. Here are a few examples:

• 7:00 AM is 7:00
• 9:30 AM is 9:30
• 12:00 PM is 12:00
• 1:00 PM is 13:00
• 5:00 PM is 17:00
• 11:59 PM is 23:59
• 12:00 AM is 0:00
• 1:00 AM is 1:00

Since you’ll no longer have to use AM and PM, distinguishing the times employees start and end their shifts will be easier.

5. Convert minutes to decimals

You’ll then have to convert minutes worked to decimals by dividing them by 60. You’ll find the formula below:

minutes worked ÷ 60

If you had to convert 8:30 to a decimal, you would divide 30 by 60 to get .50. This would make the time 8.50.

6. Subtract start time from the end time

Converting minutes to a decimal value makes it simpler to subtract the start time and end time.

Let’s say an employee clocked in at 8:30 AM and clocked out at 5:30 PM, or 8:30 and 17:30. When you convert the minutes to decimals, you’ll get 8.50 and 17.50. Then, you’ll subtract:

17.50 – 8.50 = 9

7. Subtract unpaid time for breaks

Make sure to take into account unpaid breaks or time off when you subtract the start time from the end time. This allows you to pay employees for billable hours only. Unpaid breaks are typically any time where employees aren’t actively carrying out their job duties, such as meal periods.

Using the example from the last step, you’d subtract a one-hour lunch break from the total calculated.

9 – 1 = 8

So, this particular employee worked 8 hours.

8. Complete a table of weekly hours

Once you calculate how many hours employees worked in a day, you can create a table to determine their weekly hours. You’ll be able to see how much an employee has worked each week and note if it aligns with company policies. This also makes calculating employee cheques much easier.

If you’re looking for an inexpensive way to calculate hours worked per week while avoiding tedious calculations, check out our free timesheet calculator. The time card calculator is easy to use, allowing you to input various pieces of data, including pay rates, unpaid breaks, and overtime rates. Then, you can download a CSV (comma-separated values) file of the table to retain for your records.

What are hours worked?

According to the Labour Law, hours worked is any time during which an employee performs their job requirements. This includes being on duty at the employer’s premises or working remotely. Employers must pay non exempt employees at least the national minimum wage for all hours worked, with the exception of meal periods. Also, employees that voluntarily work off the clock to complete tasks and projects are entitled to receive compensation for this time.

How many hours employees work typically depends on whether they’re full-time, part-time, or required to stay past the end of their shift. To clarify, whereas a full-time employee typically works an average of 45 hours a week and typically receives a steady income, a part-time employee will work less than 34 hours a week and may not be entitled to the same benefits as their full-time coworkers. both full-time and part-time employees are protected under the Labour Relations Act (LRA) and the Basic Conditions of Employment Act (BCEA), as long as they are nonexempt.

Full-time work

As per the Basic Conditions of Employment Act all hours worked in excess of the employee’s normal daily or weekly hours of work will be regarded as overtime hours. Therefore if an employee is contracted to work 45 hours per week normal time, then any hours in excess of that is overtime. Part-time work

For employees to be considered part-time workers, they will typically have to work less than 34 hours per week. Just like for full-time work, this will depend on the employer. Part-time employees may also have little to no benefits, such as health care coverage or paid time off.

Overtime work

Nonexempt employees who work more than 45 hours in a workweek must be paid one and a half times their regular rate of pay. So, if your employee earns R10.00 per hour and works 41 hours, you’d pay them R15 for that extra hour.

How to track employee hours

To remain compliant with the The Basic Conditions of Employment Act (BCEA), employers must keep a record of the hours worked by employees. However, the BCEA doesn’t require you to track these hours in any particular way as long as times accurately reflect time worked.

The method you choose to track hours will ultimately depend on a few factors such as business size, number of employees, and company budget. That said, here are a few tools for tracking employee hours to help you get started:

• Manual timecards. Manual timecards are timecards that employees must fill out by hand whenever they clock in and out of work. Employees can do this on paper or in an Excel spreadsheet.
• Mechanical time clock. A mechanical time clock allows employees to place a paper timecard into a machine where it’ll automatically stamp the date and time of their shift.
• Electronic time clock. An electronic time clock works similarly to a mechanical time clock, except that it’s digitally managed. So, employees will scan a badge, input a pin, or scan their fingerprint to punch in and out.
• Time clock software. With time-tracking software, employees can clock in and out from virtually any device via an online application or website portal. One such software is QuickBooks Time, which can help you streamline employee time tracking.

When you decide on a time-tracking tool, pair it with our free paycheque calculator to determine gross pay and withholdings for your employees.

Wrapping up

Ensuring employees receive accurate wages time after time is essential. While calculating employee hours may seem like a straightforward process, it can become challenging to make these calculations by hand as your workforce grows. Manual work can make the process of calculating employee hours tedious and overwhelming, costing you valuable resources and time.

However, one of the most efficient ways to track employee hours and count hours worked is by using time-tracking software. QuickBooks Time is a robust time-tracking system that allows office and remote employees and freelancers to clock in and out with just one click. Plus, with the QuickBooks Time Pay Rate Engine, calculating overtime pay doesn’t have to be a headache.

Get started today with QuickBooks Time and see how it can help you streamline and simplify employee timesheets.