KB208842: How to calculate data of time date type (HH:MM:SS) in Microsoft SQL Server using MicroStrategy Developer 9.x.

The following grid shows the metrics mapped to the time date type column are calculated in the derived metric and subtotal.

 
 
The following example shows how to create the metrics to calculate on Analytical Engine.
 

• Create the attributes for the columns. (Convert the time to seconds)
  

• 
  Time1: ApplySimple("datediff(second,0, #0)",time1) 
  Time2: ApplySimple("datediff(second,0, #0)",time2)

  
   
  
• Create the metrics based off the attributes above. (divide by seconds in a day)
  

• 
  time1: (Max() {~} / 86400) 
  time2: (Max() {~} / 86400)