Convert seconds to HH:MM:SS

[system]

Can someone please advise me on how to convert a field which is in seconds to HH:MM:SS.
So, if I have 1000 seconds it will 16:00:40 after it has been converted.

Thank you in advance for any assistance.

---

Gizmo (BOB member since 2004-11-09)

[system]

Hi,

Have a look here:

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)

---

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

[system]

Create 3 variables

hh = sec/3600
mm = sec/60
ss = mod(sec,60)

and then use convert these number variables into one required string format.

---

Rakesh_K (BOB member since 2007-12-11)