Timesheet Calculator

Fill in a weekly timesheet with breaks and overnight shifts, split regular and overtime hours, work out pay and download CSV.

Runs in your browserNo sign-upWorks offline
Your result—
Formula used
Shown here after you calculate
Rounded to
2 decimal places

What the Timesheet Calculator does

The Timesheet Calculator adds up a week of shifts and works out pay. Enter the start, end and break for each day; overnight shifts are handled. Set the overtime rules, such as after 9 hours a day or 48 a week, and the overtime rate, and the tool splits regular and overtime hours, shows the pay for each and the total, and downloads the week as a CSV for payroll or invoicing.

How to use it

  1. Choose the week and fill in each day’s start, end and break.
  2. Use Copy Monday to Tuesday–Friday for a regular pattern.
  3. Set the hourly rate and overtime rules.
  4. Read the pay and download the CSV.

Example

Monday to Friday from 9:30 to 18:30, with Thursday until 19:30 and an hour’s break each day, comes to 41 hours. At ₹500 an hour that is ₹20,500. With overtime after 8 hours a day at twice the rate, Thursday’s extra hour is overtime, so pay becomes ₹20,000 regular plus ₹1,000 overtime: ₹21,000.

Overtime rules in India

Under the Factories Act, factory workers are paid twice the ordinary rate for work beyond 9 hours a day or 48 hours a week, which is the starting setting. Shops and offices follow their state’s Shops and Establishments Act, and contracts may set their own rules, so change the limits and rate to match yours.

Clear either limit to turn it off. The weekly limit counts regular hours only, so hours already paid as daily overtime are not counted twice.

Questions people ask

Is my data uploaded?

No. Everything is worked out in your browser, and nothing you enter is kept once you close the page.

How are night shifts counted?

A shift that ends after midnight, such as 22:00 to 06:00, counts on the day it starts.

What does the CSV contain?

Each day’s times and break, total, regular and overtime hours in decimals, and the pay for the day.

Why decimal hours?

Payroll and invoices often need hours as decimals: 8 hours 30 minutes is 8.50.

Related tools