AnsweredAssumed Answered

Activity duration calculation

Question asked by rkalidh87 on Dec 12, 2015
Latest reply on Dec 28, 2015 by CelsoA

Hi,

 

Am trying to write a query to get the total spent hours for each activity in an incident. Below is the query and the out put as follows.

 

select b.id, c.ref_num ,b.call_req_id,b.action_desc,(select DATEADD(s,b.time_stamp+19800,'1970-01-01 00:00:000')) as 'Timestamp' from act_log b inner join stakeholders c on

b.call_req_id=c.persid.

 

Am able to reach till this and please let me know how to get the duration. EX: the initial value should be zero then next difference should be( 400761-400760) 1 min 30 sec.

 

Like wise I should get for individual incident.

 

Outcomes