Skip to main content

Limited time: save up to 25% on spreadsheet models and templates.Explore templates

10XSheets

Free calculator

Work time calculator

Enter clock in, clock out, and unpaid break minutes for one workday or shift. We show net time in hours:minutes and decimal hours (common for payroll-style exports). Optionally multiply by an hourly rate for a gross illustration only. For a full week grid, use the time card calculator; for date-to-date duration without a single break field, use the time calculator—both are linked below.

Educational illustration only. This is not payroll software, not legal or labor-law advice, and not your employer’s rounding or overtime rules. Breaks, overtime, and pay vary by contract, employer, and jurisdiction—verify with HR and official records.

When to use this calculator

Fast one-day checks before you paste the same idea into Sheets or Excel—transparent math, not a timeclock product.

  • See net hours after an unpaid lunch or other break on a single shift.
  • Read the same total in h:mm and decimal hours for forms that want decimals.
  • Ballpark gross pay for the day from decimal hours × rate—then hand the result to payroll with your real rules.
  • Switch to the time card calculator when you need a Monday–Sunday table, or the time calculator for elapsed time between instants without this break model.
How is net work time calculated?

We take end − start on the same calendar day in minutes, subtract unpaid break minutes (capped at the gross span), and show the result as h:mm and decimal hours.

Same-day clock span

End must be later than start on the same day. If either field is blank, we treat the day as 0 worked minutes.

Unpaid break

Break minutes reduce gross minutes. If break exceeds the span, we cap it so net does not go negative.

Decimal hours

Decimal hours are worked minutes ÷ 60 rounded to 2 decimal places for display—common for exports, though your employer may use different rounding.

We do not model overnight shifts that cross midnight, multiple in/out segments in one day, or statutory break auto-rules.

For elapsed time between two date-times or H:MM duration math without this break field, use the time calculator.

For a Monday–Sunday time card with per-day rows, use the time card calculator.

Google Sheets & Excel

Store start and end as time-of-day values (not plain text) so subtraction is a duration. Subtract break as minutes divided by 60 when you work in decimal hours, or TIME(0, breakMin, 0) when you stay in time fractions of a day.

Net decimal hours for one day
=(end-start)*24-(breakMin/60)

With start/end as times on the same date, end−start is a fraction of a day; multiply by 24 for hours. Subtract breakMin/60 when break is in minutes.

Frequently asked questions

How is this different from the time card calculator?

This page is one shift: in, out, break, then totals. The time card calculator adds a full week grid with Monday–Sunday rows. Use the week tool when you need several days at once.

How is this different from the time calculator?

The time calculator covers duration between two date-times, shifting a date-time, and adding or subtracting H:MM blocks. This page answers “how long did I work after an unpaid break between clock in and clock out on one day.”

How do you get decimal hours from clock times?

Convert worked minutes to hours as minutes ÷ 60. Example: 7 h 30 m450 minutes → 7.50 decimal hours. This page rounds the decimal display to 2 places.

How much is 15 minutes in decimal hours?

15 minutes is 0.25 hours (15 ÷ 60 = 0.25). 30 minutes is 0.50; 45 is 0.75.

Does break time reduce my total?

Yes—unpaid break minutes you enter are subtracted from end − start, up to the gross span. Paid breaks are not modeled separately.

What if my shift crosses midnight?

This v1 tool expects end after start on the same calendar day. For overnight work, split the hours across days in your own policy or use a spreadsheet model—midnight crossing is not built in here.

Can I submit this to payroll?

Treat this as a check and a teaching aid. Payroll systems have their own rounding, overtime, and compliance rules. Always follow your employer’s official process and records.

How do I match this day in Google Sheets or Excel?

Store start and end as time values. Net decimal hours can follow =(end-start)*24-(breakMin/60) when breakMin is whole minutes—see the copy card on this page.

Why might decimals differ from my employer’s portal?

Employers often round punches to the nearest minute, 5, 6, or 15 minutes. We use a simple 2-decimal display from exact minute math here—expect differences until rules match.

Is this labor-law or compliance advice?

No. It is a free math helper. Break laws and overtime depend on your jurisdiction and contract—ask qualified professionals or HR.