C# .NET - how to get the data using groupby in sqlserver

12:01:00
18:32:00
12:30:00
-----------
43:03:00 --------> Total Sum like it


in sql or .net

In c#, one way is sum up the time span object.

ex.

var totalSpan = new TimeSpan(myCollection.Sum(r => r.TheDuration.Ticks));

myCollection is can be a list of timespan.

creating timespan instance

// Use TimeSpan constructor to specify:
	// ... Days, hours, minutes, seconds, milliseconds.
	// ... The TimeSpan returned has those values.
	TimeSpan span = new TimeSpan(1, 2, 0, 30, 0);