Calculating Columns

[TheDTrain]

I am a relatively new user to Crystal 8.0. I have
a field that calculates the time difference between
2 fields. I would like to add up this column so that
it displays a total time. Any suggestions?

Thanks Don

 

[synapsevampire]

Not knowing how you were determining the time difference, (is this in seconds, hours, etc.?).

You can create a formula which shows the time difference:

datediff('s',{datefiled1},{datefield2})

This returns the difference in seconds (check help for datediff for other values).

Place this formula into the detail line and then right click it and use insert summary.

You now have the seconds subtotaled and/or totaled depending on what you chose to do.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com