transform seconds into hh: mm: ss format

Massimo Palmi

Hi all! 
I' d like to have some advice...
I have a layout with a column where I dynamically calculate the number of seconds and where I drill this information from month to day, I'd like to show this information in the hh:mm:ss format, any advice?
Thanks!
Massimo

------------------------------
Massimo Palmi
Consulente
RETEX SPA
Italy
------------------------------

Johannes Blischke

Hi @Massimo Palmi,

let's say your seconds block is "a". You need 4 more blocks in your layout:

b = (a-(mod(a,3600)))/3600     --> returns your hours
c = (mod(a,3600)-mod(b,60))/60     --> returns your minutes
d = mod(b,60)     --> returns your seconds
e = b&":"&c&":"&d


Thanks to @Sebastian Gurt, the solution was found through teamwork. 

Best regards
Johannes



------------------------------
Johannes Blischke
Consultant
Board Community
Germany
------------------------------
-------------------------------------------