This can be used to view only the LineTime for only those calls that connected to a voice, answering machine or fax. So this would exclude any no answers, busies and operator intercepts. Note that the name of the list is 214 Also, the SpitFire LineTime is an internal calculation that starts at the moment one of the Dialer's lines goes off-hook to dial the number and ends when the line is disconnected. Ring time is included.
SELECT sum(LineTime) as `Total Seconds`, count(*) as `Call Count` FROM `001test`.`calls` where StartTime like '2008-01-21%' and (result='201' or result='202' or result='203');