Formula to substract a range of time from a range of time

Hi There,

Thanks for your quick response. PM-AM time difference was my bad as i was not putting the details correctly. It is working fine as i double checked on it again that is why i had edited my earlier comment and i really apologize for the inconvenience.

I am attaching the same sheet that you shared with me, with the same data just adding Sat and Sunday timings on the next sheet.

Your help is greatly appreciated.

P.S: I am aware that i am asking for too much, and i really thank you for that. What i would love to understand is a short summary of the formula logic you have put in instead of just blindly copy pasting and using it, whenever you get the time and if possible for you. My main goal is to learn Excel nested formulas