Average time

[Guest]

In my database I am logging multiple tasks that all have a target time in
wjich they need to be completed. I dont know how to work out average times
anyway, but more important the tasks will all be logged in random order.

EG

task target time time taken

task1 5.00
task3 1.30
task3 1.30

How can I log the time taken for each task, is there a way to minus the
times inbetween creating a new record, if I can do this then I can average
out the times.

pls help

Chris

 

[Ron2006]

I, for one, can't figure out what you want from the information you
have given.
I do not know what the data above represents. How does it fit in with
the overall design?
If what you show above is a partial example of the data, what are you
expecting as the answer?

random order is not a problem because you will have to have some type
of sort anyway to get things grouped.