CCZ

Use a new field that is autoincremented, but create a trigger that after you insert a record concats the autoincremented id at the salesrep_ID. Like this: http://dev.mysql.com/doc/refman/5.0/en/triggers.html

Try concat(left(Rendered,6),'00') instead of Rendered: SELECT sec_to_time(SUM(time_to_sec(concat(left(Rendered,6),'00')))) FROM reg_att WHERE EMP_NO = '09300139'; Since, or so it seems, you want to ignore the seconds.