Seconds to format HH:mm

Questions & Answers
1

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!

2

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
3

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

ops 1
ops 1836Ă—935 105 KB

ops 2

Thanks!

4

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

image
image1002Ă—454 32.1 KB

5

@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.

6