How to convert axis from minute to hours

[cecilcheah]

Hi there:

I am new in CR

I have done a graph in CR with the y-axis as time axis. The problem is it is showing the values in minutes (from database) and not hours (from CR formula).

So, is there a way to change the values in the y-axis from eg 480 to 08:00?

TIA

Cecil

 

[cecilcheah]

Actually, the axis is showing in numbers, not minutes. I want it to show in hours.

EG: I need to show 480 as 08:00 in the y-axis

Any suggestion?

Cecil