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…

use the format date column: [Screen Shot 2022-10-04 at 7.15.02 AM]

I belive he just wants to display it… for any other purposes, use the math column

Yes you’re right just for display purpose.

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…

Topic		Replies	Views
Convert Seconds to Duration Ask for Help	2	491	April 18, 2022
How to convert HH:MM:SS to just HH:MM? Ask for Help	41	3782	October 9, 2022
Format duration in minutes as hh:mm Ask for Help custom-code	8	1262	December 29, 2021
Change Duration Format from HH:MM:SS to HH.MM Ask for Help	6	1434	March 29, 2022
Can I convert seconds to minutes? Ask for Help	23	464	December 23, 2022

How to format seconds to duration HH:MM

Related topics