How to convert HH:MM:SS to just HH:MM?

[Darren_Murphy]

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 (!!) …