I recently struggled with the following challenge in Analysis Services:
In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″.
bing brought me to the following great article, where Mosha explains how [...]
Click here to see the original post