How do I turn seconds into hh:mm:ss

Options

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.

Answers

  • Leah Rankin
    Leah Rankin ✭✭✭
    Options

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!