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.
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 JaiswalPosted Aug 31, 2014, 4:03 AM
try this
You are doing it in right fashion, pls mention the error u'r getting.
Ankur JainPosted Aug 30, 2014, 4:18 AM
you can try like this..
http://sqlfiddle.com/#!3/24cbf/5
Please mark it as answer if its useful....