Timesheet Questions: Hours, Breaks, Overtime & Fixes
This article answers the most common timesheet questions: how to calculate hours worked, how to handle breaks, how overtime is computed, and how to correct errors on submitted timesheets. You’ll get clear rules, examples, and practical steps for both employees and managers.
How to Calculate Hours Worked
To calculate hours worked, subtract the start time from the end time, then subtract any unpaid break time. For example, if an employee clocks in at 8:45 AM and out at 5:15 PM with an unpaid 30-minute lunch, the total is 8.0 hours (8:45 to 5:15 is 8.5 hours, minus 0.5 = 8.0).
Use the 24-hour (military) clock to avoid AM/PM confusion: 8:45 AM is 08:45, 5:15 PM is 17:15. The difference is 8 hours 30 minutes, or 8.5 hours. Convert minutes to decimal hours by dividing by 60 (30 minutes = 0.5 hours). Most payroll systems use decimal hours, so 8 hours 30 minutes becomes 8.50.
If you have a time card with punch in/out times, list each day separately and sum the daily totals. For example:
- Monday: 8.5 hours
- Tuesday: 8.25 hours
- Wednesday: 8.0 hours
- Thursday: 8.5 hours
- Friday: 8.0 hours
- Total: 41.25 hours
If the total exceeds the standard workweek (often 40 hours), the excess may be overtime, depending on your company policy and local laws.
How Breaks Affect Timesheets
Breaks fall into two categories: paid and unpaid. Paid breaks (typically 15 minutes or less) are counted as work time and should not be deducted from total hours. Unpaid breaks (usually meal breaks of 30 minutes or more) must be subtracted from total hours.
For example, an employee works from 9:00 AM to 6:00 PM with an unpaid 1-hour lunch. The gross time is 9 hours, minus 1 hour = 8 hours paid. If the lunch was only 20 minutes, it’s typically paid and the total remains 9 hours.
Many companies require employees to clock out for lunch if the break is unpaid. If your timesheet has a “lunch deduction� field, enter the actual break duration. If you forgot to clock out for lunch, you must report the break time to payroll so they can correct the deduction.
State laws vary on whether breaks are required and how long they must be. Federal law (FLSA) does not require meal breaks, but if an employer offers a break of 20 minutes or less, it must be paid. Always follow your employer’s policy and local regulations.
Understanding Overtime Rules
Overtime is typically any hours worked beyond 40 in a single workweek, paid at 1.5 times the regular rate. Some states require overtime for daily hours over 8, and some have double-time rules for very long shifts. The Fair Labor Standards Act (FLSA) is the federal baseline, but state laws can be more generous.
Example: An employee earns $20/hour and works 45 hours in a week. Regular pay = 40 × $20 = $800. Overtime pay = 5 × $30 = $150. Total gross pay = $950.
When filling a timesheet, separate regular hours from overtime hours. Many systems have a column for “OT hours� or automatically calculate OT after 40. If you work a holiday, some companies pay holiday premium (e.g., 1.5x) in addition to regular pay, but that’s not required by federal law.
Common mistake: forgetting to include overtime on a timesheet that has a separate field. If you worked 45 hours and only report 40, you will not be paid for the extra 5. Always double-check your total hours against your own records.
How to Correct Timesheet Errors
If you discover an error on a submitted timesheet, notify your manager or payroll department immediately. Most companies have a correction form or allow you to edit the timesheet within a certain window (often before payroll is processed).
Steps to correct a timesheet:
- Review your timesheet for missing punches, incorrect hours, or wrong overtime.
- Contact your supervisor or payroll with the correct information and any supporting evidence (e.g., emails, calendar invites, security badge logs).
- If your system has a “correction� or “edit� button, use it. Otherwise, submit a written request.
- Keep a copy of the corrected timesheet for your records.
If the error is discovered after payroll is processed, you may need to wait until the next pay period for an adjustment. Some companies issue a separate check for corrections. Always act quickly to avoid delayed pay.
Common Timesheet Mistakes and How to Avoid Them
Timesheet errors are common and can be costly. Here are frequent pitfalls:
- Mixing up AM/PM – use 24-hour format or write “AM�/“PM� clearly.
- Forgetting to subtract lunch breaks – always deduct unpaid meal periods.
- Rounding incorrectly – use decimal hours (30 min = 0.5) not “.3� or “.5� incorrectly.
- Not including overtime – track hours over 40 separately.
- Entering dates in the wrong format – use YYYY-MM-DD or the format your system requires.
- Copying last week’s timesheet – always verify each day’s hours.
To avoid these, keep a personal log of your hours (e.g., a spreadsheet or app) and compare it to your timesheet before submitting. Set a reminder to submit on time, and double-check your math.
Timesheet Software vs. Paper Timesheets
Paper timesheets are simple but prone to errors and difficult to audit. Spreadsheets offer more control but require manual calculations. Dedicated timesheet software (or time tracking apps) automates calculations, tracks hours in real time, and integrates with payroll.
When choosing a method, consider:
- Number of employees – software scales better.
- Need for remote access – cloud-based apps allow mobile clock-in.
- Compliance requirements – some industries require detailed records.
- Budget – free options exist, but paid tools offer more features.
Many companies use a hybrid: employees enter time in a spreadsheet, and payroll reviews it. The key is consistency and accuracy, regardless of the tool.
Frequently Asked Questions
How do I convert minutes to decimal hours for my timesheet?
Divide the minutes by 60. For example, 45 minutes ÷ 60 = 0.75 hours. So 8 hours 45 minutes becomes 8.75. Most payroll systems use decimal hours, so always convert.
Do I get paid for breaks?
Short breaks (usually 20 minutes or less) are paid. Meal breaks (typically 30 minutes or more) are unpaid if you are fully relieved of duties. Check your employee handbook or state law.
What if I forgot to clock in or out?
Notify your supervisor immediately. You may need to fill out a missed punch form. Provide an estimate of your start/end time based on emails or other records.
How is overtime calculated if I work more than 8 hours in a day?
It depends on your state. Federal law only requires overtime after 40 hours per week. Some states (e.g., California) require overtime for daily hours over 8. Check your local labor department.
Can my employer change my timesheet without telling me?
Employers can correct timesheets, but they must inform you if changes affect your pay. Under the FLSA, employers must keep accurate records. If you disagree with a change, dispute it in writing.
What is the difference between a timesheet and a time card?
A timesheet is a record of hours worked, often filled in manually. A time card is a physical or digital record created by a time clock. Both serve the same purpose, but time cards are more automated.
Final Tips for Accurate Timesheets
Always record hours daily, not weekly. Use a consistent format, and keep personal records. If you use a calculator, double-check the math. And remember: an accurate timesheet ensures you get paid correctly and helps your employer stay compliant with labor laws.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.