Cross Tab Time Calculation 1

[CIBS]

Hi

CR Version using - CR9

I am trying to use a cross tab to display total time for events for each person.

I do have a datediff formula to calculate between the start and stop time. this brings back a standed decimel no so I then use a fomurla to get it to represent as a hh:mm time. The formula I use is

ToText(({@TimeDiff}/60), "00") & ":" & ToText(Remainder({@TimeDiff}, 60), "00")

when in a cross tab all you you can do is a count. I know this is because it is converting to text. but what I want to do to sum the time in the cross tab and have it represented as a time and not just a number. Please Help

Kind Regards

Stephen

 

[lbass]

You should use the number as the summary field in the crosstab, and then in preview mode, right click on the cells->format field->display string and convert the value there like this:

ToText((currentfieldvalue/60), "00") & ":" & ToText(Remainder(currentfieldvalue, 60), "00")

-LB