R
Roy
hi,
my query as two fields:
description minutes need
where description is the name of my product and 'minutes need' is the
minutes i'm gonna need to finish the job.
my problem is a bit complicated, i hope u understand and be a bit patiente..
In my factory we work 7.00 till 2.00 - That's 19 hours (1140 minutes)
knowing how many minutes i need to finish my products, i can forecast the
daily times of starting and finishing a product.
But, there's breaks (9.30 till 10.00) and (12.30 to 13.00), etc
how can i transform this:
description Minutes Need
Rump 200
sirloin 200
into this:
description Minutes Need Minutes(Dsum)
Rump 150 150
break 30 180
rump 50 230
sirloin 100 330
break 30 360
sirloin 100 460
where i Can define when the breaks are in a table like:
Break code Between and
1 150 180
2 330 360
etc..
sorry, i know is alot to ask, but any start our ideia will be very apreciated
thank u.
my query as two fields:
description minutes need
where description is the name of my product and 'minutes need' is the
minutes i'm gonna need to finish the job.
my problem is a bit complicated, i hope u understand and be a bit patiente..
In my factory we work 7.00 till 2.00 - That's 19 hours (1140 minutes)
knowing how many minutes i need to finish my products, i can forecast the
daily times of starting and finishing a product.
But, there's breaks (9.30 till 10.00) and (12.30 to 13.00), etc
how can i transform this:
description Minutes Need
Rump 200
sirloin 200
into this:
description Minutes Need Minutes(Dsum)
Rump 150 150
break 30 180
rump 50 230
sirloin 100 330
break 30 360
sirloin 100 460
where i Can define when the breaks are in a table like:
Break code Between and
1 150 180
2 330 360
etc..
sorry, i know is alot to ask, but any start our ideia will be very apreciated
thank u.