Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. socalgm

    Crystal Reports 11.5

    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...
  2. socalgm

    Crystal Reports 11.5

    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?
  3. socalgm

    Crystal Reports 11.5

    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
  4. socalgm

    Crystal Reports 11.5

    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...
  5. socalgm

    Crystal Reports 11.5

    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

Part and Inventory Search

Back
Top