How to add Total hour in c#

Question

Hi All !
I want to get SUM of Hours and Minutes in SQL Server 2005 in To SELECT Query Like : SELECT SUM(OTHours) FROM EmpInOutRecords.

Example: I Have OverTime Hours Like: 01:25, 02:30, 05:56, 00:50

Now I Want To SUM of This Total Hours and Minutes Like Answer is : 10:41

Please Help Me..........

Tanks in Advanced

Abhishek Jaiswal · Answer

Hey! try this SELECT SUM( ) FROM ; You are doing it in right fashion pls mention the error u'r getting.

Ankur Jain · Answer

Hi! you can try like this.. http://sqlfiddle.com/#!3/24cbf/5 Please mark it as answer if its useful....