Problem with Time Inteval in crosstab report

[sharu_bs]

Hi all,

Facing following problem in a Crosstab report.

Report shows following data,

Alerts - Rows
Weeks - columns
Measure - Alert Count & Open Duration.

Open Duration is calculated in model and a calculated Query Item is created by subtracting 2 date/time values.
The dataype of this in Framework manager is "time Interval".

In Reportnet, we pull Open Duration from model and put it in measures area.
when I run the above report,

If my time interval is 21 03:19:43:000
The measure is shown as 33,602,000

How can I show the this value as xx days, yy hrs, zz minutes in Report???

I tried formatting the data in Reportnet it didnt work.

Since the value reprasents the time diff in milliseconds... I tried calculating days, hrs and mins from it but for that
if i do (33,602,000 ie,OpenDuration)/1000 to get secs in reportnet Item, I get result as 1.

I am clueless on this and struggling to get any solution.

Pls pls Help me!!!!
Need this ASAP!

Thanks in advance
Sharu