• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Stuck for 9 hours. Production hours vs non working hours issue

S

sayoung4517

New Member
upload_2018-3-27_19-46-47.png


I am trying to update these start dates to reflect a 5 day work week with 2 - 10 hour shifts. Currently my start dates are just calculated by subtracting process time from ship date. It does not account for the 4 hours not worked each day or weekends. This one has me stumped. Tried workday function but couldn't get it to work right.

Any help would be greatly appreciated
 

Attachments

  • upload_2018-3-27_19-38-1.png
    upload_2018-3-27_19-38-1.png
    16.6 KB · Views: 1
Hi ,

I assume you want formulae in cells G13:U13 , and G29:W29.

What should these formulae be based on ? Can you work out at least one of these cells and manually enter the correct output that will be required in the cell ?

Narayan
 
The calculations are correct, I just need to figure out how to not assign a date that will be on a saturday or sunday. I also need the calender to only account for 20 hours in a calender day. 4am through 12am. These are the 20 hours that work is performed.
 
The first schedule shows work being performed on the 24th and 25th. I need it so that the system would move those hours to the 23rd and 22nd due to the weekend.
 
You must log in or register to reply here.
Back
Top