I’ve been using the below example using a javascript column to convert seconds to a date format. [image] Convert Seconds to Duration You can use this in a JavaScript column. [image] return new Date(p1 * 1000).toISOString().substr(11, 8) Original answer: Does anyone know how to change the …

That JavaScript method is a bit of a hack. Here is a better option: [image] Format duration in minutes as hh:mm Ask for Help This is a classic example of where a single experimental code column can save you a bunch of Glide computed columns. My use case: I have a column…

How to format seconds to duration HH:MM

Ask for Help

Darren_Murphy October 4, 2022, 11:25am 4

Except when it doesn’t work…

1 Like

Topic		Replies	Views
Format duration in minutes as hh:mm Ask for Help custom-code	8	1204	December 29, 2021
Convert Seconds to Duration Ask for Help	2	480	April 18, 2022
How to convert HH:MM:SS to just HH:MM? Ask for Help	41	3536	October 9, 2022
How to convert decimal to duration? Ask for Help	21	1728	June 11, 2022
Convert time Ask for Help	2	32	October 22, 2024

How to format seconds to duration HH:MM

Related topics