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
Naveed
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
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.