# Display HH:MM:SS with duration in numberFormat in a table

**URL:** <https://forum.inductiveautomation.com/t/display-hhss-with-duration-in-numberformat-in-a-table/102324>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [February 13, 2025, 4:43pm UTC](https://forum.inductiveautomation.com/t/display-hhss-with-duration-in-numberformat-in-a-table/102324 "2025-02-13T16:43:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Harry\_O\_Brien](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/harry_o_brien/32/54758_2.png) [@Harry\_O\_Brien](https://forum.inductiveautomation.com/u/Harry_O_Brien)\
**Post date:** [February 13, 2025, 4:43pm UTC](https://forum.inductiveautomation.com/t/display-hhss-with-duration-in-numberformat-in-a-table/102324/1 "2025-02-13T16:43:07Z")

</div>

So I have a table where one of the columns is 'Duration', it is the difference between 2 timestamps. My value is a minute in base 10, so 30 seconds is 0.5, a minute is 1, 20 minutes is 20, 20 seconds is 0.33 etc etc. I want to display this in HH:MM:SS format but when I select 'duration' from the dropdown below it only gives it in DD:HH:MM format.

These are the options for the 'numberFormat' dropdown on the column of the table in Perspective Property Editor

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/b/7b423661318b2f8774642859fc85988d104f9319.png)

This is the value after I select duration.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/5/d506eb562ca7bd2cd6c5c728941b4a10e8845cc7.png)

This is how my column renders, in DD:HH:MM format. Anything less than a minute renders as 00:00.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/1/f1f761059cfa60ba53fecbf38d7459060295f555.png)

And here is the same data when I select 'number' in the numberFormat dropdown

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/1/3174eccd467abbd323425cf309e88e2d930ff931.png)

How can I display this info in HH:MM:SS format?

Thanks

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [February 13, 2025, 5:33pm UTC](https://forum.inductiveautomation.com/t/display-hhss-with-duration-in-numberformat-in-a-table/102324/2 "2025-02-13T17:33:23Z")

</div>

I think the duration format expects an integer representing seconds, not a float representing minutes, and it is actually HH:MM:SS.  
Could you try multiplying the values in that column by 60 ?

---

<div class="post-metadata">

**Author:** ![Harry\_O\_Brien](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/harry_o_brien/32/54758_2.png) [@Harry\_O\_Brien](https://forum.inductiveautomation.com/u/Harry_O_Brien)\
**Post date:** [February 17, 2025, 1:41pm UTC](https://forum.inductiveautomation.com/t/display-hhss-with-duration-in-numberformat-in-a-table/102324/3 "2025-02-17T13:41:29Z")

</div>

Thanks for this, I will try this and report back