Split time

[johanlind]

I want to see the workload on a manufacturing group per day or maybe per week. I know when the manufacturing order starts, how many hours the order lasts and how many hours per day we work in that manufacturing group. Eg one order starts 2010-11-22 lasts for 20 hours and we work 8 hours per day in that manufacturing group, how do I do for the se the work load per day?

[fernandotoledo]

I would make a script solution breaking one order registry into several registries per day.

Something like a "While" statement that, in each step, loads the order, date+1 as date, duration-Time_per_day as duration where duration-Time_per_Day>=0

You should concatenate the results in the same table and use peek() to accumulate the result

It runs while a registry is read.

the result will be a table with how much hours were spent in each day. You can simply sum it in your charts.

Best regards

Fernando

[johanlind]

I'm not sure that I understand what you mean.
Do you have any example that shows how to do.

[johanlind]

Has anyone some new ideas?