change milliseconds to XXh XXm XXs (to plot bar chart)

[system]

Hi,

I have to total Active Time in Milliseconds and this can even go to many hours beyond 1 day (24 hours).
For example in some cases on a monthly basis a User can be active on an application up to 50-60 hours. In that case can I get my report to show in following format

50:33:22 or 50H 33M 22S (and still can be used in chart)

What I see as an option is to convert my active time into each of these hours, minutes and seconds individually. But how to use them in a Graph (User name on Y axis and Active time on X axis showing the values)

My Database is SQL Server 2005.

Ram.

---

sramlaxman (BOB member since 2010-11-24)

[system]

Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

120×120 10.4 KB

Hi All, I have an object Active Time in Milliseonds (agrregated). I need to create/change the object to HH:MM:SS format. Please suggest me as my report needs to show in this format. I tried to change format at report level but was not able to do it. Formula would be Milliseconds/86400000 and then change the format of cell to HH:MM:SS But I still get 00:00:00 in report after trying to apply the calculation in the select statement of object and changing the format of object. Thanks Ram sr…

---

Nick Daniels (BOB member since 2002-08-15)