How to sum set of string values in SQL

Question

I have a Time column in a table datatype is string such as

0:00:00
1:43:39
2:12:07
0:44:28
0:59:32

it is stands like HH:mm:ss

i want to add these values . please suggest me to get a solution

Thanks in Advance.

Tim Schmelter · Accepted Answer · 2015-06-22 07:45:05Z

2

Why is it string/varchar and not time? However, you can cast it to Time:

SELECT  SUM(DATEDIFF(MINUTE, '0:00:00', CAST([Time] As Time))) As TimeSumInMinutes
FROM dbo.TableName

answered Jun 22, 2015 at 7:45

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1