# Task duration reporting **URL:** \ **Category:** Dashboards & Reporting\ **Tags:** reports, tasks\ **Created:** [April 23, 2025, 12:25am UTC](https://community.hubspot.com/t/task-duration-reporting/130346 "2025-04-23T00:25:25Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![CLBF](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@CLBF](https://community.hubspot.com/u/CLBF)\ **Post date:** [April 23, 2025, 12:25am UTC](https://community.hubspot.com/t/task-duration-reporting/130346/1 "2025-04-23T00:25:25Z")
Hi! I’m trying to find a way to report on how long it took for someone to complete a task from the time it’s created to the time it closes. Is this possible with the ‘Task’ object? I have a report that shows the number of tasks completed by person, by day, but we want to measure productivity and how quickly the tasks are completed. ---
**Author:** ![JessicaHatchiDigital](https://avatars.discourse-cdn.com/v4/letter/j/5f9b8f/32.png) [@JessicaHatchiDigital](https://community.hubspot.com/u/JessicaHatchiDigital)\ **Post date:** [April 23, 2025, 3:15am UTC](https://community.hubspot.com/t/task-duration-reporting/130346/2 "2025-04-23T03:15:22Z")
Hi @CLBF, In HubSpot, you can’t directly report on how long a task took (from created to completed) using default reports. But there are two workarounds I coukd think of: 1. Export and calculate manually Export your tasks (with created and completed dates) and do the math in Excel or Google Sheets. 2. Use a time tracking integration I think tools like TMetric or Simple Time Tracker plug into HubSpot and track how long tasks actually take. Not perfect, but doable! Best, Jess ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 23, 2025, 4:19am UTC](https://community.hubspot.com/t/task-duration-reporting/130346/3 "2025-04-23T04:19:16Z")
Hi @CLBF, Are you interested in the time between task creation and completion or the actual time spent for completing the task? If it’s the former, there is currently no default calculation property on the task object that calculates the time between “Created at” and “Completed at”. If you have those two columns in your report, then you could add a formula field in your report (this is a beta under Settings \> Product updates \> ‘Formula Fields now in Custom Report Builder’) to calculate the difference. If you’re not displaying the creation and completion dates for each task in your report currently and want averages by user, I don’t think this calculation is possible at this point, at least not without creating your own dataset in HubSpot: [Build and activate datasets in Data Studio](https://knowledge.hubspot.com/data-management/create-and-use-datasets) Alternatively, this report can be achieved easily in Google Sheets or Excel, by simply exporting your raw task information (Menu \> CRM \> Tasks) and then calculating the time required for each task there. If you’re interested in actual time spent on completing a task, that would require a time tracking integration from the HubSpot app marketplace: [https://ecosystem.hubspot.com/marketplace/apps/?eco\_search=time%20tracking](https://ecosystem.hubspot.com/marketplace/apps/?eco_search=time%20tracking) – the reporting here depends on the exact capabilities of the app and where it documents the tracked time. Best regards! ---
**Author:** ![CLBF](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@CLBF](https://community.hubspot.com/u/CLBF)\ **Post date:** [April 23, 2025, 1:24pm UTC](https://community.hubspot.com/t/task-duration-reporting/130346/4 "2025-04-23T13:24:29Z")
Thank you! Not sure we have the right subscription to use the formulas, but I’m going to ask! ---
**Author:** ![victoriahcw](https://avatars.discourse-cdn.com/v4/letter/v/3ab097/32.png) [@victoriahcw](https://community.hubspot.com/u/victoriahcw)\ **Post date:** [May 27, 2025, 12:09am UTC](https://community.hubspot.com/t/task-duration-reporting/130346/5 "2025-05-27T00:09:00Z")
Great question! While the Task object in HubSpot doesn’t natively calculate time-to-completion, you can get this data by using the task creation date and completion date. Export the data and calculate the difference in Excel, or use a custom property or workflow to log the duration once a task is completed. This will let you build reports to track average completion time and compare productivity across users. To streamline this, [Coefficient](https://app.hubspot.com/ecosystem/7039851/marketplace/apps/coefficient) can help by automatically pulling your task data into Google Sheets or Excel, calculating time-to-completion, and syncing summary metrics back to HubSpot. It’s a powerful way to automate tracking and gain deeper visibility into team performance—without manual work.