LJPS77 Member

Comments

  • 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…
    in Beastmode - Duration (mins) between 2 Datetime Columns Comment by LJPS77 March 11
Default Avatar