How to Read a Timesheet

Q: What do the columns on a timesheet mean?

A standard timesheet row holds the date, the clock-in time, the clock-out time, any unpaid break, and the resulting hours worked. Many sheets add a decimal-hours column, an hourly rate, a pay figure, and a notes or pay-code column for holiday, sick, or overtime time.

Q: How do you calculate the hours on a timesheet row?

Subtract the clock-in time from the clock-out time to get elapsed time, then subtract the unpaid break. A shift from 08:00 to 16:30 is 8 hours 30 minutes elapsed; minus a 30-minute unpaid lunch it is 8 hours 0 minutes, or 8.00 decimal hours.

Q: Why does a timesheet show both hours and decimal hours?

H:MM matches the clock and is easy for people to check, while payroll systems multiply decimal hours by the rate. Both columns describe the same time: 39 hours 45 minutes is 39.75 decimal hours, because 45 divided by 60 is 0.75.

Q: How do you read an overnight shift on a timesheet?

When the clock-out time is earlier than the clock-in time, the shift crossed midnight. Count the time to midnight and add the time after it: 22:00 to 06:00 is 2 hours plus 6 hours, which is 8 hours elapsed. Subtracting a 30-minute unpaid break leaves 7 hours 30 minutes, or 7.50 decimal hours.

Q: What should a manager check before approving a timesheet?

Check that every worked day has both an in and an out time, that unpaid breaks are deducted, that overnight rows were not left negative or capped at 24 hours, that the daily totals add up to the weekly total, and that hours over the overtime threshold are on the overtime line rather than the regular one.

Q: Is 39:45 on a timesheet the same as 39.45 hours?

No. 39:45 means 39 hours and 45 minutes, which is 39.75 decimal hours. Reading it as 39.45 understates the week by 0.30 hours, or 18 minutes, which at a 22 dollar hourly rate is 6 dollars 60 cents of missing pay.

By Frame Sixty Labs · Last updated: August 22, 2026

Read a timesheet one row per day, left to right: clock in, clock out, unpaid break, hours worked. Out minus in, minus the break, gives that day’s total. Add the daily totals for the week, then check the decimal column — 39:45 is 39.75 hours, never 39.45.

Approving a timesheet is a two-minute job when you know which numbers to check and which ones simply restate each other. This guide walks a real week line by line: what each column holds, how to verify a single day, how the week should total, and the handful of errors that look fine at a glance and still reach payroll.

What are the columns on a timesheet?

Layouts vary, but nearly every time card is built from the same nine fields. The rest is formatting.

Column	What it holds	What to watch for
Date / Day	One row per calendar day	Missing days, or a day listed twice
In	Clock-in time	AM/PM mix-ups on 12-hour sheets
Out	Clock-out time	An out time earlier than the in time means an overnight shift
Break	Unpaid break length	Breaks recorded but never subtracted
Hours (H:MM)	Paid time for the day	Should equal out − in − break
Decimal	The same total as one number	Minutes copied after the point (8:30 written as 8.30)
Rate	Pay per hour	Second jobs or shift premiums at a different rate
Pay	Decimal hours × rate	Overtime hours paid at the plain rate
Code / Notes	Regular, OT, holiday, sick, PTO	Paid leave silently counted as worked time

Two of those columns — Hours and Decimal — carry no new information. They are the same quantity written twice, one for humans and one for the payroll system. If they disagree, one of them is wrong.

How do you read a single day’s row?

Take a row that reads Mon · In 08:00 · Out 16:30 · Break 0:30 · 8:00. Check it in three steps:

Elapsed time first. From 08:00 to 16:30 is 8 hours and 30 minutes. Count the whole hours (08:00 → 16:00 is 8) and then the leftover minutes (16:00 → 16:30 is 30).
Subtract the unpaid break. 8:30 − 0:30 = 8:00. That is paid time, and it is the number the Hours column should show.
Confirm the decimal. 8:00 is exactly 8.00. Had the row ended at 16:45, paid time would be 8:15 and the decimal 8.25, because 15 ÷ 60 = 0.25.

The break line is where most single-row errors live. An employee writes the lunch down honestly, the sheet has a Break column, and nobody subtracts it — so a 30-minute lunch across five days quietly adds 2:30 of unworked time to the week.

How do you check a weekly total?

Here is a full week for one employee at $22.00 per hour. Every row is worked out so you can follow the arithmetic rather than trust it.

Day	In	Out	Break	Hours	Decimal
Mon	08:00	16:30	0:30	8:00	8.00
Tue	08:00	17:15	0:45	8:30	8.50
Wed	09:00	15:45	0:30	6:15	6.25
Thu	07:30	16:00	0:30	8:00	8.00
Fri	08:00	18:00	1:00	9:00	9.00
Total	—	—	3:15	39:45	39.75

Checking Tuesday: 08:00 to 17:15 is 9 hours 15 minutes elapsed, and 9:15 − 0:45 = 8:30. Wednesday: 09:00 to 15:45 is 6 hours 45 minutes, and 6:45 − 0:30 = 6:15, which is 6.25 because 15 ÷ 60 = 0.25.

Now the weekly total, added in H:MM with the minutes carried at 60:

8:00 + 8:30 = 16:30
16:30 + 6:15 = 22:45
22:45 + 8:00 = 30:45
30:45 + 9:00 = 39:45

So the week is 39 hours 45 minutes, or 39 + 45 ÷ 60 = 39.75 decimal hours. Pay is 39.75 × $22.00 = $874.50.

