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
Surendra Kumar Reddy Koduru replied
Processing a Value as a Time
The TIME operator takes any key figure or (partial) formula in general and makes a TIME type key figure. Go to the formula editor and, for the operator, double-click the data function Process Value as Time and, for the operand, double-click the key figure you want. For example, the formula is then Time (Sales).
The system cuts off the decimal places, interprets the value as seconds, and displays the value in the form +-hh:mm:ss. For example, -4812 is displayed as 1:20:12.
Any time is seen as seconds from 00:00:00 and output in hours, minutes and seconds. A TIME type key figure with value 0 is displayed as 00:00:00.
Negative times are permitted: With a negative time the system calculates from 00:00:00 backwards.
The number of hours can be any amount. After 24 hours the system restarts at 0.
This function is designed for offset calculations, among other things. For example, if you need to deduct four hours with time key figures, then you can set the TIME operator.
It may help you.