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

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

here is your solution. This will work for you.



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))

Naveed Ali

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.