A timesheet template in Excel that works the hours out for you: time in and time out, the break taken off, night shifts that cross midnight counted on the right day, overtime on the daily or weekly basis, and a monthly summary for payroll, with each limit flagged in words as well as in colour.
Seven sheets. Pick your rule set once, then log each day and read the month's summary.
Pick the hours rules in use from a drop-down: the OSH Code with the Central Rules, or the Maharashtra or Karnataka Shops Act. Every limit is a named input with its source, and where the Code leaves a figure to the Shops Act of your State or rules, the cell is left for you to fill. Week start and holidays go here too.
One employee, one week, ready to print: time in, time out and break for each day, with the hours, spread-over and overtime worked out, a flag in words for each limit crossed, and an employee and manager sign-off. A roster plans the week; this weekly timesheet records what was actually worked.
A daily timesheet format for a team, one row per person per day, with room for three hundred rows: a month for eleven people on a six-day week. For a bigger team, keep one copy per team of up to eleven. It finds the rest day, the holiday, the week each shift belongs to and that week's overtime, and shades a flagged row amber.
The monthly timesheet for payroll: days and hours worked, normal and overtime hours, rest-day and holiday hours, and overtime pay at twice the rate on the wages you enter, all pay less the Code's listed exclusions, ready to carry into the month's payroll register, with a quarterly overtime check and a sign-off.
A project timesheet for billable hours by client, a table of where each Form IX register field sits in the file, seven open questions the law leaves unanswered, said plainly, and thirty-seven citations.
Attendo (formerly Petpooja Payroll) takes the punches from the attendance device straight into hours, overtime and payroll.
Because they subtract time in from time out and stop there. That breaks on a night shift, leaves the lunch break inside the hours, and counts only the hours past eight in a day.
The OSH Code answers all three, for a worker in an establishment of ten or more workers. Section 25(1)(a) fixes eight hours in a day. Section 27 pays overtime at twice the rate of wages on the daily or the weekly basis, whichever is more favourable to the worker, so seven eight-hour nights are eight hours of overtime though no single night ran long. The week is the Code's own, from midnight on Saturday night (s.2(1)(zzk)), not your payroll's. Pricing those hours is the job of our overtime calculation workbook; getting them right first is this one's.
Section 28 settles the night shift: the hours after midnight are counted in the previous day, so a shift from 10 p.m. Sunday to 6.30 a.m. Monday is Sunday's, and Sunday's rest-day and holiday rules apply to all of it. It decides the weekly off too: twenty-four hours from the end of the shift, not from midnight.
What the Code does not settle is the spread-over and the rest interval. Section 25(1)(b) leaves both to the appropriate Government, and the Central Rules notify neither for an ordinary establishment. A separate notification, S.O. 2517(E) of 13-May-2026, fixes half an hour after five hours' continuous work where the Central Government is the appropriate Government, and no spread-over. Most private employers are in the State sphere, and for them both come from the State: under the Maharashtra Shops Act, for a shop or office that is not a factory, a ten and a half hour spread-over and half an hour's break after five hours; under the Karnataka Act, which no longer reaches an establishment of ten or more workers registered under the OSH Code, twelve hours and an hour. The same goes for which day is the weekly off and what it pays. The workbook carries both States and leaves the rest for you to fill.
The example month runs at a Pune press shop, a Gurugram finance team and a Bhiwandi distribution warehouse: three people, one log, one summary.
Three example employees for November 2026, each built so a different rule shows up in the employee timesheet and can be checked by hand.
| Limit | OSH Code, Central Rules | Maharashtra Shops Act | Karnataka Shops Act | Setting | Flag in words |
|---|---|---|---|---|---|
| Normal day | 8 hours | 9 hours | 9 hours | DAY_MAX | Over the daily limit |
| Week | 48 hours | 48 hours | 48 hours | WEEK_MAX | Over the weekly limit |
| Spread-over | Your State's | 10.5 hours | 12 hours | SPREAD | Spread-over too long |
| Rest interval | 30 min after 5 h | 30 min after 5 h | 60 min after 5 h | REST_MIN | No rest interval |
| Overtime a quarter | Your State's; 144 dock, mine, construction | 125 hours | 50 hours | OT_QCAP | Over the quarterly overtime cap |
In an establishment of ten or more workers. Overtime past it is paid at twice the rate, on the daily or weekly basis, whichever is more favourable.
Source: OSH Code, 2020, s.25(1)(a), with s.27; in force 21-Nov-2025, S.O. 5321(E)A proviso to rule 69(4) of the Central Rules, which deals only with dock, mine and construction work, so on our reading it caps nothing else. Its words read wider, so it stays an open question, and the file leaves the cap blank for you to fill.
Source: OSH (Central) Rules, 2026, rule 69(4), proviso, G.S.R. 345(E), 08-May-2026And more than 30 minutes counts as an hour. Under 15 the rule is silent, so the file keeps the actual minutes.
Source: OSH (Central) Rules, 2026, rule 69(2)From 10 p.m. to 6.30 a.m. that gives a negative number. Wrap it past midnight and put the shift on the day it began (s.28). A woman working before 6 a.m. or after 7 p.m. also needs her consent to night work first (s.43).
Section 27 asks for the daily or the weekly basis, whichever is more favourable. Seven nights of eight hours are eight hours of overtime on the weekly basis and none on the daily. Paying less than is due is a fine of up to ₹50,000 (s.54(1)(a), Code on Wages). Which Code reaches which employee decides the rest.
The spread-over runs from time in to time out. The hours worked are that less the break. Mixing them up overstates the day and hides a missing rest interval.
The first proviso to s.27 makes overtime subject to the worker's consent. An overtime timesheet that shows the hours and no consent shows the breach, which s.97(1) or s.94 penalises at ₹50,000 up to ₹3,00,000. So the file asks for consent on every employee.
There is no single overtime cap or spread-over for all of India. 125 hours in three months is the Maharashtra Shops Act's, 50 is Karnataka's, and 144 sits in the Central Rules for dock, mine and construction work. Use your own State's figure.
In the Central sphere the register is Form IX under rule 51, or Form XIV under rule 72 of the OSH rules, in the prescribed format. A timesheet is not the register: copy the hours into the Form IX attendance register format each month and keep both for five years. Not keeping it costs ₹50,000 to ₹1,00,000 (s.96).
Built for a day shift
Built on the OSH Code
Log each day, act on the flags at the end of each week, get the sign-off, and carry the summary into payroll.
Attendo (formerly Petpooja Payroll) is payroll and attendance software used by 40,000+ businesses across manufacturing, corporate offices, retail chains, hospitals and education. General guidance, not legal advice. This Excel timesheet is one of our free hours and payroll templates, each built from the law rather than from other templates.
Weekly and monthly timesheets, a daily log, night shifts handled, seven open questions and thirty-seven citations. Free.
