Use the ToNumber() function in a formula field to convert it to a number first, then sum the formula field. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
Depends upon what you mean by time in text format, I believe that I addressed this concern elsewhere.
If this is the issue of having a duration field which you converted to a text field, do the summing of the field first, and then use the previously described text formatting formula against the sum.
Text is more of a datatype than a format.
So, what is the data type of the field as seen by CR? faq149-732
What does the time string actually look like? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.