CONVERT(TIME, DATEADD(s, SUM(( DATEPART(hh, date) * 3600 ) + ( DATEPART(mi, date) * 60 ) + DATEPART(ss, date)), 0)) AS totaltime
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)