# Calculate time to close.... **URL:** \ **Category:** HubSpot Ideas\ **Created:** [November 15, 2017, 2:32pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910 "2017-11-15T14:32:15Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![jbarrow](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jbarrow/32/14727_2.png) [@jbarrow](https://community.hubspot.com/u/jbarrow)\ **Post date:** [November 15, 2017, 2:32pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/1 "2017-11-15T14:32:15Z")
Hi, I want to do some analysis on how long it takes deals to close. Clearly, I have access to “create date” for a deal and I know when it moves to “closed won.” I can create a report, export it to excel and run a DATEDIF formula to calculate days to close. Can I do this within Hubspot so I don’t have to do all the manual reporting? If not, this would be a great thing to have from a sales mgt and sales rep perspective. Thanks for any advice. Joe ---
**Author:** ![edjusten](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/edjusten/32/14475_2.png) [@edjusten](https://community.hubspot.com/u/edjusten)\ **Post date:** [November 21, 2017, 10:47pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/2 "2017-11-21T22:47:50Z")
Hi @jbarrow this functionality is not yet available in the tool. Great suggestion though. Can you add this as a [post to our ideas forum](https://community.hubspot.com/t5/custom/page/page-id/ideaslandingpage) for further comment? Thank you, Ed Justen ---
**Author:** ![lapolonyc](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lapolonyc/32/35493_2.png) [@lapolonyc](https://community.hubspot.com/u/lapolonyc)\ **Post date:** [May 8, 2018, 11:09pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/3 "2018-05-08T23:09:19Z")
Any updates on this request? ---
**Author:** ![edjusten](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/edjusten/32/14475_2.png) [@edjusten](https://community.hubspot.com/u/edjusten)\ **Post date:** [May 9, 2018, 2:01pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/4 "2018-05-09T14:01:15Z")
If this was added to the Ideas Forum, any update would be noted there. Ed ---
**Author:** ![tomirasanen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tomirasanen/32/52876_2.png) [@tomirasanen](https://community.hubspot.com/u/tomirasanen)\ **Post date:** [October 18, 2018, 8:16am UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/5 "2018-10-18T08:16:10Z")
There is now a deal property “Days to Close” which can be used for this. You can now create reports about the minimum, average and max days it takes for a deal to be closed. ---
**Author:** ![jbarrow](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jbarrow/32/14727_2.png) [@jbarrow](https://community.hubspot.com/u/jbarrow)\ **Post date:** [October 18, 2018, 1:20pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/6 "2018-10-18T13:20:36Z")
Thanks for the note…when I search for ‘days to close’ on deal properties nothing comes up. Is it called something else? Thanks for your help! Joe ---
**Author:** ![tomirasanen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tomirasanen/32/52876_2.png) [@tomirasanen](https://community.hubspot.com/u/tomirasanen)\ **Post date:** [October 18, 2018, 2:52pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/7 "2018-10-18T14:52:46Z")
I’m not sure if the property is listed in the properties, but at least it was available in the new report builder when I was adding a report/widget to one of our dashboards today. ---
**Author:** ![vikram](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/vikram/32/47092_2.png) [@vikram](https://community.hubspot.com/u/vikram)\ **Post date:** [August 9, 2019, 12:50pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/8 "2019-08-09T12:50:27Z")
It seems that the Days to close field is not based on the history of the closed deals. This simply calculates the days left based on Close Date for future deals. ---
**Author:** ![MDonelan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mdonelan/32/27794_2.png) [@MDonelan](https://community.hubspot.com/u/MDonelan)\ **Post date:** [May 23, 2019, 7:55pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/9 "2019-05-23T19:55:47Z")
One step further than this would be the ability to report on the average number of days to close for deals that are “Closed/Won” versus those that are “Closed/Lost.” There’s a huge difference in the insight gained through that distinction. I want to inform finance what the average sales cycle is for deals we win to help drive headcount/budget planning discussions. It would also be helpful to report on the last deal stage prior to a deal moving to “Closed/Lost.” What stage are my deals going off the rails? How can I train/enable my team to overcome the hurdles at that deal stage? ---
**Author:** ![CharlesFortin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/charlesfortin/32/44643_2.png) [@CharlesFortin](https://community.hubspot.com/u/CharlesFortin)\ **Post date:** [July 3, 2020, 12:59pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/10 "2020-07-03T12:59:17Z")
Any update here @edjusten ---
**Author:** ![Nickcull](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nickcull/32/78108_2.png) [@Nickcull](https://community.hubspot.com/u/Nickcull)\ **Post date:** [December 2, 2020, 10:57pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/11 "2020-12-02T22:57:47Z")
Here’s the solution I came up with: - Create a calculated property that measures time between create date and close date (I called this property “Time to close”) - Create a custom report using a KPI style report - Add the “Time to close” property as your value - Change your aggregation from Sum to Average And… Ta-da! You could easily add a filter to this report to show average time to close by rep or by product/service ---
**Author:** ![jbarrow](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jbarrow/32/14727_2.png) [@jbarrow](https://community.hubspot.com/u/jbarrow)\ **Post date:** [December 3, 2020, 1:05am UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/12 "2020-12-03T01:05:12Z")
👍Thanks for the suggestion, I will check that out! ---
**Author:** ![dmastin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dmastin/32/33826_2.png) [@dmastin](https://community.hubspot.com/u/dmastin)\ **Post date:** [January 12, 2021, 5:05pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/13 "2021-01-12T17:05:38Z")
Empty ---
**Author:** ![torysher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/torysher/32/62359_2.png) [@torysher](https://community.hubspot.com/u/torysher)\ **Post date:** [March 25, 2021, 5:46pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/14 "2021-03-25T17:46:04Z")
Building off of @MDonelan 's post, we’re currently trying to report on the time it takes to go from our “Assessment Call Complete” Deal Stage (meaning their first call with Sales) to “Closed Won.” And on the other side, “Assessment Call Complete” to “Closed Lost.” Since BDRs create most deals in the pipeline and don’t pass it off to technical sales consultants until the sales call is booked, time to close doesn’t give us the data we’re looking for (we want to focus on the time to close once handed to our technical sales consultants). The Closed Won vs Closed Lost distinction is also important. So generally, the request would be to be able to track “Average Time to Closed Won” from a specific Deal Stage, and “Average Time to Closed Lost” from a specific Deal Stage. ---
**Author:** ![SaWells](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sawells/32/18373_2.png) [@SaWells](https://community.hubspot.com/u/SaWells)\ **Post date:** [March 29, 2021, 6:52pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/15 "2021-03-29T18:52:20Z")
@torysher, we had a similar situation with one of our clients. I created date fields for each of the date stages then through a workflow time stamped them when the stage was updated. You would have to still export to excel to calculate the number of days between the close date and the date the deal moved to the specific stage. ---
**Author:** ![sidsaha](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sidsaha/32/93181_2.png) [@sidsaha](https://community.hubspot.com/u/sidsaha)\ **Post date:** [May 27, 2021, 4:32am UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/16 "2021-05-27T04:32:19Z")
I’m struggling with the same issue. This is also linked to other thread and suggestions on calculating Deal Velocity across deal stages. It will be very helpful to have this feature. ---
**Author:** ![SKiss](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@SKiss](https://community.hubspot.com/u/SKiss)\ **Post date:** [December 30, 2021, 6:22pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/17 "2021-12-30T18:22:41Z")
Yes!!! Time to close is a standard sales metric and I’m surprised that HubSpot doesn’t support it. ---
**Author:** ![ash\_cryptio](https://avatars.discourse-cdn.com/v4/letter/a/71c47a/32.png) [@ash\_cryptio](https://community.hubspot.com/u/ash_cryptio)\ **Post date:** [January 6, 2022, 8:32pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/18 "2022-01-06T20:32:24Z")
Any update here? ---
**Author:** ![JonathanS](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jonathans/32/17366_2.png) [@JonathanS](https://community.hubspot.com/u/JonathanS)\ **Post date:** [February 23, 2022, 10:32pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/19 "2022-02-23T22:32:56Z")
Hey everyone! For those who are still looking for a way to calculate how long it takes for a deal to close, I might have a solution that goes an extra step. I’m part of Aptitude 8’s product team (A8 Labs) and we’re currently in Beta for a new SLA Tool called Timerman SLA. This app allows you to assign SLA Policies to both tickets and deals via workflows. **It also tracks time in each stage down to the minute and lets you create reports/dashboards within HubSpot!** We’re releasing the app to beta users so shoot me a message if you’d like to learn more! ---
**Author:** ![NicoleJ](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nicolej/32/76591_2.png) [@NicoleJ](https://community.hubspot.com/u/NicoleJ)\ **Post date:** [July 28, 2022, 8:18pm UTC](https://community.hubspot.com/t/calculate-time-to-close/3910/20 "2022-07-28T20:18:39Z")
+1 [Next page](https://community.hubspot.com/t/calculate-time-to-close/3910.md?page=2)