Difference Between two dates that have time windows.

Good Afternoon, I will admit now that I am a novice when it comes to date and time, and also if statements. I am trying to find a solution for the following online but I can not seem to see one about calculating date and time with time windows.

What I am trying to achieve is the following, if any one can help provide the solution or send me in the right direction at least. I have attached my example. I am still learning if statements, think it will sink in soon.

So if a delivery is late, I would like it to state in the column by how many hours and days. So in writting if the delivery date and time as a booking window was 25/11/2021 08:00 - 25/11/2021 08:00 and the date was stated as 26/11/2021 08:00, this would show as 24 hours overdue and 1 day late and so on.

I am unfamiliar with how excel would calculate a time window, and this is why I am seeking advice. I have only done the example as written in logical and not excel.

Thank you so much if any of you can help.