Seconds to format HH:mm

I am trying to convert a data (seconds) to the HH:mm format required by one of your modules but it does not work.

Does anyone know a formula in make for this?


Hi. Are you mean transform timestamp to HH:mm? Like this? If can give us more details we can help you.


Thanks, Helio!
If you have questions reach out :wink:

1 Like

Mmm sounds good, but it doesn’t seem to be working, it always sets the value to 01:00.

ops 2


I just found the solution, although it was quite complicated…


I can see that you are trying to convert the duration to a time stamp. It is a duration, not a time value itself. Hence it was not returning the correct output in HH:mm format.

Now your formula looks pretty to good.