Back to Tools
Timesheet with Lunch Break
Clock-out minus clock-in still includes lunch. This calculator removes the unpaid break so the timesheet shows time actually worked.
Part of the Timesheet Calculator.
Day 1
Enter values and calculate.
Formula
worked = (clock-out − clock-in) − unpaid lunch
How to use the Timesheet with Lunch Break
- Enter clock-in, clock-out, and the unpaid lunch in minutes.
- Click Calculate for worked hours and the decimal.
- Set lunch to 0 when the break is paid.
- For the rest of this set, open the Timesheet Calculator.
Formula
worked = (clock-out − clock-in) − unpaid lunch
Worked example
09:00–17:30 minus 30m lunch = 8.0h worked.
Practical tips
- 09:00 to 17:30 with a 30-minute lunch is 8.0 hours.
- A 60-minute unpaid lunch on a 09:00–17:00 day leaves 7.0 hours.
- Related: Timesheet Calculator.
- Also useful: Weekly Timesheet Calculator.
FAQ
Should I subtract a paid break?
No. Only enter breaks that are unpaid. Paid breaks stay inside worked time.
What if lunch is 45 minutes?
Enter 45. That is 0.75 hours removed from the clock span.
Can I do a whole week with lunch?
Yes. The weekly timesheet calculator has a lunch field on every day.