Y Axis to appear in Mins

[#1]

Hi,

I have a chart where i want the y axis to appear in minutes not as hh:mm:ss.

The expression appears as mm:

Interval(Avg({<[WTBS_ARRIVAL_DATE]= {'$(vCurrentDay)'}>} WTBS_TREAT_DATE - WTBS_ARRIVAL_DATETIME), 'mm')

and i have changed the Number format of the chart to Time mm:ss, however that hasnt worked either.

Thanks.

[sunny_talwar]

Can you share a sample?

[amit_saini]

Hi,

Try something:

Interval(Time#(FinalTime,'hh:mm:ss') -Time#(StartTime,'hh:mm:ss'),'mm')

Thanks,

AS

[sunny_talwar · Accepted solution]

Try using expression default formatting. For the sample it seems to be working: