usefulweb.appDependable little tools for people and AI agents. Timeslice Timesheet Summary
Theme: Auto

Theme

Apps Part of Timeslice

Timeslice Timesheet Summary

Paste a timesheet: hours per project, task, tag or client, per day and week, billable sums.

Columns (any order, comma, semicolon or tab): date, start, end or duration, project, client, task, tags, billable, rate, note. Durations like 1h30, 90m, 1:30 or 1.5 work too.

More options
☁ Sign in to save to your Google Drive

Try an example: · ·

More about this tool

How it works

Totals a timesheet table (CSV from any time tracker or spreadsheet) by project, task, tag or client over a date range: hours per day and per ISO week, billable and non-billable time, amounts from hourly rates, optional rounding per entry, a stacked bar chart per day and a donut of the shares.

  • Each row becomes one time entry: date + start + end (an end before the start means the entry runs past midnight), date + start + duration, or date + duration alone (such rows are placed one after another from 09:00 so they still add up per day).
  • Entries are cut at midnight and at the range limits, so a night shift counts on both days. Rounding (optional) applies to each entry piece, to the nearest step or always up.
  • Billable amount = rounded billable hours × the row’s rate (else the default rate). Group by tag counts an entry under each of its tags, so tag totals can add up to more than the total.
  • Weeks are ISO 8601 weeks (Monday to Sunday, week 1 contains the first Thursday of the year). Times are wall-clock times: a night with a daylight-saving change counts the clock difference.

A calculation aid, not payroll or tax advice. Check rounding rules against your contract.

Sources

Part of Timeslice

  • Timeslice Time tracker & timesheets

    Track time on your own tasks, see where it went in charts and share a read-only report.

    Open Timeslice

How to use the Timeslice Timesheet Summary

Paste a timesheet as CSV and get the hours per project, task, tag or client, per day and per ISO week, with billable time, amounts and optional rounding.

What it is for

At the end of a week or month you usually have a table of time entries — from a spreadsheet, a paper time card or the CSV export of a time tracker — and you need the sums: how many hours per client, how much of it is billable, what the invoice comes to. The Timesheet Summary does exactly that. Paste the table, choose what to group by, and you get totals per group, per day and per ISO week, two charts and the amounts.

It is the same calculation the Timeslice app uses for its reports, PDF and share links, so the API, MCP tool and app always give the same numbers.

Worked example

The first example has seven entries for two clients from 2 to 4 November 2026, with columns date,start,end,project,client,task,tags,billable,rate,note. Grouped by project, the result reads: 16:15 h tracked from 2026-11-02 to 2026-11-04 in 7 entries, 15:30 h billable worth 1197.50 EUR; the largest project is Shop website with 8:00 h.

The project table shows Shop website at 8:00 (49.2 %, 560.00 at 70 an hour), Brand refresh at 7:30 (46.2 %, 637.50 at 85) and Studio admin at 0:45, not billable. Per day: Monday 6:45, Tuesday 6:15, Wednesday 3:15, all in week 2026-W45. The average per active day is 5:25.

The third example shows rounding. Five entries such as 09:07–10:52 and 11:03–11:21 are billed in 15-minute steps, rounded up, grouped by client. Every entry is rounded on its own — 18 minutes become 30, 13 become 15 — so the total is 8:45 h and 702.50 EUR, with Acme Bakery at 6:00 h.

How to read the result

  • Total time is in hours:minutes; Decimal hours gives the same as a decimal number for invoices (16:15 = 16.25).
  • Billable and Not billable split the total by the billable column. Billable amount multiplies the billable time of each entry by its rate.
  • Share in the group table is each group's part of the total. With Group by: Tag, an entry with two tags counts under both, so the shares add up to more than 100 % — the tool warns you when that happens.
  • Time per ISO week uses Monday-based weeks; the first day column shows where the range starts inside that week.

Tips and common mistakes

  • Column names can be English or German (Datum, Von, Bis, Projekt, Aufgabe, Stundensatz …), and the separator — comma, semicolon or tab — is detected by itself.
  • Set Dates like 03/11/2026 are to match where the file comes from: 3 November or 11 March. ISO dates like 2026-11-03 are never ambiguous.
  • An end time earlier than the start means the entry runs past midnight; the time is split at midnight between the two days.
  • Rows with a duration but no times (1h30, 90m, 1.5) work too; they are placed one after another from 09:00, and the tool says so.
  • Rounding happens per entry, as most billing agreements require. Rounding the weekly total instead would give a different (smaller) number.
  • Separate several tags in one cell with commas: writing, exam.

FAQ

Does it handle overlapping entries?

It sums them as they are, so overlapping time counts twice. Run the Timesheet Overlap Check first if you are not sure.

Which currency is used?

The one you type, such as EUR, USD or GBP. Rates come from a rate column, or the Hourly rate for rows without one.

Can I limit it to one month?

Yes, fill in From and To. Entries that cross the boundary at midnight only count with their part inside the range.

Is my timesheet stored?

No. The table is processed for the response and not kept.

Guide last updated:

For scripts and AI agents

  • JSON API: POST https://timeslicetimesheetsummary.usefulweb.app/api/v1/calculate (same calculation as this page)
  • Interface description: OpenAPI 3.1 · AI guide: llms.txt
  • MCP server (Streamable HTTP): https://timeslicetimesheetsummary.usefulweb.app/mcp · tool name timeslice_timesheet_summary
Example request
curl -s -X POST https://timeslicetimesheetsummary.usefulweb.app/api/v1/calculate \
  -H 'content-type: application/json' \
  -d '{…see OpenAPI examples…}'
Feedback · ideas & bug reports welcome