How to Calculate Work Hours from a Timesheet (Step by Step)

Whether you are a salaried employee tracking attendance, a factory worker checking overtime, or a freelancer billing a client by the hour, calculating work hours accurately from a timesheet matters for getting paid correctly. Small errors in adding up minutes across a week can add up to real money over a month. In India, the calculation also connects directly to labour law, because hours beyond the legal limit must be paid at a higher overtime rate.

This step-by-step guide shows you exactly how to calculate work hours from any timesheet, including breaks, overtime and night shifts, with Indian examples. You can also use our free timesheet calculator to add up your hours automatically and avoid manual mistakes.

Key takeaway: Always convert your times to the 24-hour clock before subtracting — most timesheet errors come from mixing up AM and PM or mishandling a shift that runs past midnight.

What a Timesheet Records

A timesheet is simply a record of when you started work, when you finished, and how long your breaks lasted, usually for each day of the week. It is the basis for calculating your paid hours, your overtime, and ultimately your wages. In Indian workplaces it may be a paper register, a punch-in system, or a digital app, but the underlying maths is always the same. Understanding how to read and total a timesheet lets you verify that your salary or invoice is correct.

Step 1: Convert to 24-Hour Format

The single most important step is to convert every time to the 24-hour clock, because mixing AM and PM is the most common source of error. So 9:30 AM becomes 09:30 and 6:00 PM becomes 18:00. This makes subtraction straightforward and removes any ambiguity, especially for shifts that span the afternoon and evening. Once every entry is in 24-hour form, the rest of the calculation is simple arithmetic.

Step 2: Subtract Start From End

Next, subtract the start time from the end time to get the gross duration. For 09:30 to 18:00, subtract 09:30 from 18:00 to get 8 hours 30 minutes. If the minutes make subtraction awkward, convert everything to minutes first: 18:00 is 1080 minutes and 09:30 is 570 minutes, so the difference is 510 minutes, which is 8.5 hours. Working in minutes avoids mistakes when the end minutes are smaller than the start minutes.

Step 3: Subtract Unpaid Breaks

Most Indian workplaces provide a lunch or tea break that is not paid, so you must subtract it from the gross duration. If the 8.5-hour span above includes a 30-minute unpaid lunch, your actual worked time is 8 hours. Be careful to subtract only unpaid breaks; short paid tea breaks usually remain part of your working hours. Getting this right is essential because it directly affects your paid total.

Step 4: Handle Night Shifts Across Midnight

Night shifts common in Indian BPOs, factories and hospitals often cross midnight, which trips up manual calculations. If you start at 22:00 and finish at 06:00, you cannot simply subtract, because the end time is smaller. Instead, add 24 hours to the end time: 06:00 becomes 30:00, and 30:00 minus 22:00 gives 8 hours. Treating the next day correctly ensures night-shift workers are paid for their full shift.

Step 5: Separate Regular and Overtime Hours

Once you have the daily total, split it into regular and overtime hours according to Indian law. Under the Factories Act, 1948, the daily limit is 9 hours and the weekly limit is 48 hours, and anything beyond is overtime payable at twice the ordinary rate of wages. So if a worker clocks 10 hours in a day, the first 9 are regular and 1 hour is overtime at double pay. Tracking this split protects your right to correct overtime wages.

Timesheet Calculation Reference

Worked Example 1: A Standard Office Day

Suppose Ravi works from 09:30 to 18:30 with a 45-minute unpaid lunch. The gross span is 9 hours, and after subtracting 45 minutes his worked time is 8 hours 15 minutes. This is within the 9-hour daily limit, so there is no overtime. Over a five-day week this totals roughly 41.25 hours, comfortably under the 48-hour weekly cap.

Worked Example 2: Overtime in a Factory

Consider Sunita, a factory worker who works 08:00 to 19:00 with a 1-hour unpaid break. Her worked time is 10 hours, which exceeds the 9-hour limit by 1 hour. That extra hour qualifies as overtime, payable at twice her ordinary hourly wage under the Factories Act. If her ordinary rate is ₹80 an hour, that overtime hour earns her ₹160.

Worked Example 3: A Freelancer Billing Hours

Now take Arjun, a freelance designer who logs 3 hours 20 minutes in the morning and 4 hours 10 minutes in the afternoon for a client. Converting to minutes gives 200 + 250 = 450 minutes, which is 7.5 hours. At a billing rate of ₹600 an hour, his day is worth ₹4,500. Accurate timesheet totals ensure freelancers invoice clients correctly and get paid for every minute worked.

Benefits of Calculating Work Hours Correctly

Accurate calculation ensures you are paid for every hour you actually work, including any overtime you are legally owed. It helps employees verify payslips and freelancers raise correct invoices, avoiding disputes. For employers, it supports fair, compliant payroll under Indian labour law. And for anyone, a clear picture of hours worked helps with planning workloads and maintaining a healthy work-life balance.

Challenges and Limitations

Manual calculation becomes error-prone across a full week, especially with varied shifts, breaks and night duties. Rounding conventions differ between employers, and small rounding of minutes can accumulate over a month. Legal limits and overtime rules can also vary between the Factories Act and state Shops and Establishments Acts, so the correct threshold depends on your type of workplace. For these reasons, a calculator plus awareness of your applicable law gives the most reliable result.

Common Mistakes to Avoid

• Mixing AM and PM. Always convert to 24-hour format before subtracting to avoid large errors.
• Forgetting to subtract unpaid breaks. Counting lunch as worked time overstates your hours.
• Mishandling midnight. For night shifts, add 24 hours to the end time before subtracting.
• Ignoring the overtime split. Hours beyond the legal limit must be counted separately at double pay.
• Rounding too early. Total the exact minutes first, then round only the final figure.
• Applying the wrong legal limit. Factory and shop establishments may follow different acts.

Best Practices and Expert Recommendations

• Work in minutes. Converting hours and minutes to total minutes prevents subtraction errors.
• Log times immediately. Record start, end and break times as they happen for accuracy.
• Know your legal limits. Understand whether the Factories Act or a state Shops Act applies to you.
• Track overtime separately. Keep a running note of hours beyond the daily and weekly caps.
• Use a calculator. Verify weekly totals with our time tools to catch any slips.
• Keep your own records. Retain a personal timesheet so you can cross-check your payslip.

Frequently Asked Questions

How do I calculate total hours from a timesheet?
Convert start and end times to 24-hour format, subtract the start from the end, then subtract any unpaid break. Working in minutes and dividing by 60 avoids errors.

What are the legal working hours in India?
Under the Factories Act, 1948, the limit is 9 hours a day and 48 hours a week. State Shops and Establishments Acts set similar limits for shops and offices, so check which applies to you.

How is overtime calculated in India?
Hours worked beyond the daily or weekly limit are overtime, payable at twice the ordinary rate of wages under the Factories Act. So one overtime hour earns double your normal hourly pay.

How do I handle a night shift that crosses midnight?
Add 24 hours to the end time before subtracting. For a 22:00 to 06:00 shift, treat 06:00 as 30:00, giving 8 hours of work.

Should I subtract lunch breaks?
Yes, if the break is unpaid. Subtract unpaid breaks such as lunch from your gross hours, but keep any short paid tea breaks as working time.