How to format seconds to duration HH:MM

[KPT]

I’ve been using the below example using a javascript column to convert seconds to a date format.

@ThinhDinh

You can use this in a JavaScript column.

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

Original answer:

Does anyone know how to change the the format to HH:MM instead of HH:MM:SS - I’ve looked around the internet, but no luck.

[Darren_Murphy]

That JavaScript method is a bit of a hack. Here is a better option:

Format duration in minutes as hh:mm

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 where the value in each row represents a duration in minutes, and I need to format that for display as hh:mm. So, for example… 2914 => 48:34 804 => 13:24 63 => 01:03 5 => 00:05 0 => blank As far as I could tell, none of the plugin columns will handle this. But it looks easy, right? Well, the best I could do with Glide computed columns was 6 (!!) …

[Uzo]

use the format date column:

[Darren_Murphy]

Except when it doesn’t work…

[Uzo]

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

[KPT]

Yes you’re right just for display purpose.

[KPT]

Works like a charm.
Thank you.