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...
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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.