Hi .. I need to tap in to a larger idea pool
I am looking at making our current staff rostering easier
Currently we have a excel sheet which shows jobs hour, function, location, job details and staff involved for each job, plus adds up the total rosterd hour for each person..

There are no fixed or rotating shifts.. every day and job can be different

These daily sheets are printed so others in the office can easily see who is doing what.

Then I extract that info based an a persons name .. and its planned to be able to enter the daily rostered hours in the top part of thier outlook calender, and enter a job with all the detail in the time slot for each

I have this 90 % working for me.. next will be looking at doing for the other 20 staff.. but its all looking a bit complicated and like to be slow.

So .. how would you do this ? Hopefully you get th general idea of what we want