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
+18Hi @Jim_Hitch,
I’m not in front of my computer to test it out, but try something along the lines of;
{integar field} & “–” & DATETIME_FORMAT({duration field}, ‘h:mm:ss’)
Hi @Jim_Hitch,
I’m not in front of my computer to test it out, but try something along the lines of;
{integar field} & “–” & DATETIME_FORMAT({duration field}, ‘h:mm:ss’)
Thanks Nathalie, I’ll give this a go early next week when I get a chance and get back to you.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.