Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Needed for Transit Time
Good afternoon,
I have created a excel MRP for ordering raw material and I have listed below the forumla I use, but I would like to add in the transit time which is 2 day. Column E F G A244 BRACKET Order 10000 10000 5000 NF Usage 11090 9050 7000 2000 PER BOX Inventory 10000 8910 9860 7860 =ROUND((H131+I131+(J131*0.5)-G132)/2000,0)*2000 From the formula I have above I take the inventory and order two and halfs weeks ahead which has the box quantity listed so I order in even amounts, but I really need to add the transit time, can someone help me with this addition of transit time. Thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Calculation Formula! | Excel Discussion (Misc queries) | |||
time formula question... | Excel Discussion (Misc queries) | |||
time formula | Excel Discussion (Misc queries) | |||
Help! Formula needed. | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel |