# Time to Close

**URL:** <https://community.hubspot.com/t/time-to-close/103435>\
**Category:** CRM\
**Tags:** crm, object\
**Created:** [March 26, 2024, 11:26am UTC](https://community.hubspot.com/t/time-to-close/103435 "2024-03-26T11:26:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![TShemesh8](https://avatars.discourse-cdn.com/v4/letter/t/f04885/32.png) [@TShemesh8](https://community.hubspot.com/u/TShemesh8)\
**Post date:** [March 26, 2024, 11:26am UTC](https://community.hubspot.com/t/time-to-close/103435/1 "2024-03-26T11:26:11Z")

</div>

Hi all,

I want to capture the time to close on deals but I don’t want to count time in certain stages. This means I don’t want to do a calculation of time between created and closed date. I tried to calculate by adding up the accumulative time in stages, but I think the problem is, since I have different pipelines, if I add up all the stages for all pipelines the field stays blank because there will never be a value for all properties.

Any idea how I can create this without having to have a different property per pipeline?

Thanks,

Tom

---

<div class="post-metadata">

**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\
**Post date:** [March 26, 2024, 10:53pm UTC](https://community.hubspot.com/t/time-to-close/103435/2 "2024-03-26T22:53:50Z")

</div>

Hey @TShemesh8, thank you for posting in our Community!

Using a custom formula field, you can calculate the time to close deals without the need for separate properties per pipeline. However, the exact implementation may vary depending on your CRM system’s features and customization options.

To our top experts @danmoyle **@Jnix284** do you have any recommendations for **@TShemesh8?**

Thank you,

Pam

---

<div class="post-metadata">

**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\
**Post date:** [March 27, 2024, 11:33pm UTC](https://community.hubspot.com/t/time-to-close/103435/3 "2024-03-27T23:33:10Z")

</div>

@TShemesh8 I agree with @PamCotton that calculated properties are the way to go, [this post on LinkedIn has an easy example showing how to calculate time between two properties](https://www.linkedin.com/posts/james-w-byrne_revops-activity-7178676371160748032-5jnz?utm_source=share&utm_medium=member_desktop).

It comes down to whether you’re [timestamping your deals](https://community.hubspot.com/t5/Dashboards-Reporting/How-to-create-date-stamp-when-deal-moves-along-pipeline/m-p/427250) as they change stages if you’ll have the properties available to calculate.

---

<div class="post-metadata">

**Author:** ![TShemesh8](https://avatars.discourse-cdn.com/v4/letter/t/f04885/32.png) [@TShemesh8](https://community.hubspot.com/u/TShemesh8)\
**Post date:** [April 2, 2024, 12:43pm UTC](https://community.hubspot.com/t/time-to-close/103435/4 "2024-04-02T12:43:20Z")

</div>

Hi @Jnix284 , thanks for the reply.

How would I do this for multiple pipelines? would it be easier to create a custom property to calculate duration per stage and then create a calculation property that would add up the stages that are relevant for my time to close?

---

<div class="post-metadata">

**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\
**Post date:** [April 3, 2024, 11:44pm UTC](https://community.hubspot.com/t/time-to-close/103435/5 "2024-04-03T23:44:44Z")

</div>

Hi @TShemesh8 yes, you would need to create a custom property to calculate the duration between each stage - if your stages are different per pipeline, then you would need to repeat the process for both pipelines.

Once you have the individual stage calculated properties, you would create the sum property to toal them all together.