Found the solution ... http://sqlblog.com/blogs/mosha/archive/2008/09/26/displaying-duration-values-mdx-expressions-in-format-string.aspx

I used the idea given here to create a calculated member with the appropriate FORMAT_STRING MDX expression.

CREATE MEMBER CURRENTCUBE.[MEASURES].[Agent Dur In Call]

AS [MEASURES].[AgentDurInCall],...

Thanks Michael,

I'll try this... Am also going to be looking into other tools and also nto designing a simple user-friendly application that would enable this.

~H

Hi,

I don't think I was clear... I do not have a problem with T-SQL, I know the conversions that can be done using T-SQL. However, I do have a problem...