ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to calculate my delivery lead time (https://www.excelbanter.com/excel-discussion-misc-queries/239318-how-calculate-my-delivery-lead-time.html)

Excel Dubai[_2_]

How to calculate my delivery lead time
 
I am in charge of an distribution center in UAE. The working days are Sunday
to Thursday.
How can I calculate my delivery lead time with the following criterias :
1) if an order is issued before 14:00 on D day and delivered any time the
next day (D+1), the result would be :" delivered on time"
2) if an order is issued before 14:00 on D day and delivered after the
follwoing day (D+2), the result would be : "late one day". If the order is
delivered on D+3, the result would be :" late two days" and so on
3) if an order is issued after 14:00 on D day and delivered at any time on
the following date (D+1), then the result would be :"delivered on time"
4) if an order is issued after 14:00 on D day and delivered before 12:00 the
next next day (D+2), then the result would be :"delivered on time"
5) if an order is issued after 14:00 on D day and delivered after 12:00 the
next next day (D+2), then the result would be :"late one day". If the order
is delivered on D+3, the result would be :" late two days" and so on

Should you need any further details, you can contact me on


Thanks

Marouane




All times are GMT +1. The time now is 12:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com