Calculating Time Between - Not Providing Expected Results

[RCronan4]

I have set up 2 date fields. One for the date an MQL is generated, one for the date when a sales person ends a follow up call.

I am trying to calculate the time between these two date fields.

The calculation is working, but not giving us the data we want. For example, we want a quantifiable output to the nearest minute or hour. But instead we get "a few seconds" or "a day".

And when we look at the ones that say "a few seconds" they're actually about 30 minutes.

Does anyone have any advice on how to get the output I'm looking for?

[matthew-aire · Accepted solution]

Hi @RCronan4 

Happy to see if I can help you here.

In terms of receiving quantifiable data to the nearest minute or hour, below is how HubSpot currently achieves this:

The following behavior is expected when displaying values for time between calculation properties:

• The time will be displayed differently in different HubSpot tools.
• For date properties without a timestamp, the default time used in the calculation will be 12:00 am UTC for the selected day.
• On a record (e.g., a contact record), the displayed value will be in hours, days, months, or years, and will be rounded up to the next unit based on specific thresholds. For example, if the time calculated is one month and twenty days, then the value displayed will be One month, but if the time calculated is one month and twenty-seven days, then the value displayed will be Two months. The thresholds are:
  • 45 seconds or more rounds up to one minute
  • 45 minutes or more rounds up to one hour
  • 22 hours or more rounds up to one day
  • 26 days or more rounds up to one month
  • 11 months or more rounds up to one year

More information can be found in this article here.

Quick question, are the date propertys that you have created Date Properties only, or did you create a Date Time property via the HubSpot API?

Baed on the above answer, if it's only a Date Property, it appears that HubSpot will set the default time used in the calculation as 12:00 am UTC for the selected day. This of course will impact your true calculations.

You can create alternatively create DateTime properties via the HubSpot API, however I don't believe you can use these properties in standard workflows to stamp the property with the date & exact time. I would need to test this further however.

If you have Operations Hub Pro or Enterptise, you could instead use a Custom Code Workflow Action to set the Date Time property with the API, and calculate time betweens this more accuracy.

Please let me know if you'd like to discuss this further with me, or add any additional thoughts below.

Many thanks,

Matt Aire HubSpot Freelancer | Founder @ pocketpros Let's chat HubSpot - book a meeting

👌 If my reply was useful and helped answer your question, please mark it as a solution to help the community!