BusinessObjects Board

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 :mrgreen:


caz :uk: (BOB member since 2007-04-11)

Welcome to B:bob:B!

Give this formula a try:

=FormatNumber(Floor(<number of seconds>/3600) ,"00") &amp; ":" &amp;
FormatNumber(Floor(Mod(<number of seconds> ,3600)/60) ,"00") &amp; ":" &amp;
FormatNumber(Mod(Mod(<number of seconds> ,3600) ,60) ,"00")

Marek Chladny :slovakia: (BOB member since 2003-11-27)

Many thanks Marek - that worked a treat! :smiley:


caz :uk: (BOB member since 2007-04-11)

You are welcome 8)


Marek Chladny :slovakia: (BOB member since 2003-11-27)

could you please suggest for universe object.


HUJ (BOB member since 2010-03-29)

Hi,

This depends on the database that you use.

Please post your question in the Semantic Layer / Universe Designer forum.

Thanks.


Marek Chladny :slovakia: (BOB member since 2003-11-27)