You must use this formula for properly calculation, It will return the number of hours between ClosedDate and SubmitedDate and it works for short and long durations. CASE WHEN (DATEDIFF(ClosedDate,SubmitDate)*24)=0 THEN (TIME_TO_SEC(TIMEDIFF(ClosedDate, SubmitDate))/60/60) WHEN HOUR(SubmitDate) > HOUR(ClosedDate) THEN…