How to Calculate Hours Worked Like a Pro

In 2026, the safest way to calculate hours worked is to follow a clear process: record start and end times, subtract unpaid breaks, convert minutes to decimals, apply overtime rules, review the timecard, and send the final hours to payroll. That keeps wages accurate and helps your team avoid payroll mistakes.

As simple as that sounds, many small businesses still end up doing late-night payroll math, fixing missed punches, checking lunch breaks, and wondering if the final numbers are right.

This guide walks you through the OnTheClock 6-Step Hours Worked Method so you can calculate employee hours with less stress and more confidence. You’ll also see simple examples, common mistakes to avoid, and ways to make the process easier before the next payroll run.

The short answer: how to calculate hours worked in 60 seconds

To calculate hours worked, write down the employee’s start and end times, convert both times to 24-hour time, subtract the start time from the end time, remove unpaid breaks, convert minutes to decimals, and add each workday together for the full pay period.

Here’s the OnTheClock 6-Step Hours Worked Method:

1. Note the start and end time. Write down when the employee clocked in and clocked out.
2. Convert the times to 24-hour time. For example, 5:30 p.m. becomes 17:30.
3. Subtract the start time from the end time. This gives you the total time on the clock.
4. Remove unpaid breaks. Subtract unpaid lunch breaks or other unpaid time.
5. Convert minutes to decimals. Divide minutes by 60 so payroll can use the number.
6. Add each day together. Total all worked hours across the pay period.

For example, if an employee starts working at 8:15 a.m. and clocks out at 5:30 p.m., they were on the clock for 9 hours and 15 minutes. If they took a 30-minute unpaid lunch, that leaves 8 hours and 45 minutes of paid work time. For payroll, convert the 45 minutes to a decimal by dividing 45 by 60. The final total is 8.75 hours.

If you don’t want to do the math by hand, skip to the OnTheClock Time Card Calculator and enter the start time, end time, and break length.

What counts as hours worked?

Hours worked means any time an employee must be paid for because they were working or under the employer’s control. This includes more than normal clock-in and clock-out time.

Under the FLSA and 29 CFR §785.11, employers usually must pay for time they “suffer or permit” an employee to work. In simple terms, if the employer allows the work to happen, that time may count as paid time.

What usually counts as paid time

These hours usually count as hours worked:

• Regular work time: Time spent doing job duties at the workplace, job site, or office.

• Required training: Meetings, safety classes, or training the employer says the employee must attend.

• Travel during the workday: Driving from one job site to another after the shift has started.

• Setup or cleanup time: Opening the store, preparing tools, cleaning up, or closing down.

• Waiting time while on duty: Time spent waiting for work while the employee is still required to be available.

• Controlled on-call time:

  Time when the employee cannot freely use their time because of work rules.

A good rule is this: if the employee is working, waiting for work, or limited by the employer, the time may need to be paid.

What usually does not count as paid time

These hours usually do not count as paid work time:

• Unpaid meal breaks: A lunch break usually does not count if the employee is fully relieved from work.

• Voluntary training: Training may be unpaid if it is optional, outside normal work hours, and no work is done.

• Normal commute time: Driving from home to the first work location usually does not count.

• Personal time before or after work: Time spent getting coffee, waiting in the parking lot, or staying after work for personal reasons.

• Free on-call time: On-call time may not count if the employee can use the time for personal activities.

How to calculate hours worked in 6 steps

Calculating hours worked is easier when you follow the same process every time. Instead of checking timecards one by one and hoping the math is right, use a simple step-by-step system.

Here’s the OnTheClock 6-Step Hours Worked Method we recommend for small businesses. It keeps the math clear, helps you catch mistakes, and makes payroll less stressful.

Step 1: Record the start and end time of each work period

The first step is to record the exact time the employee started and stopped working. Do this before you subtract breaks, convert minutes, or calculate overtime.

For payroll, exact times matter. If Maria clocks in at 9:13 a.m., record 9:13 a.m., not 9:15 a.m. You can apply a legal rounding policy later, but the original time record should show what actually happened.

Under FLSA recordkeeping rules, employers must keep accurate records for non-exempt employees, including hours worked each workday and total hours worked each workweek. The law does not require one specific format, so you can use paper time cards, a digital time clock, or time-tracking software.

A clear record should include:

• The employee’s start time

• The employee’s end time

• Any unpaid break time

• The total hours worked for the day

• Any corrections or missed punches

