Sum + conditional subtraction

[jee007]

Hello,

Device:  Microsoft Surface Pro (5th Gen) (Intel Core i5, GB RAM, 128GB), Windows 10 Pro
Excel product name and version number: Microsoft Office 365 version 2105

I am trying to calculate how many days the package was with the deliveryman. However, I need to take into consideration if the deliveryman tried to deliver the package because if he tried, the clock reset. if there are 2 intents (1rst and 2nd visit) and the due time was 48 hrs. I need to subtract 96 hrs to the final delivery time elapse. Also, there are a mix of different due times and some packages went directly to delivery completed.  I have tried to use if and And but I have not had success trying to achieve what I need to.

I would appreciate any help 

[#2]

@jee007 

Perhaps you may clarify on one of the records which results do you expect.

- what is "with the deliveryman" field?

- visits and Delivered are dates, but Due is Hours. Do we assume all dates starts at 00:00 (or Due =48/2 = 2 days or what?)

- we subtract Delivered from latest visit minus Due, and minus another Due if there were two visits?

[#3]

@Sergei Baklan I was able to solve it. Thanks