Timesheet Hours Explained: Clock-In to Payroll

Timesheet hours are the hours an employee records as working time during a shift, day, or workweek. Accurate timesheets help employees track their schedules and give employers the information needed to calculate wages and payroll.

The basic calculation is simple:

Hours Worked = End Time − Start Time − Applicable Unpaid Breaks

For example, if you clock in at 9:00 AM and clock out at 5:00 PM with a 30-minute unpaid break:

8 hours − 0.5 hours = 7.5 hours

So, your actual working time is 7 hours 30 minutes, or 7.50 decimal hours.

The U.S. Department of Labor requires covered employers under the FLSA to maintain accurate records that include hours worked each day and total hours worked each workweek. U.S. Department of Labor: Recordkeeping Requirements

What Are Timesheet Hours?

Timesheet hours are the amount of time recorded as work during a specific period.

A timesheet may include:

• Clock-in time

• Clock-out time

• Breaks

• Daily hours

• Weekly hours

• Overtime hours

• Regular hours

• Work dates

• Sometimes hourly pay rates

For example:

Weekly total:

7.5 × 5 = 37.5 hours

How to Calculate Timesheet Hours

The easiest method is to calculate each shift separately.

Step 1: Record the Clock-In Time

Write down when you started working.

Example:

Start: 8:30 AM

Step 2: Record the Clock-Out Time

Write down when your shift ended.

End: 4:30 PM

Step 3: Calculate the Total Shift

From 8:30 AM to 4:30 PM is:

8 hours

Step 4: Subtract Applicable Unpaid Breaks

Suppose you took a 30-minute unpaid lunch.

8 hours − 30 minutes = 7 hours 30 minutes

Step 5: Convert to Decimal Hours if Needed

30 minutes equals:

30 ÷ 60 = 0.50 hours

Therefore:

7 hours 30 minutes = 7.50 hours

Clock-In to Clock-Out Example

Suppose an employee works:

Clock-in: 9:15 AM
Clock-out: 5:45 PM

The total time is:

8 hours 30 minutes

If the employee takes a 30-minute unpaid break:

8 hours 30 minutes − 30 minutes = 8 hours

The timesheet should therefore show 8 hours worked for that shift, assuming the break is not counted as working time.

How to Calculate Timesheet Hours With Breaks

Breaks are one of the most common sources of timesheet mistakes.

Suppose your schedule is:

8:00 AM–5:00 PM

That is a total of:

9 hours

If you take a one-hour unpaid lunch:

9 − 1 = 8 hours

Your working time is therefore 8 hours.

Always determine whether a break is paid or unpaid according to the applicable workplace rules before deducting it.

How to Convert Timesheet Hours to Decimal Hours

Many payroll and timekeeping systems use decimal hours.

The formula is:

Decimal Hours = Whole Hours + (Minutes ÷ 60)

For example:

7 hours 30 minutes

Convert the minutes:

30 ÷ 60 = 0.50

Then:

7 + 0.50 = 7.50 hours

Common Timesheet Conversions

Important: 30 Minutes Is Not 0.30 Hours

A common mistake is entering:

7 hours 30 minutes = 7.30

That is incorrect for decimal-hour calculations.

The correct calculation is:

30 ÷ 60 = 0.50

So:

7 hours 30 minutes = 7.50 hours

For more examples of converting time for payroll, see this guide on converting minutes to decimal hours.

How to Add Timesheet Hours for a Week

Once you calculate each day's working time, add the daily totals.

For example:

• Monday: 7.5 hours

• Tuesday: 8 hours

• Wednesday: 7.5 hours

• Thursday: 8 hours

• Friday: 7 hours

Add them:

7.5 + 8 + 7.5 + 8 + 7 = 38 hours

The employee worked 38 hours that week.

If your timesheet contains hours and minutes rather than decimals, you can add the hours and minutes separately.

For example:

7h 30m + 8h 15m + 7h 45m

Add the hours:

7 + 8 + 7 = 22 hours

Add the minutes:

30 + 15 + 45 = 90 minutes

Convert 90 minutes:

90 minutes = 1 hour 30 minutes

Total:

23 hours 30 minutes

How to Calculate Timesheet Hours for Multiple Shifts

Some employees work more than one shift in a day.

For example:

Morning: 8:00 AM–12:00 PM
Evening: 4:00 PM–9:00 PM

Morning shift:

4 hours

Evening shift:

5 hours

Total:

4 + 5 = 9 hours

The time between 12:00 PM and 4:00 PM is not working time.

For complicated schedules involving split shifts or overnight work, calculate each shift separately before adding the results.

How to Calculate Overnight Timesheet Hours

Overnight shifts can be confusing because the shift crosses midnight.

Suppose you work:

10:00 PM–6:00 AM

Break the calculation into two parts.

Before Midnight

10:00 PM to 12:00 AM:

2 hours

After Midnight

12:00 AM to 6:00 AM:

6 hours

Total:

2 + 6 = 8 hours

If you have a 30-minute applicable unpaid break:

8 − 0.5 = 7.5 hours

Your total working time is 7.5 hours.

How Timesheet Hours Connect to Payroll

Once working hours are recorded, they can be used as part of a payroll calculation.

For a basic hourly employee:

Gross Pay = Hours Worked × Hourly Rate

For example:

40 hours × $20/hour = $800

So the basic gross pay is $800 before applicable taxes, deductions, benefits, overtime adjustments, or other payroll items.

If overtime applies, regular and overtime hours may need to be calculated separately.

