I am developing a report in Bex and I want to know how can i make this calculation in Bex
I will get the average of total Duration.
Ex: Aver Total Dutation: 4926 (Sec)
I want to display as HH:MM:SS ( Which i can use functions)
But to convert this 4926(Sec) -4926/3600 =1.36 But actually .36 represents 3 rd part of 1 hour
so 4926 (Sec) should be displayed as 01:22:08