SLA met/breached calculation

[333halfevil]

Hi,

I need to somehow calculate proper SLA terget time based on SLA window and on assumption that service is available.

Data available:

CREATEDDATE - date and time when request was created
RESOLVEDDATE - date and time when it was resolved
SLAHRS - SLA window in hours

Vendor working hours - Mon-Fri between 7a.m. - 7p.m.

Example file attached.Book1.xlsx

So if particular request has been created outside working hours SLATEARGET should be calculated starting from 7a.m. next available working day.

I hope that makes sense.
Thanks for your help in advance.

[tarun_arora]

SLA Met/ SLA breach formula is not mentioned in attached Book1 sheet, pls mention so that others can also learn and provide any improvement in existing one

cheers !