How to get an 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 importantly 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

 

[Rick B]

Not sure what you mean. To figure out the amount of time taken on a task,
you would need to record the time started and stopped. Your structure below
shows the goal for the task, but has nothing that would let us calculate the
duration spent on each task. You are missing the two key elements - time
started and time stopped.

Once you get the needed data in your table. then you can use the "dateadd"
function to figure out the duration. That duration could then be compared
to the target time. If course, we can't tell from looking if "5.00" is five
hours, five days, or five minutes. You will need your duration to be
formatted in the same increments used to enter your target time.

 

[Rick B]

Oops. This should have said...

"...then you can use the "dateDiff" function to figure..."

 

[Guest]

How do I add those fields to my table ?

Oops. This should have said...

"...then you can use the "dateDiff" function to figure..."