# Display an interval with rounded value

**URL:** <https://community.tulip.co/t/display-an-interval-with-rounded-value/11686>\
**Category:** Support, Troubleshooting, & Help\
**Tags:** apps\
**Created:** [June 7, 2024, 2:25pm UTC](https://community.tulip.co/t/display-an-interval-with-rounded-value/11686 "2024-06-07T14:25:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![christophe.pinard](https://avatars.discourse-cdn.com/v4/letter/c/53a042/32.png) [@christophe.pinard](https://community.tulip.co/u/christophe.pinard)\
**Post date:** [June 7, 2024, 2:25pm UTC](https://community.tulip.co/t/display-an-interval-with-rounded-value/11686/1 "2024-06-07T14:25:19Z")

</div>

Hi,  
We mesure lead time as an interval value (difference between start and stop time).  
We would like to display the average value of the lead time.  
I use query + aggregation (avg function) on the table.  
The value is displayed as DD:HH:MM:SS, witch is heavy for an opertor.  
We would like to change the format, or display a value in days only.  
i’ve tried to divide the interval by 86,400, but the result can only be store as an interval data type.  
Any suggestion for this ?  
Regards  
Christophe

---

<div class="post-metadata">

**Author:** ![John](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/john/32/4971_2.png) [@John](https://community.tulip.co/u/John)\
**Post date:** [June 7, 2024, 2:36pm UTC](https://community.tulip.co/t/display-an-interval-with-rounded-value/11686/2 "2024-06-07T14:36:39Z")

</div>

Hey @christophe.pinard, thanks for the question and welcome to the community!

Try the `interval_to_seconds()` function in the expression editor to get your interval into a more workable datatype. [Here’s the documentation on that expression](https://support.tulip.co/docs/typecasting-expressions) (control+F for “interval”).

Additionally, there’s a `rounddatetime()` expression that will give you the result you’re looking for if you can get your initial value into datetime format.

Let me know if this works!
