Average time in HH:MM format in crosstab

[Jniland]

Hi, I'm trying to put average time into a crosstab in HH:MM format, but there seems to be no way to format it this way.

I've got an ELAPSEDMINUTES field which I convert to HH.MM elsewhere in the report, and I summarize it in group sections by using:

Int(Average ({@Elapsed minutes}, {TASKS.TYPE}) / 60) + (Remainder (Average ({@Elapsed minutes}, {TASKS.TYPE}),60) / 100)

But I don't see how I can do this in a crosstab (BTW, the crosstab is in the report header)

Thanks for reading

 

[lbass]

In preview mode, right click on the summary field->format field->common->displaystring->x+2 and enter:

totext(int(currentfieldvalue/60),0,"")+":"+
totext(remainder(currentfieldvalue,60),0,"")

-LB

 

[Jniland]

I get to summary field->format field->common but there is no "displaystring". I guess I should've mentioned that I'm using Crystal 8.5.

 

[lbass]

Yes. I think you will have to use a manual crosstab then, where you use the minutes for the calculation and then translate the summary into the HH:MM format using a formula.

-LB

 

[Jniland]

Thanks for your help