Calculate Average Time

[Bell1991]

I need to be able to calculate the average time it takes to fill out a form. I am capturing the start and end time.. But when i attempt to do an average on it - it says it is not allowed.. I am storing them as datetime fields.

avg(dtEndDate - dtStartDate)

 

[craigsboyd]

Here's a runnable example that will give you two ways to do what you want... cut-n-paste the code below into a prg file and execute it.

RAND(-1)
CREATE CURSOR crsTimes (start T, end T)
FOR lnCounter = 1 TO 100
	INSERT INTO crsTimes (start, end) ;
		VALUES (DATETIME() - INT(1000 * RAND( )), DATETIME())
ENDFOR
CALCULATE AVG(End - Start) TO lnAverageSeconds
?lnAverageSeconds
BROWSE

*!* Or
SELECT AVG(End - Start) FROM crsTimes INTO CURSOR crsAvg
BROWSE

SweetPotato Software Website
My Blog