Sum a field

[gapiesco]

I'm trying to sum a time duration field (00:00:00) that apparently is identified as a String type in the database. CR tells me it needs to be a numeric or currency field. Is there a way to convert a string to a numeric field through some type of formula?

 

[Hillary]

ToNumber(fieldname)

Hillary

 

[Hillary]

ToNumber(fieldname) or TimeValue(fieldname)

Hillary

 

[gapiesco]

Haven't got it to work yet, but thanks.

 

[Hillary]

The ToNumber may not work with the :

I looked more closely at the TimeValue in Crystal and noticed the values are seperated by commas (hh,mm,ss) not colons. I also noticed an IsTime(fieldname). I would try IsTime(fieldname) first. If that doesn't you can try and replace : with , and try the TimeValue(fieldname) again. Also, make sure that no one has used the letter O for a zero.

If that doesn't work you may want to re-post.

Good luck!

Hillary

 

[gapiesco]

Probably more my ignorance than your advice. I'll give it a shot. Cheers!