I think there should be no problem to use the SUM() function - did you tried it like this
select SEC_to_time(SUM(unix_timestamp(TTendTime) - unix_timestamp(TTstartTime))) as endtime FROM TimeTracking WHERE TTperson = 1 and date(TTstartTime) = '2005-10-19' HTH -- Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ On Monday 24 October 2005 07:48, [EMAIL PROTECTED] wrote: > I have a table doing time tracking. I don't use timestamps, I use datetime > fields to record punch in times and punch out times. I have this query > that computes the amount of time between a punch in and punch out: > > select SEC_to_time(unix_timestamp(TTendTime) - unix_timestamp(TTstartTime)) > as endtime > FROM TimeTracking > WHERE TTperson = 1 > and date(TTstartTime) = '2005-10-19' > > And this works great except for when people punch in and out several times > in one day. Is there any way I can total a number of records into one > total time? In this example case, I am TTperson #1 and I punched in and > out five times this day. > > I know I can do it in the code, but if I can do it in sql, life would be > better for me. > > --ja > > -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
