Well now I feel a little ashamed.

I put a duration as a time on a recent project. I had no idea the issues it would cause! We did encounter another limitation which is that a TIME can't store more than 24 hours.

Phone numbers are definitely strings, and I've always avoided floats and imprecise numerics like the plague.

I'm sure you already have this, but one solution to the adding the times is as follows.

CREATE TABLE #TimeSheet (

EmployeeID INT,

EntryDate DATE,

RegularHoursWorked TIME,

OverTimeHoursWorked TIME

)

Insert into #TimeSheet Values

(1, '2015/02/02', '08:00:00', '02:30')

, (1, '2015/02/03', '08:00:00', '01:00')

, (1, '2015/02/04', '07:30:00', '00:00')

, (1, '2015/02/05', '08:00:00', '01:30')

, (1, '2015/02/06', '08:00:00', '00:30');

WITH times AS (

SELECT

EmployeeID

, EntryDate

, DATEDIFF(MINUTE, '00:00', RegularHoursWorked) AS RegularMinutes

, DATEDIFF(MINUTE, '00:00', OverTimeHoursWorked) AS OverTimeMinutes

FROM #TimeSheet)

SELECT

EmployeeID

, SUM(RegularMinutes)

, SUM(OverTimeMinutes)

FROM times

GROUP BY EmployeeID

DROP TABLE #TimeSheet