I have a Duration column type that I would like to sum and show as a text display name for another column. [Logs] is a Virtual Column list of Refs and [LogDuration] is a duration column on the related table.
However, the result shows seconds (22:35:02) even though the LogDuration Column is set to ignore seconds.
TEXT() does not support duration types else I would set the format desired (similar to using it on price columns to show a currency symbol).
Has anyone found a workaround for this?