snoopsterg
New Member
- Joined
- Sep 27, 2006
- Messages
- 6
Hi All, Hope this is posted in correct place.
I have a production schedule that i need to make available for my colleagues.
At the moment the data is stored in a SQL database which i have full admin access to and need to export to excel as below
Date Time Cum Total
06:00hrs
08/06/2007 08:00hrs 0 0
10:00hrs M/R 0 0
12:00hrs M/R 0 0
14:00hrs 4500 4500 4500
16:00hrs 18000 18000 22500
18:00hrs 18000 18000 40500
20:00hrs 4500 4500 45000
22:00hrs 0 45000
What this actually depicts is Job Number, start date, start Time, Run speed, Run Minutes, Make Ready minutes (MR).
I can get at all the data but am struggling how to get the following to create the above.
StartDate | EndDate | QTY | MRMins | RunMins | Spd
08/06/2007 10:00 08/06/2007 22:00 45000 120 300 9000
any help would be appreciated
Steve
I have a production schedule that i need to make available for my colleagues.
At the moment the data is stored in a SQL database which i have full admin access to and need to export to excel as below
Date Time Cum Total
06:00hrs
08/06/2007 08:00hrs 0 0
10:00hrs M/R 0 0
12:00hrs M/R 0 0
14:00hrs 4500 4500 4500
16:00hrs 18000 18000 22500
18:00hrs 18000 18000 40500
20:00hrs 4500 4500 45000
22:00hrs 0 45000
What this actually depicts is Job Number, start date, start Time, Run speed, Run Minutes, Make Ready minutes (MR).
I can get at all the data but am struggling how to get the following to create the above.
StartDate | EndDate | QTY | MRMins | RunMins | Spd
08/06/2007 10:00 08/06/2007 22:00 45000 120 300 9000
any help would be appreciated
Steve