# Fix time spent calculation in rollup

**URL:** <https://community.hubspot.com/t/fix-time-spent-calculation-in-rollup/142169>\
**Category:** HubSpot Ideas\
**Tags:** properties\
**Created:** [November 6, 2025, 12:11pm UTC](https://community.hubspot.com/t/fix-time-spent-calculation-in-rollup/142169 "2025-11-06T12:11:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mnpjon](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mnpjon/32/82448_2.png) [@mnpjon](https://community.hubspot.com/u/mnpjon)\
**Post date:** [November 6, 2025, 12:11pm UTC](https://community.hubspot.com/t/fix-time-spent-calculation-in-rollup/142169/1 "2025-11-06T12:11:13Z")

</div>

In a rollup it is possible to have a condition where a time spent property is greater, or less than or equals a period of time ago or from now. However a time spent property is not a date, so this does not actually work. Say, for example, the time spent has a current value of 344 days, in that case you would expect it to be less than one year. But not one year ago as that would be 2024 (or perhaps 54 years since 1970 origin of unix timestamp). So the ago part of the equation renders the calculation impossible. Please, fix the equation to remove the ago part, then it would be really useful. Otherwise remove this facility, as it is totally misleading.