Timesheet and Time Bank Calculator

Loading the timesheet...

Continue in the tool

More pages for this tool

how to calculate hours worked with a lunch break

How to calculate hours worked with a lunch break

The lunch break is not working time: hours worked are the sum of the periods between clock in and clock out, without the idle time. Type the times in the sheet, even as 0800, and see the day total.

How the math works

With four punches, the total is (lunch out minus clock in) plus (final clock out minus lunch back). From 08:00 to 12:00 and from 13:00 to 17:00 that is 4:00 plus 4:00, or 8:00 worked, even though there are 9 hours between the first in and the last out. With odd minutes, from 08:15 to 12:10 and from 13:20 to 18:05 that is 3:55 plus 4:45, or 8:40, which is 8.67 in decimal hours. For shifts crossing midnight, a clock-out earlier than the clock-in is read as the next day: from 22:00 to 05:00 is 7:00 of clock time.
The break has rules too. On a continuous workday over 6 hours, the minimum is 1 hour and the maximum 2 hours, unless a written or collective agreement says otherwise (CLT art. 71); between 4 and 6 hours, the minimum is 15 minutes. A collective agreement may reduce the break to as little as 30 minutes on workdays over 6 hours (art. 611-A, III). If the break is not granted or only partly granted, the missing time is paid with a 50% premium (art. 71 §4). On a night shift, the reduced 52min30s hour makes the 7:00 from 22:00 to 05:00 count as 8:00 computed. The sheet warns when the break is below the minimum.

Worked examples

Standard office day

Input: 08:00-12:00 e 13:00-17:00
Expected output: 8:00

4:00 + 4:00; the lunch hour is left out.

Odd minutes

Input: 08:15-12:10 e 13:20-18:05
Expected output: 8:40 (8,67 h decimais)

3:55 + 4:45 = 8:40; 40 / 60 = 0.67 hour.

Nine hour day

Input: 07:30-12:00 e 13:00-17:30
Expected output: 9:00

4:30 + 4:30; on an 8:00 schedule that is 1:00 extra.

Shift crossing midnight

Input: 22:00-05:00
Expected output: 7:00 de relógio, 8:00 computadas

420 clock minutes x 60 / 52.5 = 480 computed minutes.

Full tool FAQ

How do I calculate the time bank?

For each day, subtract the scheduled hours from the time worked: 9h30 on an 8h schedule gives +1h30, and 7h gives -1h. The time bank is the sum of those balances plus the opening balance. Example: an opening balance of +2:00, one day of 9:30 on an 8:00 schedule (+1:30) and another of 7:15 (-0:45) give 2:00 + 1:30 - 0:45 = +2:45. The tool does this day by day and shows the running balance on each row.

What is the clock-in tolerance?

How are 50% and 100% overtime separated?

How long is the time bank valid?

How do the night premium and the reduced hour work?

What is the minimum break during the workday?

How do I log a 12x36 schedule?

Can I use it as an official time clock record?

Is my data saved? Is it safe?

How do I log a medical note, absence, vacation or bank day off?

Frequently asked questions

Does the lunch break count as working time?

As a rule, no. Rest breaks are not counted in the length of work (CLT art. 71 §2). That is why the tool adds up only the periods between clock in and out.

How do I type the times?

You can type 08:00, 0800, 800, 8 or 8h30. The field converts to HH:MM when you leave it. Impossible times, like 25:00 or 12:60, are rejected with a warning.

Can I log more than one break in a day?

Yes. Turn on Show 2nd break to get six punches in the day. For the minimum break, the longest idle period of the day is used.

Next steps

Continue in the tool

Open full tool

how to calculate hours worked with a lunch break

How to calculate hours worked with a lunch break

The lunch break is not working time: hours worked are the sum of the periods between clock in and clock out, without the idle time. Type the times in the sheet, even as 0800, and see the day total.

How the math works

With four punches, the total is (lunch out minus clock in) plus (final clock out minus lunch back). From 08:00 to 12:00 and from 13:00 to 17:00 that is 4:00 plus 4:00, or 8:00 worked, even though there are 9 hours between the first in and the last out. With odd minutes, from 08:15 to 12:10 and from 13:20 to 18:05 that is 3:55 plus 4:45, or 8:40, which is 8.67 in decimal hours. For shifts crossing midnight, a clock-out earlier than the clock-in is read as the next day: from 22:00 to 05:00 is 7:00 of clock time.

The break has rules too. On a continuous workday over 6 hours, the minimum is 1 hour and the maximum 2 hours, unless a written or collective agreement says otherwise (CLT art. 71); between 4 and 6 hours, the minimum is 15 minutes. A collective agreement may reduce the break to as little as 30 minutes on workdays over 6 hours (art. 611-A, III). If the break is not granted or only partly granted, the missing time is paid with a 50% premium (art. 71 §4). On a night shift, the reduced 52min30s hour makes the 7:00 from 22:00 to 05:00 count as 8:00 computed. The sheet warns when the break is below the minimum.

Worked examples

Standard office day

Input: 08:00-12:00 e 13:00-17:00
Expected output: 8:00

4:00 + 4:00; the lunch hour is left out.

Odd minutes

Input: 08:15-12:10 e 13:20-18:05
Expected output: 8:40 (8,67 h decimais)

3:55 + 4:45 = 8:40; 40 / 60 = 0.67 hour.

Nine hour day

Input: 07:30-12:00 e 13:00-17:30
Expected output: 9:00

4:30 + 4:30; on an 8:00 schedule that is 1:00 extra.

Shift crossing midnight

Input: 22:00-05:00
Expected output: 7:00 de relógio, 8:00 computadas

420 clock minutes x 60 / 52.5 = 480 computed minutes.

Full tool FAQ

How do I calculate the time bank?

What is the clock-in tolerance?

How are 50% and 100% overtime separated?

How long is the time bank valid?

How do the night premium and the reduced hour work?

What is the minimum break during the workday?

How do I log a 12x36 schedule?

Can I use it as an official time clock record?

Is my data saved? Is it safe?

How do I log a medical note, absence, vacation or bank day off?

Frequently asked questions

Does the lunch break count as working time?

As a rule, no. Rest breaks are not counted in the length of work (CLT art. 71 §2). That is why the tool adds up only the periods between clock in and out.

How do I type the times?

You can type 08:00, 0800, 800, 8 or 8h30. The field converts to HH:MM when you leave it. Impossible times, like 25:00 or 12:60, are rejected with a warning.

Can I log more than one break in a day?

Yes. Turn on Show 2nd break to get six punches in the day. For the minimum break, the longest idle period of the day is used.