A timesheet Excel template records the hours an employee works each day, splits regular and overtime hours, and totals them for the week. This free timesheet for Indian teams adds live SUM formulas, so daily totals and the weekly total update as you type. Use it for project billing, overtime tracking, or simple work-hour records, then automate it once you outgrow manual entry.

Free Timesheet Excel Template for Indian Teams

A timesheet Excel template records the hours an employee works each day, splits regular and overtime hours, and totals them for the week. This free timesheet for Indian teams adds live SUM formulas, so daily totals and the weekly total update as you type. Use it for project billing, overtime tracking, or simple work-hour records, then automate it once you outgrow manual entry.

What a Timesheet Excel Template must include

  • Date and day of week
  • Project or task against each entry
  • Hours worked and overtime hours, kept separate
  • A daily total that adds regular plus overtime
  • A weekly total row that sums every day
  • Employee name, manager, and week-ending date in the header

Drafting tips

  • Keep overtime in its own column. Mixing it into worked hours hides the premium you owe under the Factories Act.
  • Use one tab per week and name it by the week-ending date, so a month is four or five tabs you can total later.
  • For client billing, add a Billable column and SUMIF on it, so invoiced hours and paid hours never get confused.

Timesheet Excel Template format

WEEKLY TIMESHEET for [Employee Name] — week ending [DD MMM YYYY]
Manager: [Name]    Department: [Dept]

Log hours against each day. Keep overtime in its own column so payroll can pay it at
the right rate. The Total column and the Total row add themselves up.

KEY FORMULAS
Daily Total   = Hours Worked + Overtime           (e.g. D2 + E2)
Weekly Total  = SUM of the column                 (e.g. SUM(D2:D8))
Overtime pay  = OT Hours x (Monthly Basic / 26 / 8) x 2   (Factories Act, double rate)

FAQs

What is a timesheet template?

It is a sheet that records the hours an employee works each day against a project or task, separates overtime, and totals the week. Teams use it for payroll, overtime, and client billing.

How do I total hours in Excel?

Add the columns for each day (Hours + Overtime) and use SUM for the week, for example SUM(D2:D8). This template has both the daily Total column and the weekly Total row built in.

How is overtime calculated in India?

The Factories Act requires overtime at twice the ordinary wage rate. A common formula is OT Hours x (Monthly Basic / 26 / 8) x 2. Always keep overtime hours separate so the premium is clear.

Can I use a timesheet for project billing?

Yes. Add a project or client column and a billable flag, then SUMIF by project to get billable hours. Many small agencies bill straight off a timesheet like this.

How many hours is a standard work week in India?

Most establishments run 48 hours a week and 9 hours a day under the Factories Act and state Shops and Establishment rules, with overtime beyond that. Check your state for the exact cap.

When should I switch from Excel timesheets to software?

When you bill clients by the hour, run shifts, or need approvals and an audit trail. Indian HRM captures time against projects, routes approvals, and pushes overtime into payroll automatically.