convert number of seconds into hours, minutes and seconds

[ali_hijazi]

Hello

I have a field for call duration that contains the number of seconds per call

I want to display the total number of seconds per department on a chart (pivot table) as Xhrs Ymins Zsec

Please help how to accomplish this in the Expression editor

[#2]

seconds:

LOAD *,

        interval(Seconds/86400, 'hh:mm:ss') as "Interval Seconds Formatted"

;

LOAD * INLINE [

Seconds

100000

60

200

7201

]

;

Hope that helps

regards

Sravan

Edit: credit to rob and cookbook