How to display duration from DB in float value in cross tab report as HH:MM:SS format. Requirement as follows: Date     Abdul Anwer     Tiger Woods     Total 08-17                         00:00:25     03:15:58 07-21                         00:00:01     03:15:58 07-17   02:36:57         00:29:32     03:15:58 07-16                         00:02:34     03:15:58 07-06   00:00:45         00:01:53     03:15:58 06-18                         00:00:27     03:15:58 06-17                         00:02:39     03:15:58 Its showing cumulative value for Total for all rows. I have created following formula which binded summary field: totext(abs(({UserActivityLog.Duration}) / 3600),"00") & ":" & totext(abs(remainder(({UserActivityLog.Duration}),3600) / 60),"00") & ":" & totext(abs(remainder(remainder(({UserActivityLog.Duration}),3600),60)),"00"); Above formula is showing correct value for each user/day. Following formula given in Display String for Total: WhilePrintingRecords; totext(abs((Sum ({UserActivityLog.Duration})) / 3600),"00") & ":" & totext(abs(remainder((Sum ({UserActivityLog.Duration})),3600) / 60),"00") & ":" & totext(abs(remainder(remainder((Sum ({UserActivityLog.Duration})),3600),60)),"00"); Please help me to get correct Total value for each day. Thanks Sharma

Software/Hardware used:
Crystal Report