Outbound Schedule - Delay and on-time orders

[kapo101]

Hello,
I have a problem creating a formulas, which will tell me if the order was Shipped on time, according to the weekly outbound schedule for certain couriers.
In my example, the orders should be shipped on cutting time by the rule:
If the "Creation Date" is > 4 hours before Courier Departure - all Standard orders should be Shipped
Express Orders - the same, but 2 hours cut-off time.
I must check if all the orders from the Orders Report were Shipped on time (Shipping Date should not exceed the Scheduled Time (weekly) for certain courier)
Thanks in advance.

[Toonies]

Try this Conditional Format H2 Down

Please Login or Register  to view this content.

[kapo101]

Try this Conditional Format H2 Down

Please Login or Register  to view this content.

Thank You, but it doesn't work.

Anyway, I need the cut-off time 4h before the courier departure, which is not always +4h since Creation Date

[Toonies]

ok try this I've based it on the Packing Date and Time against the Shipping Date and Time

I2 down

Please Login or Register  to view this content.

Add CF if you require I2 Green

Please Login or Register  to view this content.

Green

Please Login or Register  to view this content.

Red