Average time chart - format of y axis correctly

[prees959]

Hi,

I am using the following formula to calculate an average time expression in my chart :

=interval(avg( time),'mm')

But, the y axis values don't reflect the expression correctly.  For example, if the chart value is 04:25 (mm:ss) the y - axis is showing :

04:00:00. 

is there any way to format the y-axis to show mm:ss?

Many thanks,

Phil

[sunny_talwar]

May be this

=Interval(Avg(time), 'mm:ss')

[prees959]

Hi,

Thanks for your reply.

Where do I place this formula?

[sunny_talwar]

Where were you using this?

=interval(avg(time),'mm')

[prees959]

Hi,  sorry there was a typo in my initial post - I already have

=interval(avg( time, 'mm:ss')

Just cant get the y -axis to show mm:ss.  Or even better would be great if I can just show minutes as an integer.