Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=Interval(End_Time - Start_Time,'ss') & ' seconds'
Is this works?
=Interval(End_Time - Start_Time,'ss') & 'sec'
Thank you for your reply, in expression append does not work.
Thank you for your reply, in expression append does not work.
Why Not?
Hi Ashis,
try like this
Replace(Interval(End_Time-Start_Time,'ss #ec'),'#','s')
=Replace(Interval('14:34:20','ss #ec'),'#','s')
Regards,
Antonio
I am using bar chart , and when I put this syntax, I do not get any result.
It is not working in bar chart.
For bar chart, try like:
=Dual( Interval(End_Time - Start_Time,'ss') & 'sec' , Interval(End_Time - Start_Time,'ss') )