How to Total a Timesheet with Breaks and Overnight Shifts (and Convert 7:45 to 7.75 Hours)

You worked 7 hours and 45 minutes on Tuesday, so you type 7.45 into the payroll sheet. That sheet now thinks you worked 7 hours and 27 minutes. Clock time and decimal hours are different number systems, and mixing them up quietly costs you 18 minutes of pay on every 7:45 day. The other two classic timesheet mistakes are shifts that cross midnight (which naive subtraction turns negative) and overtime counted the wrong way for your state.

Below: the minute-to-decimal table, a full worked week with an overnight shift, and the same week under the federal 40-hour rule and a California-style daily rule. Every total was run through the same code as our time card calculator.

Minutes to decimal hours

Divide the minutes by 60 and add them to the whole hours:

decimal hours = hours + minutes ÷ 60
7:45  →  7 + 45 ÷ 60  =  7.75
8:20  →  8 + 20 ÷ 60  =  8.333…  →  8.33

Clock time	Decimal hours
0:15	0.25
0:20	0.33
0:30	0.50
0:40	0.67
0:45	0.75
0:50	0.83
7:20	7.33
7:45	7.75
8:20	8.33

Going back the other way, multiply the decimal part by 60. 0.6 hours is 36 minutes, and 0.1 hours is 6 minutes. That’s why some time clocks round to the nearest 6 minutes: each step is exactly one tenth of an hour.

The values ending in 3 and 7 are rounded. If you add up a week of rounded decimals you can drift a cent or two from the true total. It’s safer to add the minutes first and convert once at the end, which is what the calculator does.

One day, step by step

For each day:

Take clock-out minus clock-in.
If the result is negative, the shift crossed midnight. Add 24 hours.
Subtract the unpaid break.

22:00 → 06:30 with a 30-minute unpaid break

06:30 − 22:00   = −15:30
−15:30 + 24:00  =   8:30
8:30 − 0:30     =   8:00   →  8.00 hours

Spreadsheets do the same trick with MOD(out − in, 1) when times are stored as fractions of a day. Our calculator reads any clock-out earlier than the clock-in as the next morning and credits the hours to the day the shift started. If the in and out times are identical, it counts 0 hours, not 24, because that’s much more likely a typo.

Only subtract unpaid breaks. Under federal rules, rest breaks of about 5 to 20 minutes must be counted as hours worked, while a bona fide meal period (ordinarily 30 minutes or more, with the employee fully relieved of duty) is not. That’s from 29 CFR 785.18 and 785.19. If you clock out for lunch and back in, skip the break field and enter two in/out pairs instead. The calculator has a Split shifts toggle for exactly that.

A worked week

Here’s a Monday-to-Saturday week. The 30-minute lunch is unpaid every day except Saturday.

Day	In	Out	Break	Hours	Decimal
Mon	09:00	17:30	30	8:00	8.00
Tue	09:00	17:45	30	8:15	8.25
Wed	09:00	18:15	30	8:45	8.75
Thu	22:00	06:30	30	8:00	8.00
Fri	07:00	20:30	30	13:00	13.00
Sat	08:00	12:20	0	4:20	4.33
Total				50:20	50.33

Thursday is the overnight shift from above. Now for the part that depends on where you work.

Overtime under the federal 40-hour rule

The Fair Labor Standards Act requires overtime for covered, non-exempt employees “for hours worked over 40 in a workweek” at “not less than time and one-half their regular rates of pay,” per the Department of Labor’s overtime page. There’s no federal daily limit. A 13-hour Friday is not overtime on its own. Weekends and holidays don’t trigger overtime either. The workweek is a fixed, recurring 168-hour period that can start on any day, and the DOL says hours can’t be averaged across two or more weeks.

The calculator’s Weekly mode fills regular time in day order and splits the day that crosses 40:

Mon–Thu      = 33:00 regular
Fri  13:00   =  7:00 regular + 6:00 overtime   (hits 40)
Sat   4:20   =  4:20 overtime

Regular  40:00  (40.00 h)
Overtime 10:20  (10.33 h)