Some businesses round time to the nearest five minutes, tenth of an hour, or quarter hour. Federal rules may allow rounding if it averages out fairly over time and does not favor the employer. Still, we recommend recording the exact punch first, then applying your rounding rule consistently.

Step 2: Convert each time to a 24-hour (military) format

Next, convert the start and end times to 24-hour time, also called military time. This step helps you avoid AM and PM mistakes when you subtract hours.

In 24-hour time, morning hours stay mostly the same. Afternoon and evening hours change by adding 12.

For example:

• 9:15 a.m. becomes 09:15

• 1:00 p.m. becomes 13:00

• 5:30 p.m. becomes 17:30

• 6:00 p.m. becomes 18:00

• Midnight is usually 00:00, or 24:00 in some payroll systems

Here is Maria’s timecard example:

Maria clocks in at 9:15 a.m. and clocks out at 6:00 p.m.

In 24-hour time, that becomes:

• Start time: 09:15

• End time: 18:00

Now the math is easier because you are subtracting two times from the same format.

Step 3: Subtract the start time from the end time

Now subtract the start time from the end time to find the total time worked before breaks.

The basic formula is simple:

End time − start time = elapsed work time

For Maria, the start time is 09:15 and the end time is 18:00.

18:00 − 09:15 = 8 hours and 45 minutes

That means Maria was on the clock for 8 hours and 45 minutes before any unpaid breaks are removed.

If the minutes do not subtract cleanly, borrow 1 hour from the end time. For example, if an employee works from 09:45 to 17:20, you cannot subtract 45 from 20. So, borrow 1 hour from 17:20 and turn it into 16:80.

Step 4: Subtract unpaid breaks

Next, subtract any unpaid breaks from the total time worked. This gives you the employee’s paid work time for the day.

The basic formula is:

Total time on the clock − unpaid breaks = paid hours worked

Under DOL rules, a real meal break is usually unpaid if it lasts about 30 minutes or more and the employee is completely relieved from work. Short rest breaks, usually 5 to 20 minutes, are different. Those breaks usually count as paid time and stay in the total.

Here is Maria’s example:

• Maria worked from 09:15 to 18:00.

• That equals 8 hours and 45 minutes on the clock.

• Maria also took a 45-minute unpaid lunch.

So the math is:

8 hours 45 minutes − 45 minutes = 8 hours paid

Maria’s paid time for the day is 8 hours.

A short coffee break works differently. If Maria takes a 15-minute paid rest break, you do not subtract it. That time stays in her paid work hours.

Step 5: Convert the remaining time to decimal hours

Next, convert the remaining time into decimal hours. Payroll usually uses decimals, not hours and minutes.

For example, payroll systems read 8 hours and 30 minutes as 8.50 hours. That format makes it easier to calculate wages, overtime, and total hours for the pay period.

The formula is simple:

Minutes ÷ 60 = decimal hours

For Maria, the math is easy. After subtracting her unpaid lunch, she has 8 hours and 0 minutes of paid time.

That converts to:

8 hours 0 minutes = 8.00 hours

Quick reference: minutes-to-decimal-hours conversion chart

Use this minutes-to-decimal-hours conversion chart when you need to turn minutes into payroll-ready decimal hours. This is helpful when you calculate hours worked by hand, check a timecard, or review payroll totals before submitting them.

Step 6: Add the daily totals to get hours worked for the pay period

Finally, add each daily total to calculate total hours worked for the week or pay period.

If you run weekly payroll, add the hours for each day in that week. If you run biweekly payroll, add the daily totals for all 14 days, but review overtime one week at a time.

That part matters. Under the FLSA, overtime is based on a fixed 7-day workweek, not the full pay period. A workweek can start on any day and at any hour, but it must be a fixed 168-hour period. You cannot average two weeks together to avoid overtime.

Here is Maria’s weekly example:

Maria worked 40.50 hours for the week. Since she worked 0.50 hours over 40, that extra half hour may count as overtime under federal rules.

Ways to track hours worked (and which method fits your business)

The best way to track hours worked depends on your team size, work setup, and how much time you want to spend fixing payroll errors.

A very small business may be able to use paper time cards for a while. A team with multiple shifts, job sites, or payroll rules usually needs something more reliable. The goal is simple: track time clearly, reduce mistakes, and make payroll easier to run.

Handwritten time cards

Handwritten time cards are the simplest way to track employee work hours. Employees write down when they start, stop, and take unpaid breaks.

This method can work for very small teams with simple schedules. For example, a small office with two part-time employees may not need a full system right away.

