Skip to main content

How to extract the work duration of tasks that span several days

For help extracting the work duration of tasks that span several days

Written by Emma

Overview

If you require the amount of time that a job works in a day, excluding setup time. For example:
​
A job starts at 2am, then runs till 4.30 productive time 2.5 hours
When there is a break, and the job restarts at 5 and runs till 10 when the factory shuts for the night, the productive time 5 hours
The next morning the job starts at 6am and runs till 8, productive time 2 hours
there is a 15 minute break
the job restarts at 8.15 and finishes at 9 productive time, which equates to 0.75 hours
So the total elapsed time for per day is as follows
Day 1 = 7.5 hours
Day2 = 2.75 hours

Support can get this information for you.


Where can I find this information in the Orchestrate database?

We can run some scripts on the database to obtain the Planned Tasks Slices By Resource. Please contact support, and please include example times and dates you need.

Did this answer your question?