# Convert seconds to HH MM SS

**URL:** <https://forum.inductiveautomation.com/t/convert-seconds-to-hh-mm-ss/8739>\
**Category:** Ignition\
**Created:** [July 16, 2014, 11:40pm UTC](https://forum.inductiveautomation.com/t/convert-seconds-to-hh-mm-ss/8739 "2014-07-16T23:40:28Z")\
**Posts on this page:** 3\
**Page:** 2

<div class="post-metadata">

**Author:** ![SergioS](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@SergioS](https://forum.inductiveautomation.com/u/SergioS)\
**Post date:** [October 13, 2021, 12:19pm UTC](https://forum.inductiveautomation.com/t/convert-seconds-to-hh-mm-ss/8739/21 "2021-10-13T12:19:22Z")

</div>

Question : and if I want to do this convertion into a report?

I have one integer value (seconds) that I want to convert into Time or Datetime. How do?

I have try this without success…  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/8/9854befe0592ed83db12992fdcde335620f89979.png)

---

<div class="post-metadata">

**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Post date:** [November 8, 2021, 4:44pm UTC](https://forum.inductiveautomation.com/t/convert-seconds-to-hh-mm-ss/8739/22 "2021-11-08T16:44:15Z")

</div>

> [@paul-griffith](#):
>
> `minutesBetween({Root Container.Popup Calendar.date}, now()) % 60`

I am trying to use a similar script like this ut I do not understand the functionality of %60. Could you please explain that?

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [November 8, 2021, 4:49pm UTC](https://forum.inductiveautomation.com/t/convert-seconds-to-hh-mm-ss/8739/23 "2021-11-08T16:49:26Z")

</div>

Its modulo:

> **[Python Modulo - % Operator, math.fmod() Examples - AskPython](https://www.askpython.com/python/python-modulo-operator-math-fmod)**
>
> Python modulo operator (%) is used to get the remainder of a division. The modulo operation is supported for integers and floating point numbers.

[Previous page](https://forum.inductiveautomation.com/t/convert-seconds-to-hh-mm-ss/8739.md?page=1)