How to convert seconds into number

[#1]

Hi All,

I am using interval function to find the difference between two time stamps in seconds like(Interval(LOAD_STATUS_DT-INSERT_DT ,'ss') .But when i am calculating its still considers as time but i need in number to calculate the average.

Example :- i using above formula in scripts now i have two columns 1.No of records,2.Exec time in sec

Header 1	Header 2	Header 3
1	10000	94
2	200000	98

In expression =Sum(Header2)/Sum(Header3).It suppose to take  210000)/104

but it is actually doing 210000/0.02.58 Am

Could you please help me how to calculate average .

Thanks,

Rahul

[#2 · Accepted solution]

got it ans Num#(Text(Interval(LOAD_STATUS_DT-INSERT_DT ,'ss')))