QuickBooks Blog
manage employees

How to calculate hours worked

Calculating the hours worked by employees is vital to ensuring they receive an accurate paycheck. It can also help you measure the productivity of your workforce and ensure you comply with federal and state 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

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:

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 FLSA, employers are allowed to round up time worked by employees to the nearest quarter hour. This is to offset employees that don’t clock in or out on time. Time that’s between one and seven minutes may be rounded down, while time between eight to 14 minutes can be rounded up. If an employee clocks in at 8:06 AM, you can round down to 8:00 AM. If they clocked in at 8:09 AM, you can round up to 8:15 AM..

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 checks 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 Fair Labor Standards Act (FLSA) , 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 nonexempt employees at least the federal 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. Note that the U.S. Department of Labor doesn’t offer a definition for full-time or part-time employees. Instead, this distinction is left to employers to decide. Despite this, both full-time and part-time employees are protected under the FLSA, as long as they are nonexempt.

Full-time work

Since the FLSA requires employers to pay employees overtime wages for working more than 40 hours, many people consider this full-time work. However, full-time work will vary from company to company and state to state. For example, the California Department of Industrial Relations defines full-time employment as 40 hours per week. In contrast, the Texas Workforce Commission leaves it up to employers to decide.

Part-time work

For employees to be considered part-time workers, they will typically have to work less than full-time employees. This can range anywhere from 16 to 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 40 hours in a workweek must be paid one and a half times their regular rate of pay. So, if your employee earns $10.00 per hour and works 41 hours, you’d pay them $15 for that extra hour.

How to track employee hours

To remain compliant with the FLSA’s recordkeeping requirements, employers must keep a record of the hours worked by employees. However, the FLSA 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 paycheck 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 Enginecalculating 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.


Recommended for you

Mail icon
Get the latest to your inbox
No Thanks

Get the latest to your inbox

Relevant resources to help start, run, and grow your business.

By clicking “Submit,” you agree to permit Intuit to contact you regarding QuickBooks and have read and acknowledge our Privacy Statement.

Thanks for subscribing.

Fresh business resources are headed your way!

Looking for something else?

QuickBooks

From big jobs to small tasks, we've got your business covered.

Firm of the Future

Topical articles and news from top pros and Intuit product experts.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.