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?

[image] You can use this in a JavaScript column. [image] return new Date(p1 * 1000).toISOString().substr(11, 8) Original answer: [Cleiton] Convert seconds to HH-MM-SS with JavaScript? javascript, date, time, date-format answered by Cleiton on 02:…

Convert Seconds to Duration

Ask for Help

ThinhDinh April 18, 2022, 2:12am 2

You can use this in a JavaScript column.

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

Original answer:

2 Likes

How to format seconds to duration HH:MM

Topic		Replies	Views
How to format seconds to duration HH:MM Ask for Help	7	835	October 4, 2022
How to convert HH:MM:SS to just HH:MM? Ask for Help	41	3484	October 9, 2022
Can I convert seconds to minutes? Ask for Help	23	401	December 23, 2022
How to convert decimal to duration? Ask for Help	21	1721	June 11, 2022
Time Calculations - hh:mm:ss conversion to hh Ask for Help	1	196	April 3, 2023

Convert Seconds to Duration

Related topics