Need Formula for SLA Report by Cut Off Time

Hi -

I am working on a report for my department to better track SLA. Currently, we must ship items by a certain time:

Client A - Orders received before 1 PM must ship same day. Orders received after 1 PM ship next day.
Client B - Orders Received before 3 PM must ship same day. Orders received after 3 PM ship next day.

Example: Cut off time of 12 PM.

12/30/2019 17:30:22 TO 12/31/2019 18:30:03 = This is not out of SLA. The cut off time for orders are 12 PM and this order was received after that time. It shipped on the correct day.

12/19/2019 11:45:30 TO 12/20/2019 15:30:23 = This is out of SLA. The order was received prior to 12 PM but did not ship until the next day.


Is there a way to both include and/or exclude weekends? Some clients ship weekends, some don't.

TIA!

I have attached some sample data.

Sorry, but your post is confusing, as is the attachment.

• I don't know what an SLA is, but that may not matter.
• All dates and times in the attachment are in text, so it is difficult to compare them.
• You mention types of customers, but customers are not mentioned in the example you posted.
• I don't think you said what you want to do when you compare times/dates.
• All the dates in col C seem to be at least 3 days later than col B. What is the date in col C, and how does it relate to your question?

I have the similar problem to solve. All orders must ship same day if received by 12pm all order after must ship the following day. The warehouse doesn't work weekends so PM orders that are from Friday ship Monday and all Saturday and Sunday orders as well. what would be the best way to see if the war house has met the KPI?