converting minutes to HH:MM:SS ?? how??

building reports webintelligence
1

Hello All,

How can I convert a column that has values in minutes to actual time in webi or in designer. Would the implementation be easier in webi or designer?

For instance, Lets say i have 3400 min, what formula can i use to conver that to time ( hh:mm:ss )

Thank you.

wanher (BOB member since 2011-04-27)

2

Hi,

Please go through this link. It says how to convert seconds to HH:mm:ss.

You could just multiple 3400*60 and you have the number in seconds, then do as the post says.

Lets know how it goes on.

M H Mohammed :us: (BOB member since 2010-06-16)