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 Westi 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. cpufixer1

    Convert Text to DD:HH:MM

    That worked ! how do I get it back to DD:HH:MM after I aveage it at the footer ?
  2. cpufixer1

    Convert Text to DD:HH:MM

    Thanks lbass, that is somewhat working. The problem is the DD:HH:MM can sometimes change in length. I need this formula to look for the ':' colons in between instead of the position of the digits.
  3. cpufixer1

    Convert Text to DD:HH:MM

    Thanks again Vega. My field DD:HH:MM is not really a date. it is the lenght of time. So if it's 1:04:05, the incident ticket was open for 1 day, 4 hours and 5 minutes. I have hundrends of these times on a report and I need an aveage.
  4. cpufixer1

    Convert Text to DD:HH:MM

    Thanks Vega, but I am still a bit confused. I have a report with a 150 records on it. The field I need to aveage is the is the close time of each record. This time field is in text. Also it is in DD:HH:MM not, HH:MM:SS. I need the aveage of these close times at the footer. Thanks again.
  5. cpufixer1

    Convert Text to DD:HH:MM

    I have a report of incident tickets. The Open time for each ticket is in the form of a text field DD:HH:MM. I need help getting the aveage open time at the footer. So I need to covert DD:HH:MM to a number and then some how aveage that and then display that back in DD:HH:MM at he bottom of the...

Part and Inventory Search

Back
Top