Seconds (string) to "HH:mm:ss" time convertion

Question & Answer
,
1

Hello There,

Hope you can guide me here!

I have a field called “Avg Handled Time”. it’s Data type is “string”, and the value in seconds (example: 650)

How can I present the “seconds” in the “HH:mm:ss” format?

Any help would be greatly appreciated

2

Hi,
here is your solution. This will work for you.

concat(toString(floor({seconds}/3600)),‘:’,toString(floor(({seconds}%3600)/60)),‘:’,toString({seconds}%60))

or

concat(toString(floor(sum(Seconds) / 86400)), “D:”, substring(formatDate(addDateTime(sum(Seconds), “SS”, parseDate(“2000-01-01 00:00:00”, “yyyy-MM-dd HH:mm:ss”)), “dd-MM-yyyy HH:mm:ss”), 12, 10))

regards,
Naveed Ali

3

Thank You Naveed,

for some reasons the both of these options were giving me an error.

However I was able to convert to HH:mm:ss by flowing this link. I had to convert the string field to integer though.