Converting times

system · August 2, 2012, 12:54pm

I have a cross-tab report that calculates the total time in seconds for each task that a user has performed. So if user A has performed task X twice it will sum the two together. Ive used Datediff to calculate the duration in seconds and then the cross-tab calculates the sum.

However, I want to display the total time in hh:mm:ss in the cross-tab report. How do I do it?

Help much appreciated.

StephenPT (BOB member since 2012-08-02)

system · August 3, 2012, 12:17pm

This could help you.

anil.ganga1 (BOB member since 2007-07-04)

system · August 3, 2012, 2:30pm

Thanks but I tried that and the cross-tab report doesn’t allow me to enter such a calculation. Unless I’m doing something wrong?

StephenPT (BOB member since 2012-08-02)