Recent content by socalgm

In the attached .png file, note that the column under the total hours field is like 14:30:00 and it then converts to 14.00 hours, the daily hours are just a SUM of column at the left and getting no minutes. Thank you for you help. if isnumeric(left({ContHist.DURATION},2)) then...

I did as you said and get a "Bad rime format string" error when trying to save the formula. I assume that I have some data in the duration field that is not formatted like I expected?

Yes, the field is a VARCHAR(14) and it does show up in crystal as such. if isnumeric(left({ContHist.DURATION},2)) then tonumber(left({ContHist.DURATION},2))+tonumber(right({ContHist.DURATION},2))/60 else tonumber(left({ContHist.DURATION},1))+tonumber(right({ContHist.DURATION},2))/60

Thanks LB, but this yields a "0" value. the issue is the field is a varchar type. The data looks like time (01:30:00). I am trying to extract the value of "1.5", so that I can SUM all values in order to report correctly. Currently I can get a value of "1.00", missing the 1/2 hour values. I...

I am trying to convert a varchar field that data stored looks like time (02:30:00). i need to convert and then sum the values. Tried using the Val({ContHist.DURATION}) it will sum only the hours and not the Minutes. Help please