Create a calculated field to get the time difference in second from both the dates.
DATEDIFF('second',[Start Date],[End Date])
Now Create another field to get the
IIF([Seconds] % 60 == 60,0,[Seconds] % 60)// seconds
+ IIF(INT([Seconds]/60) %60 == 60, 0, INT([Seconds]/60) %60) * 100 //minutes
+ IIF(INT([Seconds]/3600) % 24 == 0, 0, INT([Seconds]/3600) % 24) * 10000 //hours
+ INT([Seconds]/86400) * 1000000 // days
Once done then change the number format of the above field
Hope this help.
Can you attache the .twbx (packaged) workbook once again?
I figure out what went wrong, in my data source there are two dates (start and end) are repeating the same Thus, its summing up those 2 dates ended up 16 hours 50 mins.
Thankyou very much for your reply.