How to convert into HH MM SS format?

[dwhitemv]

For anyone reading this old thread,

I hacked up a custom column expression to convert minutes to HH:MM:00 but could be extended to convert seconds easily enough.

You can't do any arithmetic with it, but it might help for exporting data to Excel, etc.

HH:MM:SS Format

I need to add a column that is presented in minutes and present this value in the format HH:MM:sS to the user. Is there a way to transform this field into this format in Metabase? If I do this in SQL, the format is text type and I can't perform the sum.