The downside is that paper time cards are easy to lose, misread, or change. Managers may also spend extra time checking handwriting, adding totals, and asking employees to fix missing information.

Spreadsheets (Excel and Google Sheets)

Spreadsheets are a step up from paper because they can calculate totals for you. You can use Excel or Google Sheets to enter start times, end times, unpaid breaks, and daily totals.

This method works well for businesses that want more structure but are not ready for time-tracking software. It also gives managers a simple place to review weekly or biweekly hours.

The risk is that spreadsheet formulas can break. A deleted cell, wrong time format, or copied formula can change payroll totals without anyone noticing. Spreadsheets also do not stop employees from entering wrong times.

For example, a five-person dental office may use Google Sheets to track clock-in times, lunch breaks, and total weekly hours. That can work, but the office manager still needs to check every row before payroll.

Time-tracking software

Time-tracking software is the best fit when manual tracking starts costing too much time. It records clock-ins, clock-outs, breaks, edits, overtime, and payroll totals in one place.

This method works well for businesses with hourly employees, changing schedules, multiple locations, or frequent missed punches. It also helps managers see problems before payroll day instead of after.

For example, OnTheClock can help employees clock in from a phone, computer, or kiosk. Managers can review timecards, approve edits, track breaks, and export hours to payroll. That reduces late-night payroll math and gives the team a cleaner record.

Time-tracking software may fit your business if:

• You manage hourly employees

• Your team works different shifts

• Employees work at more than one location

• You need GPS or geofencing

• You want easier payroll exports

• You spend too much time fixing timecards

Time-tracking software does not remove your responsibility to review hours. It does make the process faster, cleaner, and easier to audit.

4

Overtime starts when a nonexempt employee works more than 40 hours in one fixed workweek under the FLSA. Federal overtime pay is at least 1.5 times the employee’s regular rate of pay for each overtime hour. A workweek is a fixed 7-day period, and it does not have to start on Sunday.

To calculate overtime, look at the employee’s total hours for that workweek. Any hours over 40 are overtime hours.

For example, if Maria works 40.5 hours in one workweek and earns $20 per hour, she has 0.5 overtime hours. Her overtime rate is $30 per hour, because overtime is paid at time and a half.

That means Maria earns $800 for her first 40 hours and $15 for the extra half hour of overtime. Her total gross pay for the week is $815.

However, some states have different overtime rules. California, for example, generally has daily overtime rules for hours worked over 8 in a day. Always check your state rules before running payroll.

How to calculate hours worked with lunch and unpaid breaks

To calculate hours worked with lunch, first find the total time between clock-in and clock-out. Then subtract any unpaid meal breaks the employee actually took.

For example, if Maria works from 8:30 a.m. to 5:00 p.m., she is on the clock for 8 hours and 30 minutes. If she takes a 30-minute unpaid lunch, her paid time is 8 hours.

The key is to separate paid breaks from unpaid breaks.

Short rest breaks usually stay in the paid total. A 10-minute or 15-minute break is usually paid time, so you do not subtract it from the timecard.

Meal breaks are different. A lunch break is usually unpaid when the employee is fully relieved from work. That means they are not answering phones, helping customers, watching the front desk, driving, or doing any other job duties during lunch.

How to calculate pay from hours worked

To calculate pay from hours worked, multiply the employee’s paid hours by their hourly rate. If the employee has overtime, calculate regular pay first, then add overtime pay.

For a simple week with no overtime, the math is easy.

If Maria works 38 hours and earns $20 per hour, her gross pay is $760 before taxes and deductions.

That means:

38 hours × $20 per hour = $760

If Maria works overtime, separate the regular hours from the overtime hours.

For example, if Maria works 40.5 hours and earns $20 per hour, her first 40 hours are paid at her regular rate. The extra 0.5 hours are paid at her overtime rate.

• Her regular pay is $800.
• Her overtime rate is $30 per hour, because overtime is paid at time and a half.
• Her overtime pay is $15 for the extra half hour.

So Maria’s total gross pay is:

$800 regular pay + $15 overtime pay = $815

That is her gross pay before taxes, benefits, deductions, or payroll withholdings.

How OnTheClock calculates hours worked automatically

OnTheClock makes it easier to calculate hours worked because the system records time as employees clock in, clock out, and take breaks. Instead of adding hours by hand, managers can review timecards, approve edits, and send clean totals to payroll.

Here’s how it works:

