SLA breach sheet

Hello guys,
Need a quick help on the sheet i have attached where information is extracted from SLA table from "Sheet1(2)" in column N. Now based on this column N i need to calculate the
Expected SLA time and Time left for SLA to breach

For eg:- if open time for P3 ticket is:- 10th May 2015, 9:00AM then as per table for network & HW condition it is - Next biz day between 7AM-4PM.
My expected SLA time shld be 11th MAY, 9:00AM and also i need to know the time remaining from current time for SLA to expire
(Note: Next Biz is only from SUNDAY - THURSDAY)

if it is P1 then the expected SLA resolution time should be 6hrs (24*7) and time left for SLA to expire

and if ticket is breached already then it shows breached
Thanks!!