Hi Gutis,
Tried the fomula used in the link shared as below for the field time_spent from act_log table. however I am getting the error
Formulat to convert second to HH:MM:SS
concat(convert(varchar(5),floor(@Select(Admin Helpdesk\TimeSpent))/3600)),':',RIGHT(concat('0',convert(varchar(2),floor((@Select(Admin Helpdesk\TimeSpent))/60)-(60*floor(@Select(Admin Helpdesk\TimeSpent)))/3600)),2),':',RIGHT(concat('0',convert(varchar(2),floor(@Select(Admin Helpdesk\TimeSpent))-(60*floor(@Select(Admin Helpdesk\TimeSpent))/60)),2))
Error:
AHD12028:PdmSeconds argument alg.time_spent has invalid integer at time_spent- state:12028
Please suggest.