Output time to Seconds

[Saagar]

I want to output 00:53:11 datetime to '11 Seconds'

Can anyone help me with this 

[Kamran1991]

Hi @Saagar,

you can simply  take two characters from right

[Saagar]

Yes, But i want to take 11 and output it as '11 Seconds' not just 11

[Saagar]

Even if i use the datetimeformate(Seconds) function it will give me the output as 11 but I want it as '11 Seconds'

[atcodedog05]

Hi @Saagar 

Use right() function to get last 2 digits refer below. After that add "seconds" string like right([Input],2)+" Seconds"

https://help.alteryx.com/20214/designer/string-functions

Using + to add 2 strings is a common method across multiple programming languages.

Hope this helps : )

[Kamran1991]

I hope this will resolve your query.

Thanks,

Kamran

[Kamran1991]

 you can add any text in this formula. Thanks!