Formula for separate time from seconds needed

[system]

Lucq,

Have a look at these old posts:

120×120 10.4 KB

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)

120×120 10.4 KB

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)