I have been using $trimleft(%_length%,0)
for my Length column because I didn't want any leading zeros.
This works, but when dealing with short clips less than 1 minute the zero is still stripped and the length displays as :47
or :55
etc.
How can I strip leading zeros for lengths over 1 minute, but keep one single leading zero for anything under 1 minute?