using DateDiff to find duration in minutes

how about trying this, not sure why you have stime = [exceptions2].starttime and etime = [exceptions2].endtime

SELECT datediff(minute, starttime, endtime) from Exceptions2