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!

  • Congratulations strongm 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. mattjol

    Trouble calculating average times

    Good afternoon LB, Found a conversion on Hamady's website to convert from seconds to days:hours:minutes:seconds. It works fine for each group but when I use it in the "Average" field, to convert the average seconds to the days:hours:minutes:seconds format, it displays the same value from the...
  2. mattjol

    Trouble calculating average times

    LB, Maybe the better question to ask is...would it be more appropriate to put the conversion formula in the field format...ie..put it in the "display string" formula or as part of the actual field formula? Thanks, Matt
  3. mattjol

    Trouble calculating average times

    Thanks LB, The number that was showing was the "cnt" and although I thought that's what it was, I didn't want to assume. Adding the last line for "secs" correctly displayed the elapsed time in seconds. I do want to convert those seconds to to properly display hours:minutes:seconds. If I do...
  4. mattjol

    Trouble calculating average times

    Thanks for the reply LB! I get odd results when using the formula you suggested. When I use the first two lines: whileprintingrecords; numbervar secs := DateDiff("s",minimum({rlmain.logdate},{cdcall.number}), maximum({rlmain.logdate},{cdcall.number})); I get what looks like the seconds as...
  5. mattjol

    Trouble calculating average times

    Good afternoon, This will probably go without saying after reading the post but I'm new to formula writing... I am currently trying to provide a report that details ambulance transport times and then calculates average times for all transports. Transport times are calculated by determining...

Part and Inventory Search

Back
Top