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)
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)
Welcome to B:bob:B!
Give this formula a try:
=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")
Marek Chladny (BOB member since 2003-11-27)
Many thanks Marek - that worked a treat!
caz (BOB member since 2007-04-11)
You are welcome 8)
Marek Chladny (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 (BOB member since 2003-11-27)