Keep duration format when using Concantate formula

Topic Labels: Formulas
1526 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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

2 Replies 2

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.