dwain.c (10/15/2013)
SELECT STUFF(CONVERT(VARCHAR(20),EndDT-StartDT,114),1,2,DATEDIFF(hh,0,EndDT-StartDT))
+1 to Jeff for that! Absolutely brilliant.
Heh... thanks Dwain but, nah... not brilliant. :blush: Just lazy. I hate typing long formulas... I make too many typing mistakes when they get long. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.