# Report on Time between two dates

**URL:** <https://community.hubspot.com/t/report-on-time-between-two-dates/117593>\
**Category:** Dashboards & Reporting\
**Tags:** professional\
**Created:** [October 3, 2024, 9:52am UTC](https://community.hubspot.com/t/report-on-time-between-two-dates/117593 "2024-10-03T09:52:12Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![maulpaurer](https://avatars.discourse-cdn.com/v4/letter/m/b5a626/32.png) [@maulpaurer](https://community.hubspot.com/u/maulpaurer)\
**Post date:** [October 3, 2024, 9:52am UTC](https://community.hubspot.com/t/report-on-time-between-two-dates/117593/1 "2024-10-03T09:52:12Z")

</div>

Hello,

I have two date properties that I created.

Some of my employees are responsible for multiple contacts. I want to see how long it takes each manager on average to get the contacts he/she is responsible for between the first date property and the second date.

How do I create a report showcasing this?

---

<div class="post-metadata">

**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:** [October 3, 2024, 10:01am UTC](https://community.hubspot.com/t/report-on-time-between-two-dates/117593/2 "2024-10-03T10:01:50Z")

</div>

Hi @maulpaurer,

This can be achieved with a calculation property: [Create calculation and rollup properties](https://knowledge.hubspot.com/properties/create-calculation-properties)

Select duration as a number format and specify your two date properties.

Once created, you can create a single object or custom report builder report, and visualize this new property by record owner. Select average as the measure for the new property and you should see the average duration by owner.

Best regards!

---

<div class="post-metadata">

**Author:** ![maulpaurer](https://avatars.discourse-cdn.com/v4/letter/m/b5a626/32.png) [@maulpaurer](https://community.hubspot.com/u/maulpaurer)\
**Post date:** [October 3, 2024, 10:05am UTC](https://community.hubspot.com/t/report-on-time-between-two-dates/117593/3 "2024-10-03T10:05:25Z")

</div>

Thanks for the quick answer.

Is it possible to achieve it only using the reporting functions provided by hubspot, as we are limited with calculation properties

Thanks in advance

---

<div class="post-metadata">

**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:** [October 3, 2024, 10:31am UTC](https://community.hubspot.com/t/report-on-time-between-two-dates/117593/4 "2024-10-03T10:31:31Z")

</div>

@maulpaurer only using Operations Hub Professional and formula fields in reports. Do you have that subscription?

---

<div class="post-metadata">

**Author:** ![maulpaurer](https://avatars.discourse-cdn.com/v4/letter/m/b5a626/32.png) [@maulpaurer](https://community.hubspot.com/u/maulpaurer)\
**Post date:** [October 3, 2024, 11:56am UTC](https://community.hubspot.com/t/report-on-time-between-two-dates/117593/5 "2024-10-03T11:56:18Z")

</div>

I have Operations Hub Professional, so it should work, right?

---

<div class="post-metadata">

**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:** [October 3, 2024, 12:16pm UTC](https://community.hubspot.com/t/report-on-time-between-two-dates/117593/6 "2024-10-03T12:16:15Z")

</div>

@maulpaurer yes, you can find instructions here: [Build and activate datasets in Data Studio](https://knowledge.hubspot.com/data-management/create-and-use-datasets)

The article also explains formula fields.