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

[tresesco]

Have you also checked that 'Expression Default' in the number tab is enabled?

[antoniotiman]

Have You checked 'Default Expression' in Number Tab ?

[prieper]

What does not work here?

edit: screenprint was not posted

[ashis]

My output that is coming from expression using interval function giving me output in second only. hence it does not do anything even if I put ss in second.

[hari8088]

May be it will help but not exact solution this

because as we use sec in number format the first S is considering as a seconds symbal.

Instead of seci used $ec there.

Find the attached qvw.