BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: Upcoming Events: BONYMAUG: May 14, BI2014 Nice, France: May 21.

Convert number of seconds to actual time
1 members found this topic helpful

 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
caz
Senior Member
Senior Member



Joined: 11 Apr 2007

Posts: 37


flag
PostPosted: Mon Jun 11, 2007 9:33 am 
Post subject: 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 icon_mrgreen.gif
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 17530
Location: Bratislava


flag
PostPosted: Mon Jun 11, 2007 9:38 am 
Post subject: Re: Convert number of seconds to actual time

Welcome to Bicon_mrgreen.gifB!


Give this formula a try:
Code:
=FormatNumber(Floor(<number of seconds>/3600) ,"00") & ":" &
FormatNumber(Floor(Mod(<number of seconds> ,3600)/60) ,"00") & ":" &
FormatNumber(Mod(Mod(<number of seconds> ,3600) ,60) ,"00")

_________________
BO: BI 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win and Linux servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
caz
Senior Member
Senior Member



Joined: 11 Apr 2007

Posts: 37


flag
PostPosted: Mon Jun 11, 2007 9:48 am 
Post subject: Re: Convert number of seconds to actual time

Many thanks Marek - that worked a treat! icon_biggrin.gif
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 17530
Location: Bratislava


flag
PostPosted: Mon Jun 11, 2007 10:03 am 
Post subject: Re: Convert number of seconds to actual time

You are welcome icon_cool.gif
_________________
BO: BI 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win and Linux servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
HUJ
Principal Member
Principal Member



Joined: 29 Mar 2010

Posts: 177



PostPosted: Mon Apr 05, 2010 12:35 am 
Post subject: Re: Convert number of seconds to actual time

could you please suggest for universe object.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 17530
Location: Bratislava


flag
PostPosted: Mon Apr 05, 2010 3:35 am 
Post subject: Re: Convert number of seconds to actual time

Hi,
knra86 wrote:
could you please suggest for universe object.
This depends on the database that you use.

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

Thanks.

_________________
BO: BI 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win and Linux servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0583 seconds using 17 queries. (SQL 0.0125 Parse 0.0353 Other 0.0105)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo