Calculating duration between to date time stamps

[#1]

Hi,

I have read just about all of the discussions on this issue, and am not able to resolve my issue.

I am extracting data from MySQL, for the SugarCRM system that we use. The date/time format looks like this:

how can I go ahead to calculate the exact time it took to close the query, if the 'Last modified' field that I use, saves it in the same format.

I have read the Datefield tech brief document trying to get answers, but none of those work. I have attached the qvw. I need the answer given to display as 'hh:mm:Ss'

Thanks

[buzzy996]

try this way,

=Interval(Interval(Sum(ProProductiveTime),'hh:mm:ss') - Interval(Sum(ProNonProductiveTime),'hh:mm:ss'),'hh:mm:ss')

[#3]

Thanks Shiva,

Do I load this in my load statement or expression tab?

[buzzy996]

on expression field,not on edit script.

[#5]

Thanks. works. if I want to now get max/min/avg? just add the to the front of statement?

[buzzy996]

yes,if not works u have little bit twist tht expression.

[#7]

is there no way that I can do this in the load script to create a new field i.e "Total time"?

[buzzy996]

definitely u can do,but i doubt that interval function will work or not though load stmt.

[Anonymous]

The interval() function works perfectly in the load script.  So give it a go and you'll see it works.