Convert Seconds to Duration

I have a spreadsheet with a SECONDS column for how long of a run I have done.

I would like to convert this to a the HH:MM:SS format.

How do I do that?

You can use this in a JavaScript column.

return new Date(p1 * 1000).toISOString().substr(11, 8)

Original answer:

2 Likes

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.