How to calculate my delivery lead time

E

Excel Dubai

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
(e-mail address removed)

Thanks

Marouane
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Someone knows how to add hyperlinks to hours to schedule an appointment? 0
How to use/create code in MS Word to calculate age? 0
Determine if night shift by start & end time 2
sumproduct with additions to data 1
Sumproduct with added days 2
I need Time Range to return Value 4
Sumproduct with variation 1
Style Header Reformatted 3

Top