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?