I want to put the calculated time based on queried average in the time field of the tasktable.
The time it took to do a job
/ total qty of tasks completed
= time value
time value
* qty of any particular task
= average time to do that task on that job
now average the time that task takes...
I have a database including the time it should take to do any task listed based on an average time it took to do the task in the past. Such as it takes someone about 5 min to install a receptacle, so the database should show the time goal for that task at 5 min.
I record the tasks done on a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.