Time Clock Rounding Calculator and Chart

Worked example: one shift on three grids

Time clock rounding chart (7-minute rule)

Rounding a lunch break and a full week

Each punch is rounded on its own, and lunch punches are no different. A shift with a lunch out and lunch in has four punches, and each one moves to the grid. The break box on this page takes a fixed number of minutes instead. Use it when lunch is a set 30 or 60 minutes.

Rounding each punch and rounding the daily total can give different answers. A day of 7 hours 44 minutes rounds to 7:45 as a total. Rounding the two punches first gave 7:30 in the example above. Follow the method your employer's written policy describes.

In California, meal-period punches are a special case. The state's Supreme Court ruled in 2021 that employers may not round time punches for meal periods (Donohue v. AMN Services). Many California employers now pay to the exact minute for that reason.

Time clock rounding in Excel or Google Sheets

Put the clock-in time in B2, the clock-out time in C2 and the unpaid lunch minutes in D2. Format the rounded cells as time. TIME(0,15,0) stands for 15 minutes, so the same formulas work in both programs.

Times are stored as fractions of a day, so an exact midpoint such as 8:03 on the 6-minute grid can tip either way. Type punches to the whole minute and check those rows against the chart above.

Common mistakes

• Rounding only one way. Rounding clock-ins up and clock-outs down always favors the employer. Federal rules accept rounding only when it averages out, so employees are paid for all time really worked.
• Mixing punch rounding with total rounding. Rounding each punch and rounding the daily total can give different results. Use the method your employer's policy describes.
• Confusing 6-minute and 10-minute rounding. A tenth of an hour is 6 minutes, so 6-minute rounding gives hours like 7.7, not 7:10.
• Assuming rounding is allowed everywhere. A handful of states go further than federal law. In California, meal-break punches cannot be rounded at all.

Is time clock rounding legal?

Yes, under federal law, if it is neutral. 29 CFR 785.48 allows rounding to the nearest 5 minutes, 6 minutes or 15 minutes. Averaged over time, nobody may lose paid minutes. So a clock that always rounds down breaks the rule. California is stricter on meal-break punches, and the 7-minute rule guide explains more.