Compare employee hours across periods
Compare an employee's recorded hours across two reporting periods using consistent filters. This helps explain changes in recorded workload or project allocation while making differences in period length visible.
Help me compare one employee's recorded hours across two date ranges. Ask for the employee and both periods, retrieve each period using the same scope, and show total hours and project allocation. State the number of days in each period and explain missing data without rating performance.
Opens an editable draft in Millbase. New here? Create your workspace first; your prompt will be waiting.
When to use it
An employee's time total changed and you want to understand whether the recorded work moved between projects or reporting periods.
What you need
An employee name or code and two explicit date ranges. Comparable records and the same timezone are needed for a meaningful comparison.
What you’ll get
- Hours for both periods with their exact dates and project breakdowns.
- Absolute differences and a note about unequal period lengths or incomplete records.
How to use this prompt
- Select Try this prompt to open it in your Millbase composer. Sign up or sign in if needed.
- Use equal-length periods when possible. More recorded hours can reflect different assignments or overtime; the comparison does not independently measure efficiency or output quality.
- Send the prompt and review the returned records, date range, and any missing information.