Then.. I created a field in the table called [SLA End Date - Tier 1] and other fields that I use to populate the SLA Hours for each type of call.. [Call Type - SLA Hours Start - Monday] and [Call Type - SLA Hours End - Monday] for each day of the week.. and then also [Call Type - SLA Hours - Tier 1] which contains the number of hours to use.. then also a [Call Type - SLA Calculation Method] which is either SLA or SLA - EOD, those are my two types of SLA methods.. one just uses straight up SLA Hours and one uses the end of day no matter what after applying the SLA Hours.
The formula is crazy but I didn't know how to loop so there is just a bunch of nested If's..
