convert seconds in h:mm:ss

[#1]

i have a field having time in Seconds, i want to convert it to h:mm:ss,

Please suggest the best approach

Regards

[sasiparupudi1]

=interval(Interval#(7270 ,'s'),'hh:mm:ss')

[MarcoWedel]

i‌f your seconds might equal more than 1 day, you should use interval instead of time:

Interval(SecondsField/86400,'h:mm:ss')

regards

Marco

[wonkymeister]

my expression

Sum(mySeconds) / (60*60*24)

then in the Number tab, format as time.

Jobs a good'n