How to format seconds to duration HH:MM

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

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.

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


use the format date column:

1 Like

Except when it doesn’t work…

1 Like

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

1 Like

Yes you’re right just for display purpose.

Works like a charm.
Thank you.

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.