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…

This had been my previous attempt from a while back. Definitely not elegant by any means. Your javascript solution makes way more sense. [image] Time duration not presenting correctly in glide chart stopwatch Ask for Help I took it a step further and included Days as we…

What an elegant example that shows how a few lines of code can achieve more than no-code. Or maybe the same, but more efficiently. I still prefer your 6-column no-code solution, simply because it is accessible to me, whereas there is no way I would have been able to reproduce your code. …

[image] nathanaelb: I still prefer your 6-column no-code solution, yeah, I get that. I’m the same - I always prefer to get things done with standard computed columns where ever I can. But creating these same 6 columns over and over and over again was driving me absolute bonkers :crazy_face: …

I agree… Nocode is my preferred solution but sometimes a singular hyperformula or extract matching text plug-in column is more efficient.

[image] Darren_Murphy: But creating these same 6 columns over and over and over again was driving me absolute bonkers I agree, in some cases, it’s just more efficient. I have even created a macOS shortcut to access my Github URLs and quickly copy them to the clipboard for the experimental col…

oooh, please share? :slightly_smiling_face:

https://www.icloud.com/shortcuts/369ace3b767942a0881c2790855cf928 Let me know if you can access this link. [image] You can substitute your user name in place of mine (thinhdinhlca) and it should work well. I use it to directly grab my Pages URL instead of having to go to the specific repo to get…

Format duration in minutes as hh:mm

Ask for Help

Jeff_Hager December 28, 2021, 5:45pm 2

This had been my previous attempt from a while back. Definitely not elegant by any means. Your javascript solution makes way more sense.

Topic		Replies	Views
How to convert HH:MM:SS to just HH:MM? Ask for Help	40	3865	October 9, 2022
How to format seconds to duration HH:MM Ask for Help	6	894	October 4, 2022
Time duration not presenting correctly in glide chart ⏱ Ask for Help	8	1942	March 10, 2021
How to convert decimal to duration? Ask for Help	20	1870	June 11, 2022
Column "Duration" and DateTime Enter method not fitting together Report a Bug	3	30	January 24, 2025

Format duration in minutes as hh:mm

Related topics