Results 1 to 1 of 1

Thread: Hour based gantt for production scheduling with working/Non working Shifts

  1. #1

    Hour based gantt for production scheduling with working/Non working Shifts



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm trying to create a hour based gantt for a week production scheduling using the conditional formating.
    The production can work 24h/day, divided into shifts of 8 hours. (the shifts are fixed but the production could be stoped in some shifs).
    I'm trying to use a check box to select the working/non working Shifs, but I cant find a way to exclude the non working Time from the total time avaiable.
    I've tryed the NETWORKDAYS function and include the non working shifts in the Holydays but it doesn't work in a hour based time.

    Any help would be much appreciated.
    Thanks
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •