Hi all,
I'm looking at creating a page that can help me with job planning. Essentially I want to give the system a start date and duration (cycle time) then based on this it tells me when it will be finished. However this is part is we run 24/5 and the Friday being a different amount of working time.
Is there a way to tell excel at 7pm the working day has finished and it must then not anticipate work to be complete again until Monday at 7:00 am
So it slips the weekend and does not try to consume time that cannot be consumed.
Hopefully you can help me
Best regards
Louis
I'm looking at creating a page that can help me with job planning. Essentially I want to give the system a start date and duration (cycle time) then based on this it tells me when it will be finished. However this is part is we run 24/5 and the Friday being a different amount of working time.
Is there a way to tell excel at 7pm the working day has finished and it must then not anticipate work to be complete again until Monday at 7:00 am
So it slips the weekend and does not try to consume time that cannot be consumed.
Hopefully you can help me
Best regards
Louis