About timesheet calculator
A timesheet totals the hours worked each day and across the week, including breaks and overtime.
Method
- For each day, subtract the start time from the end time and take off breaks.
- Add the daily totals to get the weekly hours.
- Hours beyond the regular limit count as overtime, which is often paid at a higher rate.
Accuracy
Record times promptly rather than from memory, and round the same way every day.
A worked example
Working Monday to Friday from 9:30 to 18:00 with a one-hour lunch is 7.5 hours a day, 37.5 hours in a week. If you also worked 2 extra hours on Friday and overtime pays 1.5 times a ₹300 hourly rate, the overtime pay is 2 × 300 × 1.5 = ₹900.
Good habits
- Record hours daily and not at the end of the week.
- Note which project each block of time belongs to.
- Keep a copy of the sheet you submit.
