Correction: thats true but i want the results displayed in hh:mm:ss format and total displayed at bottom which i believe is not possible if the column is defined as time/date category. eg if the time column has value 3600, i want to display in hh:mm:ss format (1:00:00) and get the total at the bottom time 0:10:00 0:12:10 ------- total =0:22:10