BusinessObjects Board

Formula for separate time from seconds needed


I have one object which shows total time in seconds for example 2509 second. I would like to separate this time to days, hours, minutes in format: 00 00:00. Does anybody have ready formula?


Lucq :poland: (BOB member since 2008-07-17)

Just go through this to get an idea of the conversion. Use division, mod and Concatenation to get what you wish for.

Jansi :india: (BOB member since 2008-05-12)


Have a look at these old posts:

There are examples of formulas that could help you starting. The formulas are for DeskI so maybe some small modification will be required for WebI.

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

Also you can try this:

=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")

this is given by Marek.

Original Post: Time Format


aniketp :uk: (BOB member since 2007-10-05)