# Time in Pipeline in Custom Objects

**URL:** <https://community.hubspot.com/t/time-in-pipeline-in-custom-objects/102423>\
**Category:** 💬 RevOps Discussions\
**Tags:** revops\
**Created:** [March 13, 2024, 9:12am UTC](https://community.hubspot.com/t/time-in-pipeline-in-custom-objects/102423 "2024-03-13T09:12:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SMumby-Harrison](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@SMumby-Harrison](https://community.hubspot.com/u/SMumby-Harrison)\
**Post date:** [March 13, 2024, 9:12am UTC](https://community.hubspot.com/t/time-in-pipeline-in-custom-objects/102423/1 "2024-03-13T09:12:18Z")

</div>

Hi all,

I have recently created a custom object for a client with a pipeline added. However, the client has asked if there is a way to have ‘Cumulative time in’ and ‘Latest time in’ fields as we have in deals.

The client wants to be able to create reports on how long tasks are in their current pipeline stage.

I have tried creating a calculated property using duration but found the issue when it comes to the end time, as there may not be an end time if the object is still in the same stage.

Has anyone found a way around this? Any thoughts would be greatly appreciated.

(Sorry if this is in the wrong category)

---

<div class="post-metadata">

**Author:** ![LouiseHare](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/louisehare/32/49547_2.png) [@LouiseHare](https://community.hubspot.com/u/LouiseHare)\
**Post date:** [March 13, 2024, 11:14am UTC](https://community.hubspot.com/t/time-in-pipeline-in-custom-objects/102423/2 "2024-03-13T11:14:27Z")

</div>

Hi @SMumby-Harrison ,

Does the client have ops hub? If so you can create a Today’s date property and a workflow that schedules every day which updates it. You can then use this property and an ‘Entered stage X date’ property to calculate the duration.

Hope this helps,

| ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/a/d/ad2804ca83c095f0956e2a36693831b2629d440c.png) |
| Louise Hareshe/her |
| _Freelance HubSpot Specialist_ |
| [www.louisemhare.com](https://louisemhare.com/) |
| [Want to chat HubSpot?](https://meetings-eu1.hubspot.com/harelouise) |
| ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/d/edb8a18938b2db8def67e175d50b5dfc8996c600.png) |
| If my reply helped to answer your question please mark it as a solution to make it easier for others to find! |

---

<div class="post-metadata">

**Author:** ![SMumby-Harrison](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@SMumby-Harrison](https://community.hubspot.com/u/SMumby-Harrison)\
**Post date:** [March 13, 2024, 1:38pm UTC](https://community.hubspot.com/t/time-in-pipeline-in-custom-objects/102423/3 "2024-03-13T13:38:58Z")

</div>

Ah yes! I had completely forgotten about the scheduled base enrolment. Thank you!