Hi I am having the following problems in time resolution,but the formula is not accurate.I need time in Hours:minutes:seconds based on the formula
TimeTaken:=@If(r_closedon!=“” & r_escalatedon=“”;(r_closedon - r_assignedon);r_assignedon!=“”
& r_escalatedon!=“”;(r_closedon - r_escalatedon);(r_closedon - @Date(r_assignedon)));
@Text(@Integer((@Integer(TimeTaken/86400)*86400)/3600)) + " Hours "
@Text(@Integer((TimeTaken - (@Integer(TimeTaken /3600)*3600)) /60)) + " Minutes "
@Text(@Integer((TimeTaken - (@Integer(TimeTaken /60)*60)))) + " Seconds"