[thelist] sql query for sum of timediff

[Canfield, Joel]

> select firstname, lastname, sum(timediff(endtime,starttime))
> from presence
> where starttime between '2006-05-31 0:00:00' and '2006-05-31 23:59:59'
> group by firstname, lastname

this returns zero sums in places I know there to be data (names are
unique)

still working on it