Display number in a time format

[system]

Hello all,
I’m not sure if this is possible, but does anyone know how to display a number result (45,393.55 minutes) as a time format hh:mm:ss?

Thanks!!

---

eddyc99 (BOB member since 2007-09-06)

[system]

Welcome to B:bob:B!

Please have a look here:

Convert minutes to Weeks/Days/Hours/Minutes

Hey guys, I have a column in the SQL Server database which tells me the number of minutes between 2 dates. Could anyone tell me how to convert that to the format; 3 Years, 2 Months, 1 Week, 2 Days, 13 Hours, 52 Minutes. I get lost very quickly. Cheers, Stuart stuartgmilton (BOB member since 2003-01-30)

There is a similar conversion (from minutes to days, hours, minutes). You need to modify it to get hours:minutes:seconds
And check also this one:

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]

I think you can do that…use the following formula:

i am not giving you the whole formula. but u can define based on this:

=Floor([45,393.55]/60)+":"+Mod([45,393.55];60) etc…
u have to use “if” function there…

---

rj_srnth (BOB member since 2006-12-09)

[system]

Yes you will need to investigate using Floor as a command, but also doing multiples of 60, this will work out what you are trying to do.

However the very first thing I would suggest you do is to use the search function for both Webi and Deski and you will find the answer as this sort of question has been asked in the past.

---

plessiusa (BOB member since 2004-03-22)

[system]

Thank you all for the prompt replies. These have been very helpful.

---

eddyc99 (BOB member since 2007-09-06)