Convert seconds into HH:MM:SS format

[system]

knra86,

Here is an older topic where a formula for DeskI is mentioned:

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)

It should not be a problem to re-write the formula for WebI.

---

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