Hours Calculator: Add Up Work Hours for Timesheets

I was standing in the lumber aisle doing math on my phone and nothing was adding up.

I’m not even kidding — I had a scrap of paper with start times, stop times, a lunch break, and a “drive to site” block, and I kept getting two different totals depending on which calculator app I used. I nodded like I understood why. I didn’t. And that little moment is basically why we built ProCalc.ai calculators in the first place: you shouldn’t have to be a spreadsheet person to turn a messy day into a clean timesheet.

So if you’re staring at a time card right now and you just need the total hours (and you need it to match what payroll expects), you’re in the right spot.

And yes, the annoying part is the minutes.

Here’s the main tool I use when I don’t feel like re-learning time math for the 500th time:

. If you’re logging multiple chunks in a day, this one saves your sanity:

. And if you’ve got “8.75 hours” on one sheet and “8:45” on another and you’re about to lose it, use

and

to translate back and forth.

What you’re actually doing (and why people keep getting it wrong)

The thing is, time isn’t base-10. Money is easy: 10 pennies is a dime, done. But time is base-60, which is kind of a rude choice when you’re trying to add stuff fast. So you’ll add 7 hours 45 minutes and 8 hours 30 minutes and your brain wants to treat “45 + 30” like normal math and you end up with “7.75 + 8.30” (which looks right, feels right, and is wrong).

So why does everyone get this wrong? Because the format looks like decimals, but minutes aren’t decimals. 8:30 isn’t 8.30 hours. It’s 8.5 hours. That’s the whole game.

And payroll systems usually want one of two things: either a clean HH:MM total (like 41:15) or a decimal total (like 41.25). If you hand them the wrong flavor, you can be off by enough to matter — not “oops I’m one minute off,” but “oops I just lost 0.3 hours” which is like 18 minutes. That’s not nothing.

How I add up work hours for a timesheet (the way that doesn’t bite you later)

I’m going to walk you through the exact pattern I use, because once you do it this way a couple times, it’s almost boring (and boring is good for timesheets).

Step 1: Write each work block as start → end.
You can do this per day, per job, whatever. Just don’t skip the breaks.

Step 2: Convert each block into a duration.
If you worked 6:50 to 11:35, that’s 4 hours 45 minutes. If you hate doing that subtraction, just use

and move on with your life.

Step 3: Subtract unpaid breaks.
This is where people “sort of” subtract lunch and then wonder why the weekly total won’t match. If lunch is 30 minutes, it’s 0:30, not “about half an hour or whatever.” Be annoying about it.

Step 4: Add durations together, carrying minutes like you’d carry tens.
60 minutes becomes 1 hour. That’s it.

Step 5: Convert to decimal only if you need to.
A lot of systems want decimals. Some don’t. Don’t convert unless you have to, because it’s another chance to mess it up.

So here’s a real-ish day that looks like my life: I’m on site, I leave for materials, I come back, I take lunch late, I do a short punch-list run. It’s not a neat “8 to 4” day.

Now let’s do a worked example with actual numbers.

Example day (same day, multiple blocks):

• 7:10 to 11:55 (morning work)
• 12:35 to 3:20 (afternoon work)
• 3:40 to 5:05 (finish-up)

And there’s an unpaid lunch from 11:55 to 12:35 (40 minutes).

1) Turn each block into a duration

• 7:10 → 11:55 = 4:45
• 12:35 → 3:20 = 2:45
• 3:40 → 5:05 = 1:25

2) Add them
4:45 + 2:45 = 7:30 (because 45 + 45 = 90 minutes, which is 1:30, so 4+2+1 = 7 hours and 30 minutes)
7:30 + 1:25 = 8:55

Result: 8 hours 55 minutes worked.

If payroll wants decimals, convert 55 minutes to hours: 55 ÷ 60 = 0.9166… so it’s about 8.92 hours (rounded to two decimals). If you want that conversion without thinking, use

.

But don’t round too early. That’s a sneaky one. If you round every day to two decimals and then add the week, you can drift. Add the minutes for the week first, then convert once.

A quick table you can steal for your own timesheet math

I like tables because they make the “carry the minutes” thing obvious (and because my brain stops arguing with me when it’s laid out).

Day	Work Blocks (Start–End)	Unpaid Breaks	Total (HH:MM)
Mon	7:10–11:55, 12:35–3:20, 3:40–5:05	11:55–12:35	8:55
Tue	7:30–12:00, 12:30–4:45	12:00–12:30	8:45
Wed	8:05–11:50, 12:20–5:10	11:50–12:20	8:35
Thu	7:00–11:40, 12:25–4:10	11:40–12:25	8:25
Fri	7:15–12:05, 12:35–3:30	12:05–12:35	8:45

So if you add that week in HH:MM: 8:55 + 8:45 + 8:35 + 8:25 + 8:45 = 43:25.

And if you need that as decimal hours: 25 minutes is 25 ÷ 60 = 0.4166… so the week is about 43.42 hours.

That’s a lot of minutes hiding in plain sight!

Little traps I’ve stepped in (so you don’t)

Crossing noon / midnight. If you’re working nights, the subtraction gets weird fast. Don’t “mental math” that at 6:00 AM. Use

and be done.

Mixing formats on the same sheet. If Monday is written as 8:30 and Tuesday is written as 8.5, you’ll eventually add them wrong. Pick a lane. If the system wants decimals, convert everything using

. If it wants clock time, keep it HH:MM and only convert once at the end (or never).

Rounding rules you didn’t agree to. Some companies round to the nearest 5, 6, 10, or 15 minutes. I’m not telling you what’s “right” here — I’m just saying you should know what rule you’re under. If you’re tracking your own time for invoicing, be explicit about your rounding so you don’t end up in a dumb argument later.

Forgetting unpaid breaks that aren’t lunch. The “quick run to pick up parts” might be paid, might not. Same with a long personal break. Write it down anyway. You can decide how to code it later, but you can’t remember it later. (Well, I can’t.)

If you want a straight add-and-subtract tool, again, this is the simplest:

. If you’re converting a payroll export that’s in decimals back into normal time so it makes sense to a human, use

.

FAQ

How do I convert 8:45 to decimal hours?

Take the minutes and divide by 60. So 45 ÷ 60 = 0.75, which makes 8:45 = 8.75 hours. If you don’t want to do that every time (fair), use

.

Why doesn’t 8:30 equal 8.30 hours?

Because “:30” means 30 minutes, and 30 minutes is half an hour. Half an hour is 0.5 hours, not 0.30 hours. So 8:30 = 8.5 hours.

If you want to flip decimals back to clock time (like 8.5 → 8:30), use

.

Should I add daily decimals or add minutes for the whole week?

My preference: add minutes (HH:MM) for the whole week, then convert once.

• It avoids rounding drift.
• It matches how time actually works (60-minute carry).
• If payroll wants decimals, you still get them — just later.

If you’re stuck and your numbers still feel “off,” it’s usually one of three things: a missed break, a cross-midnight shift, or a sneaky format mix (8:45 written as 8.45). Fix that, and the math suddenly behaves.

And yeah, once you’ve done it the clean way a few times, you’ll wonder why you ever fought with it.