Hi there, I'm having a minor problem with an SQL statement that's being called from Zope to add up some times. Basically times are entered into a database field called "timetaken" in the format of hh:mm I am trying to compile a report to add up the times and give them back in the format of hh:mm Unfortunately using SUM(timetaken) decides to truncate the characters after the ":" and not add them up as hours. Similarly using the SQL REPLACE string command to remove the ":" will then proceed to add the values as decimal values. Is there a simple way? The column itself is defined as a varchar currently, I've tried defining it as time, but it doesn't seem to work properly as it takes time as being clock time (hh:mm:ss AM/PM) Hope someone can help! Many thanks, Michael Billimoria