1. Employees clock in and out. Employees can clock in from a phone, computer, or shared kiosk. OnTheClock records the start and end time for each work period.
2. Breaks are tracked separately. Lunches and unpaid breaks can be recorded on the timecard. This helps separate paid work time from unpaid break time.
3. Daily totals are calculated automatically. OnTheClock adds the time between clock-in and clock-out, subtracts unpaid breaks, and shows the total paid hours for each day.
4. Weekly totals are added for payroll. The system adds daily totals across the pay period, so managers can see regular hours, overtime hours, and total hours worked.
5. Managers review and approve edits. If an employee misses a punch, the timecard can be corrected before payroll. This helps prevent mistakes from reaching the paycheck.
6. Hours are exported to payroll. Once timecards are approved, the totals can be sent to payroll instead of being typed in manually.

This saves time for managers who are tired of checking math, fixing spreadsheets, and chasing missing timecards before payroll.

Common mistakes that throw off your hours-worked totals

Small time-tracking mistakes can turn into payroll errors fast. The most common problems usually come from bad time formats, unclear break rules, missed punches, or overtime being calculated in the wrong window.

Here are the mistakes we recommend checking before you approve timecards.

Using AM/PM math instead of 24-hour time

AM/PM math can cause simple mistakes, especially with afternoon, evening, or overnight shifts.

For example, subtracting 9:00 a.m. from 5:00 p.m. is easier when the times are written as 09:00 to 17:00. The 24-hour format removes the guesswork and makes the math cleaner.

Rounding time in a way that favors the employer

Rounding can create problems if it always benefits the business. For example, rounding clock-ins forward and clock-outs backward can reduce paid time unfairly.

If you use rounding, the rule should be consistent and fair over time. It should not regularly cut employee hours.

Treating short rest breaks as unpaid

Short rest breaks are usually paid time. A 10-minute or 15-minute break should normally stay in the employee’s paid total.

Meal breaks are different. A lunch break can usually be unpaid only when the employee is fully relieved from work.

Calculating overtime by pay period instead of workweek

Overtime is based on the workweek, not the full pay period. This matters a lot for biweekly payroll.

For example, if Maria works 45 hours in week one and 35 hours in week two, she still has 5 overtime hours in week one. You cannot average the two weeks to make it 80 regular hours.

Not documenting missed punches

Missed punches happen. Employees forget to clock in, forget to clock out, or take lunch without recording it.

The problem is not the missed punch itself. The problem is changing the timecard without a clear record.

Frequently asked questions about calculating hours worked

How do you calculate hours worked from clock-in to clock-out?

To calculate hours worked from clock-in to clock-out, subtract the employee’s start time from their end time. Then subtract any unpaid meal breaks.

For example, if an employee works from 8:30 a.m. to 5:00 p.m., they were on the clock for 8 hours and 30 minutes. If they took a 30-minute unpaid lunch, their paid time is 8 hours.

Short paid breaks usually stay in the total. Unpaid lunch breaks usually come out of the total.

What is the formula to calculate hours worked?

The basic formula is:

End time − start time − unpaid breaks = hours worked

For payroll, convert the final time into decimal hours.

For example, 8 hours and 45 minutes becomes 8.75 hours because 45 minutes equals 0.75 of an hour.

If you use a spreadsheet, 24-hour time can make the math easier and help prevent AM/PM mistakes.

Do you subtract lunch breaks from hours worked?

Yes, you usually subtract lunch breaks if the break is unpaid and the employee is fully relieved from work.

That means the employee is not answering phones, helping customers, driving between job sites, watching the front desk, or doing any other work during lunch.

For example, if Maria works 9 hours and takes a 1-hour unpaid lunch, her paid time is 8 hours.

Do not subtract lunch automatically. Only subtract it when the employee actually took the break.

How do you calculate overtime hours?

To calculate overtime hours, review the employee’s total hours in one fixed workweek. Under federal rules, most nonexempt employees earn overtime after 40 hours in a workweek.

For example, if Maria works 42 hours in one workweek, she has 2 overtime hours.

A workweek is a fixed 7-day period. It does not have to start on Sunday. If you run biweekly payroll, check each week separately instead of averaging both weeks together.

Note: Some states have different overtime rules. California, for example, generally has daily overtime rules after 8 hours in a day.

How do I calculate hours worked in Excel or Google Sheets?

To calculate hours worked in Excel or Google Sheets, enter the start time, end time, and unpaid break time in separate cells. Then subtract the start time and break time from the end time.

A simple setup could look like this:

Use 24-hour time if your team works afternoon, evening, or overnight shifts. It helps prevent errors with AM and PM.