Convert Number to hh:mm format

[system]

i’m a n00b in Deski and starting to get into it… How do I convert a number say 75 to hh:mm format? so in this instance 75 will be 01:15 (1hr and 15 minutes)

also, is it possible to add the seconds to it? like 01:15:00?

thanks in anticipation!

---

outatime (BOB member since 2007-11-20)

[system]

Hi,

Have a look at this post:

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]

omg that’s very clever! thanks very much!

---

outatime (BOB member since 2007-11-20)