Seconds to format HH:mm

Hello!
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?

Thanks!

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

image


Thanks, Helio!
Wemakefuture
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

Thanks!

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

@Ruben_Quilez

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.