OBIEE Custom Format Strings

OBIEE
Custom Format Strings for Conversion into Hours, Minutes and Seconds

Follow the below mentioned steps for custom formatting.

Select Column Properties

Then in the Data Format Tab, select Treat Numbers as Custom. Then write the data Conversion Format String.

Data Conversion Format String	Result
[duration(sec)][opt:dd]:hh:mm:ss	Formats the total of seconds as duration. For example, a duration value of 16500.00 is displayed as 04:35:00, meaning a duration of four hours, 35 minutes, and zero seconds.opt:dd displays the number of days, but if opt has no value, it is not displayed. Second is the default unit of time.
[duration(min)][opt:dd]:hh:mm:ss	Formats the total of minutes as duration. For example, a duration value of 275.00 is displayed as 04:35:00, meaning a duration of four hours, 35 minutes, and zero seconds. opt:dd displays the number of days, but if opt has no value, it is not displayed
[duration(hour)][opt:dd]:hh:mm:ss	Formats the total of hours as duration. For example, a duration value of 4.58 is displayed as 04:35:00, meaning a duration of four hours, 34 minutes, and 48 seconds. opt:dd displays the number of days, but if opt has no value, it is not displayed.
[duration(day)][opt:dd]:hh:mm:ss	Formats the total of days as duration. For example, a duration value of 2.13 is displayed as 02:03:07:12, meaning a duration of two days, three hours, seven minutes, and twelve seconds. opt:dd displays the number of days, but if opt has no value, it is not displayed.