Can it be done.... Master scheduler

panasonic2019

New Member
Joined
Sep 2, 2019
Messages
1
Slightly complex and due to restraints i only have Excel to play with. I Want something like this:

Tab 1: Data of jobs to be done

Tab 2: All staff with how many minutes they work per day

Tab 3: All product families we build and how long a batch will take to build in minutes then how many days that will spread across. For example one job will take two days but your only be working on it for an hour, cure times are a day. so meanwhile you could be working on other jobs.

Tab 4: The above information show in a graph

Where would i best be looking to find information on how to do this? Any YouTube links or other forum links? I'm no excel genius but can learn quickly and know the ins and outs. If you fancy showing off skills feel free to help- if you can, i'm guessing it will take a genius

Thanks! Have a good day people.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,214,911
Messages
6,122,192
Members
449,072
Latest member
DW Draft

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top