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

[system]

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)

[system]

Hi,

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

Convert number of seconds to actual time

We have a value in our database that is the number of seconds past midnight. Is there a way to convert this to hh:mm:ss in Business Objects (hh:mm would suffice) Many thanks in anticipation caz (BOB member since 2007-04-11)

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 (BOB member since 2010-06-16)