About HourHatch

What is HourHatch for?

HourHatch helps you check a time card, estimate when a shift ends, or keep a record in Excel.

The time card calculator totals entered shifts for one or two workweeks. The clock-out calculator finds an end time from a start time, work duration and unpaid breaks. The Excel workbook provides weekly and biweekly sheets with formulas you can edit.

These tools are free to use, have no ads and require no account. HourHatch is the name used for this project and its guides. Site maintenance and calculation questions can be sent to [email protected].

How do the calculations work?

The time card calculator calculates in minutes, subtracts unpaid break minutes once, and converts the final total to decimal hours.

1. Time between punches. An end time earlier than its start time is treated as the next day. Split shifts contribute only the intervals you enter.
2. Unpaid breaks. Break minutes are deducted from that day's shift time. A gap already excluded by split shifts is not deducted again.
3. Overtime. The default is weekly overtime after 40 hours at a 1.5 multiplier. You can change those settings. In biweekly mode, the two workweeks are calculated separately.
4. Daily settings. If daily overtime is enabled, time above that threshold is counted as overtime before the weekly threshold is applied to remaining regular hours.
5. Display. Decimal hours are displayed to two places. The underlying minute totals are added before conversion.

Rounding is off by default. If enabled, each punch is rounded to the chosen interval before unpaid minutes are subtracted.

The clock-out calculator adds required work time and unpaid breaks to the start time. It uses exact minutes and identifies next-day results. The Excel workbook uses one shift per day, exact-minute totals and optional weekly overtime; it does not reproduce every browser-calculator feature.

What are the limits?

HourHatch provides work-hours calculations and a basic gross-pay estimate for a single hourly rate.

It does not calculate taxes, deductions, multiple pay rates, tiered double time, seventh-day premiums or every state-specific requirement. A custom daily threshold is a calculation setting, not a complete state-law preset.

Times are wall-clock entries. Reconcile actual elapsed time across daylight-saving changes. Workweeks start at midnight on the selected date. Overnight shifts stay on their start date, so split shifts that cross that boundary at midnight to allocate their time to the correct workweeks. A workweek beginning at another time needs manual allocation.

The Excel workbook has one start/end pair per day. Check adjacent overnight shifts for overlaps manually. Use the browser calculator for split shifts and its additional overlap checks.

How can I report a mistake?

Send the example and expected result to [email protected].

Include sample times, unpaid minutes, the selected settings and the result you expected. The correction checklist makes it easier to reproduce an issue. The calculation method and worked examples are the starting points for checking a report.