Changing number format from seconds to mm:ss

[system]

Does any one have a formula to convert seconds to minutes and seconds. Example convert 315 seconds to 6:15 (mm:ss)

---

kperry167 (BOB member since 2011-11-04)

[system]

Hi,

This old topic can get you started:

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)

You need to convert the DeskI syntax to WebI syntax. Or search for a similar, newer topic where someone already did the conversion.

---

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