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

[Anil_Babu_Samineni]

Try this?

Dual(Interval(Works,'ss') & ' sec', Interval(Works,'ss'))

[dinuwanbr]

Hi Ashis,

Check this. If your problem is still please upload a sample.

Rgds,

Tharindu

[ashis]

Hi Tresesco,

As suggested , I used the following syntax and results are coming like 0.0057060185281443 which is wrong.

=dual(Interval(End_Time - Start_Time,'ss') & ' Sec',Interval(End_Time - Start_Time,'ss'))

is anything I am missing.

[ashis]

As suggested , I used the following syntax and results are coming like 0.0057060185281443 which is wrong.

=dual(Interval(End_Time - Start_Time,'ss') & ' Sec',Interval(End_Time - Start_Time,'ss'))

Is anything I am missing.

[ashis]

Hi,

You are taking as calculated dimension, where as I am calculating it in the expression . I am using different dimensions in my chart. I need to calculate it in expression only and in the chart need to show as 20 sec or 30 sec instead of 20 or 30.

Thank you for your reply.

[Anil_Babu_Samineni]

What you are showing that is correct synthetically. Share me the image using 2 formulas in straight table

[ashis]

see the attached screen shot.

[Anil_Babu_Samineni]

Can you try this? Or i would need application to test

=dual(Interval(End_Time - Start_Time,'hh:mm:ss')*60*60 & ' Sec',Interval(End_Time - Start_Time,'ss'))

[ashis]

This should be  493 sec / 192 sec

[ashis]

same result.