Free weekly timesheet tool

Timesheet Calculator

Fill a seven-day timesheet with start, end and break times. The calculator separates regular hours from overtime using a daily threshold (default 9 hours) and a weekly threshold (default 48 hours), then estimates gross pay from your hourly rate and overtime multiplier.

Weekly timesheet
Enter start, end and unpaid break for each day worked.
DayStartEndBreak (min)RegularOT
Mon9.000.00
Tue8.500.00
Wed9.001.50
Thu8.000.00
Fri8.000.00
Sat5.500.00
SunOff
hours

Hours above this on any day are overtime (9 under the Factories Act).

hours

Regular hours above this in the week become overtime (48 by law).

₹

Monthly wage ÷ 26 ÷ 8 for daily-rated staff.

×

2× is the statutory minimum for factory and scheduled-employment workers.

Estimated gross pay for the week
₹5,100.00
49h 30m worked in total
Hours split
Regular hours48.00
Overtime from long days1.50
Overtime above 48-hour week0.00
Total overtime hours1.50
Pay
Regular pay (48.00 h × ₹100)₹4,800.00
Overtime pay (1.50 h × ₹200)₹300.00
Gross for the week₹5,100.00

Daily overtime is removed before the weekly test so no hour is counted twice. Overtime normally requires prior approval and, under the Labour Codes, the worker's consent.

How regular and overtime hours are split

Two thresholds decide what counts as overtime. The daily threshold catches long days: anything above 9 hours on a single day is overtime even if the week is short. The weekly threshold catches long weeks: once the regular hours in the week pass 48, the rest is overtime even if no single day was long. The calculator applies the daily rule first, then the weekly rule to the remaining regular hours, so no hour is counted twice.

Both thresholds are editable because Shops and Establishments Acts differ by state and some establishments run 8-hour standard days. Set them to match your registered working hours, not to what the roster happens to say.

  • Daily threshold: hours above it on any day are overtime
  • Weekly threshold: regular hours above it across the week become overtime
  • Overtime multiplier defaults to 2.0, the statutory minimum for factory and scheduled-employment workers
  • Hourly rate can be derived from monthly wage ÷ 26 ÷ 8 if you pay monthly

Timesheets versus attendance

An attendance record proves presence and gives in and out times. A timesheet allocates those hours to work, which is what services firms, staffing agencies and security companies bill clients for. This tool works from the attendance side of that relationship: it converts punches into paid and billable hours. When the same person works on two client sites in one week, keep one timesheet per site so the overtime lands on the right invoice.

Frequently asked questions

Should the overtime threshold be 8 or 9 hours in India?
The Factories Act sets 9 hours a day and 48 a week, and many state Shops and Establishments Acts use the same numbers, although some registered establishments work an 8-hour standard day and pay overtime beyond it by policy. Use the daily hours written in your establishment registration or standing orders.
Does a weekly threshold matter if I already apply a daily one?
Yes. Six days of 8.5 hours produce no daily overtime but total 51 hours, which is 3 hours above the weekly limit. Applying both rules, without double counting, is the only way to match what the law expects and what a labour inspector will check.
How do I get an hourly rate from a monthly salary?
Common Indian practice for wage earners is monthly wage ÷ 26 paid days ÷ 8 hours. A ₹20,800 monthly wage gives ₹800 per day and ₹100 per hour, so an overtime hour at 2× is ₹200. Monthly-rated office staff are sometimes calculated on 30 days; use whichever your policy states.
Can I use this as a security guard billing timesheet?
You can total duty hours per guard per site with it, but client billing usually needs per-post man-days, reliever duties and statutory recovery lines as well. The security guard billing calculator on this site is built for that invoice structure.

More free calculators

Built for Indian attendance, payroll and compliance rules.

All calculators
From calculator to payroll

Stop re-typing hours and deductions every month

Attend Mitra derives payable days, overtime, LOP, PF and ESI from verified attendance and publishes payslips to the employee app. Try it free for 14 days.

See payroll features