Understanding the Peculiar Behavior of SQL Server's DATEDIFF Function When Used with DATEADD

SQL Time Difference Calculation with Weekend and Business Hours Exclusions