Calculate total hh:mm in BI

[bomberchia]

Hi Team,

I have tried creating 'sumx' as a measure to calculate the total talk time where the formula is "total_talk_duration" + "Inbound_duration" however the calculation does not seem to work accurately when i tried tallying.

Agents	total_talk_duration	inbound_duration
Crystal	01:09:44 AM​	12:19:53 AM​
Peter	03:16:24 AM​	12:00:14 AM​
Jo	03:02:08 AM​	12:01:59 AM​
James	02:27:04 AM​	12:01:44 AM​
Crystal	01:10:58 AM​	12:12:36 AM​
Peter	01:18:00 AM​	12:06:54 AM​
Jo	02:23:54 AM​	12:37:26 AM​
Crystal	02:49:45 AM​	12:14:45 AM​
Peter	02:47:28 AM​	12:00:15 AM​

 

[mart37]

=FORMAT(([total_talk_duration]-INT([total_talk_duration]))+([inbound_duration]-INT([inbound_duration]));"HH:mm:ss")