# XY table perspective seconds formatted yAxes

**URL:** <https://forum.inductiveautomation.com/t/xy-table-perspective-seconds-formatted-yaxes/26426>\
**Category:** Ignition\
**Created:** [July 10, 2019, 8:28am UTC](https://forum.inductiveautomation.com/t/xy-table-perspective-seconds-formatted-yaxes/26426 "2019-07-10T08:28:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gfx](https://avatars.discourse-cdn.com/v4/letter/g/96bed5/32.png) [@gfx](https://forum.inductiveautomation.com/u/gfx)\
**Post date:** [July 10, 2019, 8:28am UTC](https://forum.inductiveautomation.com/t/xy-table-perspective-seconds-formatted-yaxes/26426/1 "2019-07-10T08:28:04Z")

</div>

Hi,

I’m really new to ignition and I have some questions. I start with a simple one:

In perspective I’ve an XY chart and on the Y axis I’ve seconds. I would like to show them as HH:mm:ss and not as a simple integer, but in the “format” hints I see nothing that can help me…

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4921bd7684beee26720d1ec1b0221a3579e559c4.png)

I tried writing somethings in the “format” field, but with no luck.  
What syntax can I use in that field to convert the seconds, so an integer, in to HH:mm:ss format?

I “just” need to calculate toInt(value/3600) + toInt( (value%3600)/60 ) + toInt( value%60 ) , but sincerely I don’t know how!

Could you help me?

Thanks  
Giorgio

---

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [March 6, 2023, 7:44pm UTC](https://forum.inductiveautomation.com/t/xy-table-perspective-seconds-formatted-yaxes/26426/2 "2023-03-06T19:44:13Z")

</div>

I am looking for this info in 2023.  
I have a chart I am sorting with minutes right now, wondering how practical it is to switch to hh:mm:ss while I am running 8.1.19. Might leave it as minutes.