I have a bar chart with y axis in seconds units. I would like it to show as hh:mm. I have done a formula, "Time_hhmm" as below.

------------

NumberVar Hours := Truncate(Remainder({@Time}, 86400) / 3600);
NumberVar Minutes := Truncate(Remainder({@Time}, 3600) / 60);
NumberVar Seconds := Remainder({@Time}, 60);
Totext(Hours,'00') +':'+ Totext(Minutes,'00');
------------

 

While i change the y axis data to "Time_hhmm", it only allow summarize as count.

 

Any idea how to show the @time in hh:mm format at y-axis?

 

Thanks a lot.