A timesheet therefore provides the time information needed for the next stage of payroll processing.

Regular Hours vs. Overtime Hours

Regular and overtime hours are not necessarily the same thing as total timesheet hours.

For example, suppose an employee records:

45 hours

If a particular calculation uses a 40-hour weekly threshold, the breakdown would be:

40 regular hours + 5 overtime hours

However, overtime eligibility and calculation rules depend on the applicable law, employee classification, and other circumstances. Do not assume that every employee's overtime calculation follows the same rule.

How to Calculate Weekly Timesheet Hours

If you work the same number of hours every day, you can use a simple formula:

Weekly Hours = Daily Hours × Number of Workdays

For example:

7.5 hours × 5 days = 37.5 hours

If your schedule changes each day, add the individual daily totals instead.

For example:

Monday: 8 hours
Tuesday: 7.5 hours
Wednesday: 9 hours
Thursday: 8 hours
Friday: 7.5 hours

Total:

8 + 7.5 + 9 + 8 + 7.5 = 40 hours

How to Check a Timesheet Before Payroll

Before submitting a timesheet, review each entry.

Check the Start and End Times

Make sure the clock-in and clock-out times are correct.

Check Breaks

Confirm that applicable unpaid breaks have been handled correctly.

Check Each Daily Total

Calculate each shift independently before adding the week.

Check the Weekly Total

Add all daily hours and compare the result with the timesheet total.

Check Decimal Conversions

Make sure minutes have been converted using 60 minutes per hour.

Check Overtime

If your hours exceed an applicable overtime threshold, verify that the appropriate rules have been applied.

Use a Work Hours Calculator for Timesheets

For regular timesheet calculations, a Work Hours Calculator can calculate daily and weekly work hours from start time, end time, breaks, and working days.

For example, you can enter:

• Start time: 9:00 AM

• End time: 5:00 PM

• Break: 30 minutes

• Workdays: 5

The calculation gives:

7.5 hours per day

and:

37.5 hours per week

This can make it easier to check your manually recorded timesheet hours.

Common Timesheet Mistakes

1. Treating Minutes as Decimal Digits

30 minutes is not 0.30 hours.

Correct:

30 ÷ 60 = 0.50

2. Forgetting Unpaid Breaks

If an applicable unpaid break should not count as working time, remember to deduct it.

3. Counting the Time Between Split Shifts

If you work 8 AM–12 PM and 4 PM–8 PM, the four-hour gap is not automatically work time.

4. Calculating Overnight Shifts Incorrectly

An overnight shift crosses midnight, so divide it into two periods when necessary.

5. Rounding Too Early

Keep the original hours and minutes during calculations and convert to decimals when appropriate.

6. Adding Clock Times Instead of Durations

Times such as 9:00 AM and 5:00 PM are clock times. First calculate the duration between them before adding daily work hours.

7. Assuming the Timesheet Total Is Always Correct

A recorded timesheet can contain an entry error. Reviewing the individual shifts can help identify mistakes before payroll is processed.

Timesheet Hours Example: Full Workweek

Consider this weekly schedule:

Add the daily hours:

8 + 8 + 7.5 + 7.5 + 8 = 39 hours

The weekly timesheet total is:

39 hours

If the employee earns $22 per hour, the basic gross-pay calculation would be:

39 × $22 = $858

This is a basic gross estimate before applicable payroll deductions, taxes, benefits, or other adjustments.

Frequently Asked Questions

What are timesheet hours?

Timesheet hours are the working hours recorded for an employee during individual shifts and workweeks.

How do I calculate hours from clock-in and clock-out?

Subtract the start time from the end time, then subtract applicable unpaid breaks.

Hours Worked = End Time − Start Time − Applicable Unpaid Breaks

How do I calculate 8 hours with a 30-minute break?

If the total time between clock-in and clock-out is 8 hours:

8 − 0.5 = 7.5 hours

So the working time is 7 hours 30 minutes.

How do I convert 30 minutes to timesheet hours?

Divide 30 by 60:

30 ÷ 60 = 0.50

Therefore, 30 minutes equals 0.50 decimal hours.

How do I calculate weekly timesheet hours?

Add the working hours for each day.

If the daily schedule is identical, you can also use:

Weekly Hours = Daily Hours × Workdays

How do I calculate overnight hours?

Separate the shift at midnight. Calculate the hours before midnight and after midnight, then add them together.

How are timesheet hours used for payroll?

Recorded working hours can be combined with an employee's applicable pay rate and payroll rules to calculate gross wages and other payroll amounts.

Can I calculate timesheet hours manually?

Yes. Simple shifts can be calculated manually by subtracting start time from end time and accounting for applicable breaks. A calculator is useful when schedules become more complicated.

What is the difference between timesheet hours and payroll hours?

Timesheet hours are recorded working-time entries. Payroll uses those records, along with pay rates, overtime rules, deductions, and other applicable information, to calculate wages.

Conclusion

Understanding timesheet hours makes it easier to track work, review schedules, and check payroll calculations.

The basic process is:

Clock In → Clock Out → Subtract Applicable Breaks → Calculate Daily Hours → Add Weekly Hours → Review for Payroll

Remember that 30 minutes equals 0.50 decimal hours, not 0.30. For split or overnight shifts, calculate each working period separately. And when overtime or payroll rules are involved, use the rules that apply to the specific employee and location.

For simple schedules, manual calculations may be enough. For recurring timesheets with breaks, weekly totals, or different schedules, a work-hours calculator can make the process faster and easier.