Avarage time spent on an order?

  • Thread starter Thread starter Drygast
  • Start date Start date
D

Drygast

I want to calculate the avarage time an order takes to complete.
I put the dates into a accessdatabase (for instance "2003-10-15"), I would
like to pull the dates into a form
where I would like do something roughly like this:

((DateIN)-(DateOut)) and then add up all the results (for instance
5+4+5+4=18) and divide it with the total amount of orders (for instance
18/4=4.5)

Is it possible?

Regards
/Drygast
 
Drygast,
Yes its possible!

You can use either a loop in VB.NET to do this, or you could use an SQL
statement in the database.

If you are using the DataSet in VB.NET to hold you data, you can even use
DataTable.Compute method in the calculation of the average.

Hope this helps
Jay
 
Back
Top