A useful cross-check: the decimal column should sum to the same figure. 8.00 + 8.50 + 6.25 + 8.00 + 9.00 = 39.75. When the two totals disagree, a single row was converted wrong.

Why is 39:45 not 39.45?

This is the single most expensive misreading on a time card, and it never looks like an error. Minutes run to 60, not 100, so 45 minutes is 45 ÷ 60 = 0.75 of an hour — not 0.45.

Read the week above as 39.45 hours and pay comes out at 39.45 × $22.00 = $867.90 instead of $874.50. That is $6.60 short, from a 0.30-hour gap of exactly 18 minutes. Repeat it every week and it is roughly $343 a year on one employee.

Quick sanity check: on a correct timesheet, no decimal figure ever has minutes hiding after the point. If you see 8.30, 7.45, or 6.15 in a decimal column, someone typed the clock reading. The real values are 8.50, 7.75, and 6.25.

How do you read an overnight shift?

A row reading In 22:00 · Out 06:00 looks broken because the out time is smaller than the in time. It is not broken — the shift crossed midnight.

Split it at midnight and add the pieces: 22:00 to 24:00 is 2:00, and 00:00 to 06:00 is 6:00, so elapsed time is 8:00. With a 30-minute unpaid break, paid time is 7:30, or 7.50 decimal hours. The equivalent shortcut is to add 24 hours to the out time before subtracting: 30:00 − 22:00 = 8:00.

Two failure modes to look for on night-shift sheets. A row showing a negative total (−16:00) means the tool subtracted straight through without accounting for midnight. A row capped at exactly 0:00 or 24:00 means the tool refused to cross the day boundary at all. Both need recalculating, not rounding.

There is more on this in the guide to overnight and overtime hours.

How do overtime and pay codes appear?

The week above is 39:45 — under 40 — so every hour sits on the regular line. Once a week crosses the threshold, a timesheet should split the total rather than show one number.

Take a week of 44:30 at the same $22.00 rate, with a 40-hour threshold and time-and-a-half above it:

Regular: 40.00 × $22.00 = $880.00
Overtime: 4:30 is 4.50 hours, at $22.00 × 1.5 = $33.00, so 4.50 × $33.00 = $148.50
Total: $880.00 + $148.50 = $1,028.50

Paid-but-not-worked time is the other thing to watch in this section. Holiday, sick, and PTO rows usually carry a pay code and are excluded from the hours that count toward an overtime threshold, so a week with 36 worked hours and 8 holiday hours is generally not a 44-hour overtime week.

Overtime thresholds, rounding practices, and which hours count toward them vary by employer, state, and country. This is general US-oriented information, not legal or tax advice — confirm the rules that apply to your workplace.

What should you check before approving?

A six-point pass catches nearly everything worth catching:

Every worked day has both times. A missing out time usually means a forgotten clock-out, not a zero-hour day.
Unpaid breaks are deducted. Compare the Break column against the Hours column on at least one row.
Overnight rows are positive and uncapped. No negatives, no suspiciously round 24:00.
The daily rows add to the stated weekly total. Add them yourself once; sheets inherit stale totals when a row is edited.
H:MM and decimal agree. They describe the same time, so 8:15 and 8.25 belong on the same row — 8.15 does not.
Hours past the threshold are on the overtime line. And paid leave is not inflating that threshold.

If you are building the sheet rather than approving it, the companion piece on calculating a weekly timesheet covers the same week from the other side.

Check a timesheet without doing the arithmetic

Hours: Time Card Calculator adds and subtracts time directly in H:MM, so you can re-add a week of daily totals and see whether 39:45 is really what the sheet claims. One tap flips the running total to decimal hours, an hourly rate turns it into pay, the history keeps what you entered, and CSV or PDF export produces a clean record for payroll or a client. Overnight shifts and negative totals are handled rather than blocked.

Verify any time card in seconds

Add hours and minutes, switch between H:MM and decimal instantly, apply an hourly rate, and export a timesheet. Free, works offline, no ads, no tracking, no account. On the iPhone App Store since 2015 and now on Android.

Download Hours free

Frequently asked questions

What do the columns on a timesheet mean?

Date, clock in, clock out, unpaid break, and hours worked are the core five. Most sheets add decimal hours, an hourly rate, a pay figure, and a code or notes column for overtime, holiday, sick, and PTO time.

How do you calculate the hours on a timesheet row?

Out minus in gives elapsed time; subtract the unpaid break to get paid time. 08:00 to 16:30 is 8:30 elapsed, and 8:30 − 0:30 = 8:00, or 8.00 decimal hours.

Why does a timesheet show both hours and decimal hours?

H:MM matches the clock and is easy to check by eye; payroll multiplies decimal hours by the rate. They are the same quantity — 39:45 and 39.75 — so a disagreement between the two columns is an error, not a difference.

How do you read an overnight shift on a timesheet?

An out time earlier than the in time means the shift crossed midnight. Count to midnight and add the rest: 22:00 to 06:00 is 2:00 + 6:00 = 8:00 elapsed, and 7:30 paid after a 30-minute break.

What should a manager check before approving a timesheet?

Both times present on every worked day, breaks actually deducted, overnight rows neither negative nor capped, daily rows adding to the weekly total, H:MM matching decimal, and hours past the threshold sitting on the overtime line.

Is 39:45 on a timesheet the same as 39.45 hours?

No. 39:45 is 39 hours 45 minutes, which is 39.75 decimal hours. Reading it as 39.45 loses 0.30 hours — 18 minutes — and $6.60 at a $22.00 rate. The full conversion is covered in hours to decimal.