# Timeslice Timesheet Overlap Check

> Find time entries that overlap, the hours counted twice and gaps in each day of a timesheet. Checks a timesheet table for entries that overlap each other (time counted twice), shows each overlapping pair with the shared minutes, compares tracked time with the time actually covered per day and, if you like, lists gaps longer than a set number of minutes.

Part of usefulweb.app (https://usefulweb.app/). Part of [Timeslice](https://timeslice.usefulweb.app/) (ownerApp: timeslice). Results are deterministic calculations from the inputs and the listed assumptions; the API returns exactly what the web page shows.

## Use it
- Human interface: https://timesliceoverlapcheck.usefulweb.app/ (interactive tool at https://timesliceoverlapcheck.usefulweb.app/tool)
- JSON API: POST https://timesliceoverlapcheck.usefulweb.app/api/v1/calculate with a JSON object of inputs (schema: https://timesliceoverlapcheck.usefulweb.app/api/v1/tool)
- OpenAPI: https://timesliceoverlapcheck.usefulweb.app/openapi.json
- MCP (Streamable HTTP): https://timesliceoverlapcheck.usefulweb.app/mcp - tool `timeslice_overlap_check`

## Inputs
- entries (textarea): Timesheet table (CSV with a header row) - Columns: date, start, end (or duration), task, project, note. An end before the start means the entry runs past midnight.
- minGapMinutes (number): Also list gaps of at least (minutes, 0 = off)
- dateOrder (select): Dates like 03/11/2026 are

## Method
- Entries are sorted by start; a sweep keeps the entries still running and reports every pair whose times intersect (start of the later one before the end of the earlier one). Touching entries (one ends at 10:00, the next starts at 10:00) do not overlap.
- Per day, the tracked time is the plain sum of all entries; the covered time is the length of their union. The difference is time counted more than once. Entries over midnight are split at midnight.
- Gaps are the empty stretches between covered blocks on the same day (before the first and after the last entry do not count).