I am trying to convert duration values into the specific format I need for subtitle timings: 00:00:00,000 - leading zeroes for hour, minute and second, and a comma separating seconds and milliseconds instead of a decimal point.
The formatting options for durations do not allow this level of customisation. I can do it via a function in a few different ways (concatenation, substitution etc) if I can get the formatted duration value (e.g. 0:00:00.000) as a string. Trying to use various text functions on the duration value just returns an empty string, and functions like T and PLAINTEXT do not convert other data types into a string.
Is there a way to convert the formatted duration into a text value?