Display time duratoin in hours over 24

[system]

I have a variable which calculates the difference between two date/times. I need to display it in the format of hh:mm. The issue is that when the difference is greater than 24 hours, it is not displaying properly. In excel, this is solved by applying the formatting context of [h]:mm. When I output the results to Excel and apply the formatting the results are right, so i know i am doing the calculation correctly. Any suggestions?

---

hcadar1 (BOB member since 2008-04-25)

[system]

Hi,

Let us know what is the desired format of the variable when it exceeds 24 hours.

And have a look also here, it may help:

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)

---

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

[system]

Thanks for the link. I am trying it right now, as an example if the difference between the two dates is 39 hours and 45 minutes the displated result should appear as 39:45

---

hcadar1 (BOB member since 2008-04-25)

[system]

Then try also the formula mentioned in this post:

Time Format

Hai, How can I convert a Number to Time Format in BO 6.5 Full Client ? I have an object (average_time) which retreives the number values , for ex 10,30,etc. How Can I convert these into HH24:MI:SS format in the Report? I have to use this variable in another variable ,so some conversion has to be done. Can Any one pls provide some suggestions to this. Thanks Sai. Sai2255 (BOB member since 2007-05-15)

---

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