Bulk Hours Log Rollup

Month-end, and the timesheet is due — but your hours are buried in a jumble of pasted rows from emails, chat and half a dozen spreadsheets. Adding them up by person and project by hand would eat half your morning. The bulk hours log rollup below does it in seconds: paste the log, pick how to group it, and read off every subtotal.

Paste your hours log below — one row per line as Date, Person, Project, Hours, separated by tabs or commas. The rollup recalculates automatically as you type.

Header row

Weekly totals by person

Weeks start on Monday, so overtime-heavy weeks stand out at a glance.

How the bulk hours log rollup works

Four steps, no sign-up, no setup — you pick how to slice the hours and the tool does the maths.

  1. Paste your log. Copy rows from a spreadsheet, a text file or an email into the big box. One row per line, written as date, person, project, hours, with tabs or commas between the columns. If your first row is a header, leave the header toggle on.
  2. Choose the grouping. Group by person, by project, or person × project to see every combination.
  3. Pick the period. Roll all dates together, split by week starting Monday, or split by month.
  4. Read the totals. Everything recalculates live as you type — group subtotals, period subtotals and a grand total, all shown with two decimals. Copy TSV or Download CSV when you’re done.

Worked example: a messy hours log, totalled

Here’s a small log to try it on — two people, two projects, two weeks. Press Load example in the tool and you’ll get exactly these rows:

Date	Person	Project	Hours
2026-11-02	Alice	Mercury	4
2026-11-03	Alice	Mercury	6
2026-11-04	Alice	Venus	3.5
2026-11-05	Bob	Mercury	8
2026-11-09	Alice	Mercury	5
2026-11-10	Alice	Venus	4.5
2026-11-11	Bob	Mercury	7
2026-11-12	Bob	Venus	6

Set the grouping to Person and the period to By week, and the bulk hours log rollup gives Alice 13.50 hours for the week of Nov 2 and 9.50 for the week of Nov 9, for a personal total of 23.00. Bob gets 8.00 and 13.00, totalling 21.00. The week subtotals come out at 21.50 and 22.50, and the grand total is 44.00 hours.

Now switch the grouping to Person × Project and those same rows regroup instantly: Alice × Mercury 15.00, Alice × Venus 8.00, Bob × Mercury 15.00 and Bob × Venus 6.00 — still 44.00 in total.

Messy rows never break your totals

Real logs are never clean, and that’s fine. Any row with missing or non-numeric hours — or a date the tool can’t parse — is flagged by line number in a warning box and skipped from every sum. The skipped-row count sits right next to the grand total, so nothing is ever dropped silently and you’ll never see a NaN.

Blank lines are simply ignored. Fix the flagged rows in your source, paste the log in again, and the totals update on the spot.

Spot overtime-heavy weeks at a glance

Under the main rollup there’s a dedicated weekly table that totals each person’s hours week by week, with every week starting on Monday. A 50-hour week jumps out immediately, which makes this the view to check right before you approve timesheets or invoice a client.

Add up hours worked, by person and by week

Paste the whole log and the rollup totals the hours by person, by project and by week, with minutes handled properly. Bad rows are flagged and skipped instead of breaking the totals.

Copy or download your rollup

Copy TSV puts the current rollup on your clipboard, ready to paste into any spreadsheet. Download CSV saves the same table as hours-rollup.csv. Load example fills in the demo log above, and Clear empties the log and the results.

Try the bulk hours log rollup on your own log

Paste this week’s entries, set the grouping you need, and give the per-person weekly view a quick look before you invoice — the whole check takes less than a minute. Pair it with the Freelance Capacity Planner when you want to turn finished hours into next week’s plan, use the Weekly to Monthly Allocator to roll weeks up into a monthly view, or check material coverage with the Multi-Item Stock Days Left Calculator.

Bulk hours log rollup FAQs

Which log format does the bulk hours log rollup accept?

One row per line, written as date, person, project, hours and separated by tabs or commas — pasted from a spreadsheet, a text file or an email. Dates like 2026-11-02, 11/02/2026 or 02-11-2026 all parse, hours are plain numbers with decimals, and a header first row is fine as long as the header toggle is on.

How are bad rows handled?

Rows with missing or non-numeric hours, and rows with dates the tool can’t parse, are flagged by line number and skipped from every total, with the skipped-row count shown next to the grand total. Blank lines are ignored, totals never show NaN, and no bad row is ever silently dropped.

Is anything uploaded?

No. The bulk hours log rollup runs entirely in your browser — your log is never uploaded, stored or sent anywhere, and closing the tab wipes it from memory.

How do I add up hours and minutes in Excel?

In Excel, adding hours and minutes across a whole log takes a formula that handles minutes properly, and one bad row can throw the total off. Paste the log here instead and the rollup totals it by person, project and week, skipping bad rows with a note.

Can I total a whole timesheet at once?

Yes. Paste the full log and the rollup returns totals by person, by project and by week, with overtime-heavy weeks easy to spot. You can copy the rollup or download it and paste it back into your sheet.

Privacy note: this tool runs entirely in your browser. Nothing you paste is uploaded, saved or shared — it stays on your device.

Leave a Comment