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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

avarage on hard-defined-cells 2
Adding half days in workday function 0
Formula to sum based on a change in another column 2
Time Date Query 1
Need Ideas for Storing Time Clock information. 5
XP shutdown on avarage 4 times per hour 7
Calculation in a subform 4
Setting record with null field as current record 1

Back
Top