skills.rest
gonzalezpazmonica
gonzalezpazmonicaCOMMUNITY
Explore all skills by this author →
GitHub

time-tracking-report

Generate Excel or Word time tracking reports from Azure DevOps work item data.

47|10|Updated Feb 22, 2026
Search Tags:#project management#reporting#estimation#excel#azure devops#work items#time tracking
One-click install
npx skills add https://github.com/gonzalezpazmonica/pm-workspace --skill time-tracking-report
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: time-tracking-report
Source: https://github.com/gonzalezpazmonica/pm-workspace/tree/main/.claude/skills/time-tracking-report
Command: npx skills add https://github.com/gonzalezpazmonica/pm-workspace --skill time-tracking-report

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the process of generating detailed reports on time spent by individuals on various activities, helping to track project progress and identify potential estimation discrepancies.

Core Features & Use Cases

  • Data Extraction: Retrieves work item details, including estimated, completed, and remaining work hours, from Azure DevOps.
  • Data Transformation: Aggregates and groups time-tracking data by person and activity.
  • Deviation Analysis: Calculates and visualizes deviations between estimated and actual time spent.
  • Report Generation: Creates comprehensive reports in Excel or Word formats.
  • Use Case: A project manager needs to understand how much time developers spent on tasks versus design or meetings this sprint to report to stakeholders.

Quick Start

Generate an Excel report of time tracking for the current sprint.

Frequently Asked Questions about time-tracking-report

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate time tracking reports from Azure DevOps work items?▼

To generate time tracking reports from Azure DevOps work items, this Skill extracts estimated, completed, and remaining hours, aggregates the data by person and activity, and outputs it to Excel or Word.

Can I calculate deviations between estimated and actual time spent in Azure DevOps?▼

Yes, you can calculate deviations between estimated and actual time spent. The Skill transforms Azure DevOps work item data to visualize discrepancies between original estimates and completed work hours.

What do I need to extract time tracking data from Azure DevOps?▼

To extract time tracking data from Azure DevOps, you need a valid Azure DevOps Personal Access Token (PAT), your organization URL, and the specific project name to retrieve work item details.

Does this reporting process support exporting data to Excel and Word formats?▼

Yes, the reporting process supports exporting data to Excel and Word formats. After aggregating work item hours by person and activity, it generates comprehensive project management reports in either format.

How do I aggregate completed work hours by person and activity for project reporting?▼

You aggregate completed work hours by person and activity by running the Node.js scripts included in the Skill, which transform raw Azure DevOps work items into grouped reporting data.

Related Skills

Explore More Product & Management Skills→
VvanlaarVvanlaar

ado

Automate Azure DevOps work item edits, comments, links, and WIQL queries.

Community
Intermediate
Yukine5377Yukine5377

bmad-pm

Automate project management tasks and generate progress dashboards from project briefs.

Community
Advanced
gonzalezpazmonicagonzalezpazmonica
47

sprint-management

Manage sprint lifecycle and generate summaries via Azure DevOps.

Community
Advanced
bradtaylorsfbradtaylorsf
8

jira-retro

Generate retrospective reports from Jira metrics with customizable templates and JQL patterns.

Community
Advanced