I have a column with a value in seconds which I can easily set up as a mirror showing duration using the formatting option. I now want to concantate that with an integer so I end up with something like
“234 - 01:04:32”
where the formula is
CONCATENATE({integar field}, " - ",{duration field})
trouble is that the latter field converts itself back to seconds! How I can I stop it doing that?
Many thanks