SMDR - Calculations

[Gweener]

A big cross over to SQL here, so may well be best placed in that forum.

Trying to interrogate the SMDR file. Have DTS'd into SQL database and now want to interrogate to find total phone time by summing the [Call Duration] field for each agent on a given date.

[Call Duration] is a date time field so cannot be totalled using SQL (or rather, I cannot total).

Anyone experience similar or suggest an alternative?

 

[Gweener]

Should have said - the duration field i want to sum is a DATETIME with the data appearing as HH:MM:SS