Help with Production schedule in how calculate end of production run in a 12 hours and 5 days of actual available time to run.

[edrkfd]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a production schedule that I need to modified from 24 hours per day / 7 days a week to 12 hours per day / 5 days a week no weekend. I cannot figure out how to count for the weekend. I am able to adjustment the hours on schedule if we are ahead or behind in production to have a clear picture of production status. I cannot find a way to attach the spreadsheet to this posting. Thanks for your help advance.

 

[mrshl9898]

Tough to say without any examples, you may want to look at =NETWORKDAYS which calculates the difference between 2 dates excluding weekends, or =WEEKDAY will return a number for the day of the week, 7 being Saturday and 1 Sunday.

 

[edrkfd]

Thanks - mrshl9898.

I had no luck with the weekday function. I need to know the time when we expect to be completed. I paste a screenshot of the schedule.

 

[edrkfd]

Is there a way to attached a spreadsheet in this forum? I notice the screenshot did not work.

 

[mrshl9898]

I normally use an external file sharing site (like dropbox). You'll need to upload it somewhere and share the link

 

[Fluff]

There are tools available here https://www.mrexcel.com/forum/about-board/508133-attachments.html
that enable you to post data into the thread

 

[edrios]

Thanks - mrshl9898 for your help. I have attached the link below.

https://www.dropbox.com/s/xjcupwq2tl81ciq/Schedule%20Template.xlsx?dl=0