This post describes how you can sum a column with a data type of Time in SQL Server. This column might be in a table that has employees working hours, or it might be in a box score table of your favourite sports team. You cannot simply use the SUM() function. How do you do it?

In the example below, the table is [BoxScores] and the column is [MP]. MP stands for Minutes Played.

Select secTotal = SUM(DATEDIFF(SECOND, '0:00:00', MP)) from [BoxScores]