Today let’s talk about a quick tip: how to transform seconds to hh:mm or even hh:mm:ss.
You just have to:
- Create a new metric using your seconds metric and divide it by 86400.
Example of the formula would be: [metric with seconds] / 86400
2. Format the number to be like [h]:mm or [h]:mm:ss
That’s it. You will now see your seconds in a time format.
Hope it helps!
God bless you!