Formula field on the Crystal reports Charts

[info12suchi]

Hi,

I have a formula field "Actual time Duration" which has the following formula.

Stringvar array Std_Time := split(cstr({WOMNT_LABOR.ACT_TIME_DURATION}),".");

val(Std_Time[1])*60+val(Std_Time[2])

And the Display is shown in the Hours.Minutes format with formula in the display string as below.

totext(truncate(currentfieldvalue/60),0,"")+"."+right("00"&totext(remainder(currentfieldvalue,60),0,""),2)

when I try to chart the group footer of this field the chart still considers the Minutes format but not the Hours.Minutes.

But the Chart should be designed on the Hours.Minutes. Please help me on this.

 

[info12suchi]

Inorder to show the time in Hours I wrote a new formula
"Actual_time"

(Sum ({@Actual time Duration}, {@DatePart_DateWorked}, "daily"))/60


Actually the time I should show on the graph is a cummulative time. So I created a running total of the "Actual Time Duration" and which has the value in minutes with display as Hours.Minutes.

Now Wrote a formula "Cummulative" to diplay as hours as below
{#Actual Time running total}/60

But when I am trying to add this to the Data axes, It is not shown in the drop down. How to proceed further