# Analyze employee time with MCP

Create a time summary in an external AI client using explicit dates and documented fields. Keeping open sessions separate helps avoid confusing elapsed active time with completed recorded work.

Summarize completed recorded work by employee for last week. Include the exact dates, project breakdown, and any open sessions excluded from completed totals.

[Try this prompt](https://app.millbase.ca/try-prompt?prompt=Summarize+completed+recorded+work+by+employee+for+last+week.+Include+the+exact+dates%2C+project+breakdown%2C+and+any+open+sessions+excluded+from+completed+totals.)

## When to use it

Prepare a weekly labor analysis with a connected MCP client.

## What you need

Authorized task-log fields, worker access for names, and the workspace timezone and reporting dates.

## What you’ll get

- Completed work totals grouped by employee and project.

- Explicit date boundaries, coverage, and treatment of open sessions.

## How to use it

Open the prompt in Millbase, sign up or sign in if needed, then review the editable draft before sending.

Use recorded duration fields consistently and verify their units. This analysis is not a payroll submission.

## MCP version

Connect Millbase MCP in your compatible client: https://millbase.ca/docs/mcp

Use Millbase MCP. Discover the task-logs, workers, projects, and organization fields with list_resources. Confirm last week's dates in the workspace timezone. Query the authorized records with documented date filters, following pagination. Sum completed recorded durations by worker and project, state the units, and list open sessions separately. Report gaps instead of estimating missing time.