Trouble for seconds & time

[ipazzo]

Hi friends

i have trouble in summary functions a date time display.
The case is the following:

i need to compute time difference between the begging and end of a task and show this difference as hh:mm:ss, i need average of this difference and plus i want to display this difference in a a bar chart.

if i use the DateDiff function to have the results in seconds i can make average, but if i convert back the result of datediff with timeserial to have the format hh:mm:ss i cannot make the average.

any simple suggestion ?
Best regards.
Vito M.

 

[Madawc]

I'm not sure I follow what the problem is. Are you converting the time in seconds back to hh:mm:ss in the same command that you find it? If so, split the functions. Have one formula field that finds time in seconds, and which can be averaged. Have another formula field that takes the time in seconds and displays it as hh:mm:ss.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. I use Crystal 8.5

Madawc Williams (East Anglia)

 

[GJParker]

Then use 2 formulas one for hh:mm:ss and a seperate formula for seconds for use in your chart.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[ipazzo]

Thanks for the reply,

The problem is that i want to display the average in the chart in the format hh:mm:ss.

PS. sorry for my bad english.

Regards



Vito M. from BARI (Italy)
---------------------------------------
When you build a TEAM, try always those that they love to win. If you do not succeed to find them, then try those that they hate to lose. Ross Perot

 

[Madawc]

Get the average in seconds. Use a separate formula to display it in hh:mm:ss.

Madawc Williams (East Anglia)