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?
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:
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.