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.
Opens an editable draft in Millbase. New here? Create your workspace first; your prompt will be waiting.
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 this prompt
- Select Try this prompt to open it in your Millbase composer. Sign up or sign in if needed.
- Use recorded duration fields consistently and verify their units. This analysis is not a payroll submission.
- Send the prompt and review the returned records, date range, and any missing information.
Use it with Millbase MCP
Connect Millbase MCP to ChatGPT, Claude, or a compatible client, then paste this version. The MCP connection reads authorized records; it does not change workspace data.
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.