The rules are that any shipment created before 3:00pm today must be shipped by 6:00pm on the same day, and any shipments that were created after 3:00pm must be shipped by 6:00pm the following day.

 

The new column would say 'On Time' or 'Past Due'.

 

I am using a creation datetime field, closed status datetime field and a formula that I created that calculates hours total that the shipment took to close.

 

Any help would be greatly appreciated!!  Thanks

 

This formula works perfectly...Thank you very much!  I beside myself at how quickly you resonded to my post!  Thank you again..