Minuts to HH:MM format

[system]

Hello Experts,

Please suggest how to change the number of minutes into HH:MM format like suppose I have minutes count 130 then I want to display it in 02:10.

Please assist.

---

vijesh.chandra (BOB member since 2009-05-29)

[system]

Divide the 130 by 60 for hours. 130 Mod 60 will give you the minutes.

P.S: Please refrain from using ASAP, urgent, etc,… This is a voluntary forum. For urgent issues, contact technical support. Please edit your post and remove asap from the post.

---

Jansi (BOB member since 2008-05-12)

[system]

Hi Vijesh,

The formula for converting the number of seconds into HH:MM:SS format is described 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)

You need to tweak that formula slightly because you have minutes, not seconds.

---

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

[system]

Thanks Jansi.

It worked for me

Thanks

---

vijesh.chandra (BOB member since 2009-05-29)