At $20 an hour, that’s 40 × $20 = $800, plus 10.333 × $30 = $310, for $1,110.00 gross.

On a two-week pay period, each week is worked out on its own. 50 hours one week and 30 the next is 10 hours of overtime, not zero.

Overtime under a California-style daily rule

California adds daily triggers. The DLSE overtime FAQ sets time and a half for hours over 8 up to and including 12 in a workday, for hours over 40 in a workweek, and for the first 8 hours on the seventh consecutive day of work in a workweek. Double time applies to hours over 12 in a workday and hours over 8 on that seventh day.

Hours aren’t counted twice. A 2000 DLSE opinion letter says daily overtime hours “would not be counted for the purpose of any other overtime payment, such as weekly overtime hours.” So the weekly 40 is checked against regular hours only.

Same week, using the calculator’s Daily 8 + double time after 12 mode with Also apply a weekly threshold ticked:

Day	Hours	Regular	1.5x	2x
Mon	8:00	8:00
Tue	8:15	8:00	0:15
Wed	8:45	8:00	0:45
Thu	8:00	8:00
Fri	13:00	8:00	4:00	1:00
Sat	4:20		4:20 (weekly)
Total	50:20	40:00	9:20	1:00

By Friday you already have 40 regular hours, so all of Saturday is weekly overtime. Pay at $20 is $800 + 9.333 × $30 ($280) + 1 × $40 ($40) = $1,120.00. That’s $10 more than the federal version, all from the 13th hour on Friday.

Leave the weekly box unticked and Saturday becomes regular time. The result drops to 44:20 regular, 5:00 overtime and 1:00 double time, or $1,076.67. That’s wrong for California, so tick the box if your rule has both triggers.

The seventh-day rule is not automatic. Our calculator has no seventh-consecutive-day setting. If someone works all seven days of a California workweek, the first 8 hours of day 7 are owed at 1.5x and anything past 8 at 2x, and you’d have to account for that by hand. The calculator also treats each overnight shift as belonging to the day it started on. Your employer’s workday definition may split those hours differently.

Rounding punches and the 7-minute rule

Many time clocks round each punch. Federal rules accept “the nearest 5 minutes, or to the nearest one-tenth or quarter of an hour” as long as, over time, it doesn’t fail to pay employees for all the time they actually worked. That’s 29 CFR 785.48(b). For quarter-hour rounding, DOL Fact Sheet #53 spells out the familiar “7-minute rule”: 1 to 7 minutes may be rounded down, but 8 to 14 minutes must be rounded up to a full quarter hour. An employer that always rounds down can violate the FLSA.

The calculator’s Round punches setting offers nearest 5, 6 or 15 minutes. It rounds each clock-in and clock-out before measuring the shift, and exact halves round up. Breaks are not rounded. With 15-minute rounding:

08:53 → 09:00     (8 past 08:45, rounds up)
09:07 → 09:00     (7 past, rounds down)
09:08 → 09:15     (8 past, rounds up)

Pick a step only if your employer actually rounds. Otherwise leave it at No rounding.

What the calculator does (and doesn’t)

The time card calculator handles one or two weeks, any week start day, a break field per day, and an optional second in/out pair per day. Overtime modes are none, weekly, daily, or daily plus double time. The thresholds and the 1.5x/2x multipliers are editable. Add an hourly rate and you get gross pay split into regular, overtime and double time. Every day and total shows as both h:mm and decimal hours. You can print the card, download a CSV, or copy a text summary. Entries are saved in your browser’s local storage so you can fill it in across the week. Nothing is uploaded.

It is not payroll software. There’s no tax, no deductions, and no state rules beyond the generic daily and weekly settings you pick. It also doesn’t know which overtime law covers you, so check with your state or your employer if you’re unsure.

If you bill clients by the hour, total the week in the calculator and carry the decimal hours into the invoice generator as the quantity. For a one-off gap between two dates and times, such as a shift that runs longer than a day, the duration calculator gives the exact span. For a regular week of punches, start with the time card calculator and type 7:45, not 7.45.