Hans Öjes
New Member
I am trying to plan backwards based on the followingas input:
- Planned finish time (yy-mm-dd hh:mm)
- Runtime (hh:mm) [Time it takes to manufacture the widget]
- Shop opening time (hh:mm)
- Shop closing hours (hh:mm)
What I am looking for is a formula that can calculate backwards to a planned starting time based on the above, and also take weekend restrictions into consideration (using "NETWORKDAYS")
I hope anyone can help.
I consider myself as being good at Excel, but when it comes to the time-functions I get stuck...
I have attached a file with those fields with sample data, and also a "manual" calculation of what the answer would be.
- Planned finish time (yy-mm-dd hh:mm)
- Runtime (hh:mm) [Time it takes to manufacture the widget]
- Shop opening time (hh:mm)
- Shop closing hours (hh:mm)
What I am looking for is a formula that can calculate backwards to a planned starting time based on the above, and also take weekend restrictions into consideration (using "NETWORKDAYS")
I hope anyone can help.
I consider myself as being good at Excel, but when it comes to the time-functions I get stuck...
I have attached a file with those fields with sample data, and also a "manual" calculation of what the answer would be.