How do I turn seconds into hh:mm:ss

JKloster

I just want to convert seconds (External Viewing Time column) into hours, minutes and seconds. I can do the formula in excel, but it does not translate when uploaded into smartsheet. I've looked at other forums and discussions and I can't seem to find the answer I'm looking for.

Leah Rankin

Smartsheet does not do this unfortunately. Smartsheet's handling of time values is a huge limitation. Your best bet is probably to convert the field to text in Excel prior to uploading.