Formula for separate time from seconds needed

[system]

Hi,

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?

Thx.

---

Lucq (BOB member since 2008-07-17)

[system]

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

---

Jansi (BOB member since 2008-05-12)

[system]

Lucq,

Have a look at these old posts:

Convert minutes to Weeks/Days/Hours/Minutes

Hey guys, I have a column in the SQL Server database which tells me the number of minutes between 2 dates. Could anyone tell me how to convert that to the format; 3 Years, 2 Months, 1 Week, 2 Days, 13 Hours, 52 Minutes. I get lost very quickly. Cheers, Stuart stuartgmilton (BOB member since 2003-01-30)

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)

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 (BOB member since 2003-11-27)

[system]

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

Regards
Aniket

---

aniketp (BOB member since 2007-10-05)