Extract and display time in Label from DateTime Field in ASP.Net

If you want to show only time in Label then use it like this

Thank You.

Thankyou i get my desired answer my answer is this

SELECT name,CONVERT(time(0), DATEADD(s, SUM(( DATEPART(hh, Timer) * 3600 ) + ( DATEPART(mi, Timer) * 60) + DATEPART(ss, Timer)), 0)) AS Totaltime FROM Project_To_Done Group by name