How to show second in chart

[ashis]

Hello ,

I have two time column and I am calculating second using the following syntax, in the bar chart.

=Interval(End_Time - Start_Time,'ss')

I am getting the proper time in second in the chart in numeric format, now I want to print second text in the chart such as

30 sec , instead of 30 .

in the number tab if I change format setting from expression default to interval and put ss second , I did not get the result.

Could you please help me how to get it.

Thank you,

Ashis

[prieper]

=Interval(End_Time - Start_Time,'ss') & ' seconds'

[Anil_Babu_Samineni]

Is this works?

=Interval(End_Time - Start_Time,'ss') & 'sec'

[ashis]

Thank you for your reply, in expression append does not work.

[ashis]

Thank you for your reply, in expression append does not work.

[Anil_Babu_Samineni]

Why Not?

[antoniotiman]

Hi Ashis,

try like this

Replace(Interval(End_Time-Start_Time,'ss #ec'),'#','s')

=Replace(Interval('14:34:20','ss #ec'),'#','s')

Regards,

Antonio

[ashis]

I am using bar chart , and when I put this syntax, I do not get any result.

[ashis]

It is not working in bar chart.

[tresesco]

For bar chart, try like:

=Dual( Interval(End_Time - Start_Time,'ss') & 'sec'  , Interval(End_Time - Start_Time,'ss') )