Number into hours and minutes

[system]

Hello Everyone…
I am new to this forum…I have a requirement where number have to be converted into hours and minutes format…can any body suggest me any idea.
My data provider is excel sheet where these numbers are coming from…

Example:
123minutes into 2.03 or 2:03
179minutes into 2.59 or 2:59

Many Thanks

---

satishvisu (BOB member since 2008-06-19)

[system]

Welcome to B:bob:B!

This topic will give you an idea how to do it:

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)

In the linked post the number of seconds is converted into hh:mm:ss format so you need to tweak it a little bit since you want to convert number of minutes.

---

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

[system]

Thanks Marek Chladny…Its working
You saved my day

Thanks

---

satishvisu (BOB member since 2008-06-19)

[system]

Good to hear that 8)

---

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